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_REQUISITIONS_INTERFACE_ALL

Product:	PO - Purchasing
Description:	Requisition Import interface table
Implementation/DBA Data:	PO.PO_REQUISITIONS_INTERFACE_ALL

Primary Key: PO_REQ_INTERFACE_PK

TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PO_REQUISITIONS_INTERFACE_ALL	PO_REQUISITION_HEADERS_ALL	PO_REQUISITIONS_INTERFACE_ALL.REQUISITION_HEADER_ID
PO_REQUISITIONS_INTERFACE_ALL	MTL_CATEGORIES_B	PO_REQUISITIONS_INTERFACE_ALL.CATEGORY_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_LINE_TYPES_B	PO_REQUISITIONS_INTERFACE_ALL.LINE_TYPE_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_UN_NUMBERS_B	PO_REQUISITIONS_INTERFACE_ALL.UN_NUMBER_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_HAZARD_CLASSES_B	PO_REQUISITIONS_INTERFACE_ALL.HAZARD_CLASS_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_REQUISITION_LINES_ALL	PO_REQUISITIONS_INTERFACE_ALL.REQUISITION_LINE_ID
PO_REQUISITIONS_INTERFACE_ALL	MTL_SECONDARY_INVENTORIES	PO_REQUISITIONS_INTERFACE_ALL.SOURCE_SUBINVENTORY PO_REQUISITIONS_INTERFACE_ALL.SOURCE_ORGANIZATION_ID
PO_REQUISITIONS_INTERFACE_ALL	MTL_SECONDARY_INVENTORIES	PO_REQUISITIONS_INTERFACE_ALL.DESTINATION_SUBINVENTORY PO_REQUISITIONS_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_AGENTS	PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_BUYER_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_VENDORS	PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_VENDOR_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_VENDOR_SITES_ALL	PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_VENDOR_SITE_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_REQ_DISTRIBUTIONS_ALL	PO_REQUISITIONS_INTERFACE_ALL.REQ_DISTRIBUTION_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_VENDOR_CONTACTS	PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_VENDOR_CONTACT_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE1_ID
PO_REQUISITIONS_INTERFACE_ALL	GL_CODE_COMBINATIONS	PO_REQUISITIONS_INTERFACE_ALL.ACCRUAL_ACCOUNT_ID
PO_REQUISITIONS_INTERFACE_ALL	GL_CODE_COMBINATIONS	PO_REQUISITIONS_INTERFACE_ALL.VARIANCE_ACCOUNT_ID
PO_REQUISITIONS_INTERFACE_ALL	GL_CODE_COMBINATIONS	PO_REQUISITIONS_INTERFACE_ALL.BUDGET_ACCOUNT_ID
PO_REQUISITIONS_INTERFACE_ALL	FND_CURRENCIES	PO_REQUISITIONS_INTERFACE_ALL.CURRENCY_CODE
PO_REQUISITIONS_INTERFACE_ALL	GL_DAILY_CONVERSION_TYPES	PO_REQUISITIONS_INTERFACE_ALL.RATE_TYPE
PO_REQUISITIONS_INTERFACE_ALL	PA_PROJECTS_ALL	PO_REQUISITIONS_INTERFACE_ALL.PROJECT_ID
PO_REQUISITIONS_INTERFACE_ALL	PA_TASKS	PO_REQUISITIONS_INTERFACE_ALL.TASK_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE2_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE3_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE4_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE5_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE6_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE7_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE8_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE9_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_NOTES	PO_REQUISITIONS_INTERFACE_ALL.NOTE10_ID
PO_REQUISITIONS_INTERFACE_ALL	PA_EXPENDITURE_TYPES	PO_REQUISITIONS_INTERFACE_ALL.EXPENDITURE_TYPE
PO_REQUISITIONS_INTERFACE_ALL	MTL_KANBAN_CARDS	PO_REQUISITIONS_INTERFACE_ALL.KANBAN_CARD_ID
PO_REQUISITIONS_INTERFACE_ALL	GL_CODE_COMBINATIONS	PO_REQUISITIONS_INTERFACE_ALL.CHARGE_ACCOUNT_ID
PO_INTERFACE_ERRORS	PO_REQUISITIONS_INTERFACE_ALL	PO_INTERFACE_ERRORS.INTERFACE_TRANSACTION_ID