Home » Applications » Oracle Fusion Apps & E-Business Suite » How to link Sales Order to AP (Oracle EBS 11.5 Windows7)
How to link Sales Order to AP [message #558914] Wed, 27 June 2012 05:19 Go to next message
wency
Messages: 437
Registered: April 2006
Location: Philippines
Senior Member

Hi,

I need to get the sales order number based on AP query. I acn't seem to find tables and its connection to AP. Anyone can help?

TIA
Re: How to link Sales Order to AP [message #559120 is a reply to message #558914] Thu, 28 June 2012 21:58 Go to previous message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
Hi, here is a query that I used today to write a join from an existing query that a colleague wrote yesterday but was out of the office today. I was looking for a join of the CMS_META_DATA table with the CONTENT table and for club_id=1004. The query with the join already written just popped up out of the sqlarea memory.

SQL > @v$sqlarea_INPUT_SQL_TO_LOOK_FOR.sql
Enter value for sql_to_look_for: CMS_META_DATA%content%club_id=1004

HASH_VALUE SQL_TEXT
---------- --------------------------------------------------------
2190950880 select distinct a.CMSITEMPATH||'@'|| a.EXTERNALID from C

SQL > list
  1  select hash_value,sql_text
  2  from v$sqlarea s,v$instance i
  3  where upper(sql_text) like upper('%&sql_to_look_for%')

And I displayed the full sql_text with the following.

SQL > @hash 2190950880

SQL_TEXT
----------------------------------------------------------------
select distinct a.CMSITEMPATH||'@'|| a.EXTERNALID from CMS_META_
DATA a, content b where b.CLUB_ID=1004 and b.EXTERNALID = a.EXTE
RNALID and a.ENTITYTYPE in ('com.nfl.dm.clubsites.core.model.Ima
ge','com.nfl.dm.clubsites.core.model.ContentList')

SQL > list
  1  select sql_text
  2  from v$sqltext b
  3  where b.hash_value=&1
  4* order by b.piece
Previous Topic: Oracle Alert errors out when called from PL/sql
Next Topic: Need help for queries
Goto Forum:
  


Current Time: Thu Sep 18 17:38:04 CDT 2014

Total time taken to generate the page: 0.11260 seconds