eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PO_HEADERS_ALL

Product:	PO - Purchasing
Description:	Document headers (for purchase orders, purchase agreements, quotations, RFQs)
Implementation/DBA Data:	PO.PO_HEADERS_ALL

Primary Key: PO_HEADERS_PK

PO_HEADER_ID

Primary Key: PO_HEADERS_UK1

SEGMENT1

Foreign Keys

Table	Foreign Table	Foreign Key Column
PO_HEADERS_ALL	PO_VENDORS	PO_HEADERS_ALL.VENDOR_ID
PO_HEADERS_ALL	HR_LOCATIONS_ALL	PO_HEADERS_ALL.SHIP_TO_LOCATION_ID
PO_HEADERS_ALL	PO_AGENTS	PO_HEADERS_ALL.AGENT_ID
PO_HEADERS_ALL	HR_LOCATIONS_ALL	PO_HEADERS_ALL.BILL_TO_LOCATION_ID
PO_HEADERS_ALL	PO_VENDOR_SITES_ALL	PO_HEADERS_ALL.VENDOR_SITE_ID
PO_HEADERS_ALL	PO_VENDOR_CONTACTS	PO_HEADERS_ALL.VENDOR_CONTACT_ID
PO_HEADERS_ALL	PO_HEADERS_ALL	PO_HEADERS_ALL.FROM_HEADER_ID
PO_HEADERS_ALL	GL_DAILY_CONVERSION_TYPES	PO_HEADERS_ALL.RATE_TYPE
PO_HEADERS_ALL	FND_CURRENCIES	PO_HEADERS_ALL.CURRENCY_CODE
AHL_OSP_ORDERS_B	PO_HEADERS_ALL	AHL_OSP_ORDERS_B.PO_HEADER_ID
AP_INVOICES_ALL	PO_HEADERS_ALL	AP_INVOICES_ALL.PO_HEADER_ID
FA_ASSET_INVOICES	PO_HEADERS_ALL	FA_ASSET_INVOICES.PO_NUMBER
FA_MC_ASSET_INVOICES	PO_HEADERS_ALL	FA_MC_ASSET_INVOICES.PO_NUMBER
IGC_CC_HEADERS_INTERFACE	PO_HEADERS_ALL	IGC_CC_HEADERS_INTERFACE.INTERFACE_HEADER_ID
IGC_CC_HEADERS	PO_HEADERS_ALL	IGC_CC_HEADERS.CC_HEADER_ID
JAI_AP_MATCH_INV_TAXES	PO_HEADERS_ALL	JAI_AP_MATCH_INV_TAXES.PO_HEADER_ID
JAI_CMN_LINES	PO_HEADERS_ALL	JAI_CMN_LINES.PO_HEADER_ID
JAI_CMN_RG_23AC_I_TRXS	PO_HEADERS_ALL	JAI_CMN_RG_23AC_I_TRXS.PO_HEADER_ID
JAI_ENCUM_TAX_DETAILS	PO_HEADERS_ALL	JAI_ENCUM_TAX_DETAILS.DOC_HEADER_ID
JAI_PO_COPYDOC_T	PO_HEADERS_ALL	JAI_PO_COPYDOC_T.PO_HEADER_ID
JAI_PO_COPYDOC_T	PO_HEADERS_ALL	JAI_PO_COPYDOC_T.FROM_HEADER_ID
JAI_PO_COPY_T	PO_HEADERS_ALL	JAI_PO_COPY_T.PO_HEADER_ID
JAI_PO_LINE_LOCATIONS	PO_HEADERS_ALL	JAI_PO_LINE_LOCATIONS.PO_HEADER_ID
JAI_PO_OSP_HDRS	PO_HEADERS_ALL	JAI_PO_OSP_HDRS.PO_HEADER_ID
JAI_PO_QUOT_LINES_T	PO_HEADERS_ALL	JAI_PO_QUOT_LINES_T.PO_HEADER_ID
JAI_PO_QUOT_LINES_T	PO_HEADERS_ALL	JAI_PO_QUOT_LINES_T.FROM_HEADER_ID
JAI_PO_REP_PRRG_T	PO_HEADERS_ALL	JAI_PO_REP_PRRG_T.PO_HEADER_ID
JAI_PO_REQUEST_T	PO_HEADERS_ALL	JAI_PO_REQUEST_T.PO_HEADER_ID
JAI_PO_TAXES	PO_HEADERS_ALL	JAI_PO_TAXES.PO_HEADER_ID
JAI_RETRO_LINE_CHANGES	PO_HEADERS_ALL	JAI_RETRO_LINE_CHANGES.DOC_HEADER_ID
JAI_RETRO_LINE_CHANGES	PO_HEADERS_ALL	JAI_RETRO_LINE_CHANGES.FROM_HEADER_ID
MTL_KANBAN_CARD_ACTIVITY	PO_HEADERS_ALL	MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_HEADER_ID
MTL_SUPPLY	PO_HEADERS_ALL	MTL_SUPPLY.PO_HEADER_ID
MTL_USER_SUPPLY	PO_HEADERS_ALL	MTL_USER_SUPPLY.SOURCE_ID
IGC_CC_ARC_HEADERS	PO_HEADERS_ALL	IGC_CC_ARC_HEADERS.CC_HEADER_ID
OE_DROP_SHIP_SOURCES	PO_HEADERS_ALL	OE_DROP_SHIP_SOURCES.PO_HEADER_ID
PA_BC_COMMITMENTS_ALL	PO_HEADERS_ALL	PA_BC_COMMITMENTS_ALL.DOCUMENT_HEADER_ID
PA_BC_PACKETS	PO_HEADERS_ALL	PA_BC_PACKETS.DOCUMENT_HEADER_ID
PA_CI_SUPPLIER_DETAILS	PO_HEADERS_ALL	PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID
PA_TRANSACTION_INTERFACE_ALL	PO_HEADERS_ALL	PA_TRANSACTION_INTERFACE_ALL.PO_HEADER_ID
PA_TXN_INTERFACE_AUDIT_AR	PO_HEADERS_ALL	PA_TXN_INTERFACE_AUDIT_AR.PO_HEADER_ID
PA_TXN_INTERFACE_AUDIT_ALL	PO_HEADERS_ALL	PA_TXN_INTERFACE_AUDIT_ALL.PO_HEADER_ID
PJM_DEFAULT_TASKS	PO_HEADERS_ALL	PJM_DEFAULT_TASKS.PO_HEADER_ID
PO_ACCRUAL_RECONCILE_TEMP_ALL	PO_HEADERS_ALL	PO_ACCRUAL_RECONCILE_TEMP_ALL.PO_HEADER_ID
PO_ACCEPTANCES	PO_HEADERS_ALL	PO_ACCEPTANCES.PO_HEADER_ID
PO_ACCRUAL_WRITE_OFFS_ALL	PO_HEADERS_ALL	PO_ACCRUAL_WRITE_OFFS_ALL.PO_HEADER_ID
PO_ACTION_HISTORY	PO_HEADERS_ALL	PO_ACTION_HISTORY.OBJECT_ID
PO_AUTOSOURCE_DOCUMENTS_ALL	PO_HEADERS_ALL	PO_AUTOSOURCE_DOCUMENTS_ALL.DOCUMENT_HEADER_ID
PO_DISTRIBUTIONS_ARCHIVE_ALL	PO_HEADERS_ALL	PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_HEADER_ID
PO_DISTRIBUTIONS_DRAFT_ALL	PO_HEADERS_ALL	PO_DISTRIBUTIONS_DRAFT_ALL.PO_HEADER_ID
PO_DISTRIBUTIONS_ALL	PO_HEADERS_ALL	PO_DISTRIBUTIONS_ALL.PO_HEADER_ID
PO_HEADERS_ARCHIVE_ALL	PO_HEADERS_ALL	PO_HEADERS_ARCHIVE_ALL.FROM_HEADER_ID
PO_HEADERS_DRAFT_ALL	PO_HEADERS_ALL	PO_HEADERS_DRAFT_ALL.FROM_HEADER_ID
PO_HEADERS_ALL	PO_HEADERS_ALL	PO_HEADERS_ALL.FROM_HEADER_ID
PO_LINES_ARCHIVE_ALL	PO_HEADERS_ALL	PO_LINES_ARCHIVE_ALL.PO_HEADER_ID
PO_LINES_ARCHIVE_ALL	PO_HEADERS_ALL	PO_LINES_ARCHIVE_ALL.FROM_HEADER_ID
PO_LINES_DRAFT_ALL	PO_HEADERS_ALL	PO_LINES_DRAFT_ALL.FROM_HEADER_ID
PO_LINES_ALL	PO_HEADERS_ALL	PO_LINES_ALL.FROM_HEADER_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL	PO_HEADERS_ALL	PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_HEADER_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL	PO_HEADERS_ALL	PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_HEADER_ID
PO_LINE_LOCATIONS_DRAFT_ALL	PO_HEADERS_ALL	PO_LINE_LOCATIONS_DRAFT_ALL.PO_HEADER_ID
PO_LINE_LOCATIONS_DRAFT_ALL	PO_HEADERS_ALL	PO_LINE_LOCATIONS_DRAFT_ALL.FROM_HEADER_ID
PO_LINE_LOCATIONS_ALL	PO_HEADERS_ALL	PO_LINE_LOCATIONS_ALL.PO_HEADER_ID
PO_LINE_LOCATIONS_ALL	PO_HEADERS_ALL	PO_LINE_LOCATIONS_ALL.FROM_HEADER_ID
PO_MASSCANCEL_INTERIM	PO_HEADERS_ALL	PO_MASSCANCEL_INTERIM.OBJECT_ID
PO_MASSCANCEL_INTERIM	PO_HEADERS_ALL	PO_MASSCANCEL_INTERIM.OBJECT_NUMBER
PO_NOTIFICATIONS_ALL	PO_HEADERS_ALL	PO_NOTIFICATIONS_ALL.OBJECT_ID
PO_NOTIFICATION_CONTROLS	PO_HEADERS_ALL	PO_NOTIFICATION_CONTROLS.PO_HEADER_ID
PO_NOTIFICATION_CTRL_DRAFT	PO_HEADERS_ALL	PO_NOTIFICATION_CTRL_DRAFT.PO_HEADER_ID
PO_PURGE_PO_LIST	PO_HEADERS_ALL	PO_PURGE_PO_LIST.PO_HEADER_ID
PO_RELEASES_ALL	PO_HEADERS_ALL	PO_RELEASES_ALL.PO_HEADER_ID
PO_REQEXPRESS_LINES_ALL	PO_HEADERS_ALL	PO_REQEXPRESS_LINES_ALL.PO_HEADER_ID
PO_REQUISITION_LINES_ALL	PO_HEADERS_ALL	PO_REQUISITION_LINES_ALL.BLANKET_PO_HEADER_ID
PO_RFQ_VENDORS	PO_HEADERS_ALL	PO_RFQ_VENDORS.PO_HEADER_ID
RCV_ACCOUNTING_EVENTS	PO_HEADERS_ALL	RCV_ACCOUNTING_EVENTS.PO_HEADER_ID
RCV_SHIPMENT_LINES	PO_HEADERS_ALL	RCV_SHIPMENT_LINES.PO_HEADER_ID
RCV_SUPPLY	PO_HEADERS_ALL	RCV_SUPPLY.PO_HEADER_ID
RCV_TRANSACTIONS	PO_HEADERS_ALL	RCV_TRANSACTIONS.PO_HEADER_ID
RCV_TRANSACTIONS_INTERFACE	PO_HEADERS_ALL	RCV_TRANSACTIONS_INTERFACE.PO_HEADER_ID
SO_DROP_SHIP_SOURCES	PO_HEADERS_ALL	SO_DROP_SHIP_SOURCES.PO_HEADER_ID
WIP_COST_TXN_INTERFACE	PO_HEADERS_ALL	WIP_COST_TXN_INTERFACE.PO_HEADER_ID
WIP_TRANSACTIONS	PO_HEADERS_ALL	WIP_TRANSACTIONS.PO_HEADER_ID