OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Where is Purchase Order Number in AP

Home » Applications » Oracle Fusion Apps & E-Business Suite » Where is Purchase Order Number in AP_INVOICES ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Where is Purchase Order Number in AP_INVOICES ? [message #174740]

Tue, 30 May 2006 07:23

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 31 20:42:58 CDT 2024