Home » Applications » Oracle Fusion Apps & E-Business Suite » Where is Purchase Order Number in AP_INVOICES ?
Where is Purchase Order Number in AP_INVOICES ? [message #174740] Tue, 30 May 2006 07:23 Go to next message
prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore
Member
Dear All,

Please correct me if i am wrong.

When we are transfering the order details(OM to AR) to RA_CUSTOMER_TRX_ALL the column INTERFACE_HEADER_ATTRIBUTE1 will have the Order Number. Is it Right?

When we are transfering the Purchase Order details (PO to AP) to AP_INVOICES_ALL which column will have the Purchase Order Number ?


Thanks in advance.

Regards,
Prabhu T

Report message to a moderator

Re: Where is Purchase Order Number in AP_INVOICES ? [message #174765 is a reply to message #174740] Tue, 30 May 2006 08:44 Go to previous messageGo to next message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Did you look at etrm ? Did you look at foreign keys ?
AP_INVOICES_ALL PO_HEADERS_ALL AP_INVOICES_ALL.PO_HEADER_ID

Report message to a moderator

Re: Where is Purchase Order Number in AP_INVOICES ? [message #174958 is a reply to message #174740] Wed, 31 May 2006 03:20 Go to previous message
manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC
Senior Member
PO_DISTRIBUTION_ID goes to AP_INVOICE_DISTRIBUTIONS_ALL table. From there you need to link back to PO_HEADERS_ALL table to find PO number.

[Updated on: Wed, 31 May 2006 03:22]

Report message to a moderator

Previous Topic: parameter defaulting in request submission form
Next Topic: SQL * Loader Control file- While Registering into APPS where we need to specify ROWS,LOAD,SKIP ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 13:47:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.