Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, November 23, 2011

PO_HEADERS_INTERFACE

Purchasing
Table Or View: Table

Important columns: 
INTERFACE_HEADER_ID : Interface header unique identifier
BATCH_ID : unique identifier
INTERFACE_SOURCE_CODE :  Interface source
PROCESS_CODE : Interface record status
ACTION : Interface action - ADD, NEW
GROUP_CODE :  Requisition line grouping
ORG_ID :  Operating unit unique identifier
DOCUMENT_TYPE_CODE :  Document type to be created: PO or RFQ
DOCUMENT_SUBTYPE : Document subtype
DOCUMENT_NUM :  Document number

Description: 
PO_HEADERS_INTERFACE is the interface table that holds header information for the PDOI program to create standard/blanket purchase  orders and catalog quotations.
The PDOI program validates your data, derives or defaults additional  information and writes an error message for every validation that  fails into the PO_INTERFACE_ERRORS table

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect