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_DISTRIBUTIONS_ALL

Product:	PO - Purchasing
Description:	Purchase order distributions
Implementation/DBA Data:	PO.PO_DISTRIBUTIONS_ALL

Primary Key: PO_DISTRIBUTIONS_PK

PO_DISTRIBUTION_ID

Primary Key: PO_DISTRIBUTIONS_UK1

PO_HEADER_ID
PO_LINE_ID
LINE_LOCATION_ID
DISTRIBUTION_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
PO_DISTRIBUTIONS_ALL	PO_HEADERS_ALL	PO_DISTRIBUTIONS_ALL.PO_HEADER_ID
PO_DISTRIBUTIONS_ALL	MTL_SECONDARY_INVENTORIES	PO_DISTRIBUTIONS_ALL.DESTINATION_SUBINVENTORY PO_DISTRIBUTIONS_ALL.DESTINATION_ORGANIZATION_ID
PO_DISTRIBUTIONS_ALL	BOM_RESOURCES	PO_DISTRIBUTIONS_ALL.BOM_RESOURCE_ID
PO_DISTRIBUTIONS_ALL	GL_CODE_COMBINATIONS	PO_DISTRIBUTIONS_ALL.BUDGET_ACCOUNT_ID
PO_DISTRIBUTIONS_ALL	GL_CODE_COMBINATIONS	PO_DISTRIBUTIONS_ALL.ACCRUAL_ACCOUNT_ID
PO_DISTRIBUTIONS_ALL	PO_LINES_ALL	PO_DISTRIBUTIONS_ALL.PO_LINE_ID
PO_DISTRIBUTIONS_ALL	GL_CODE_COMBINATIONS	PO_DISTRIBUTIONS_ALL.VARIANCE_ACCOUNT_ID
PO_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ALL.SOURCE_DISTRIBUTION_ID
PO_DISTRIBUTIONS_ALL	PA_TASKS	PO_DISTRIBUTIONS_ALL.TASK_ID
PO_DISTRIBUTIONS_ALL	PO_LINE_LOCATIONS_ALL	PO_DISTRIBUTIONS_ALL.LINE_LOCATION_ID
PO_DISTRIBUTIONS_ALL	PO_RELEASES_ALL	PO_DISTRIBUTIONS_ALL.PO_RELEASE_ID
PO_DISTRIBUTIONS_ALL	PO_REQ_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID
PO_DISTRIBUTIONS_ALL	GL_SETS_OF_BOOKS	PO_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
PO_DISTRIBUTIONS_ALL	GL_CODE_COMBINATIONS	PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID
%	PO_DISTRIBUTIONS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
IGC_CC_DET_PF	PO_DISTRIBUTIONS_ALL	IGC_CC_DET_PF.CC_DET_PF_LINE_ID
CST_AP_PO_RECONCILIATION	PO_DISTRIBUTIONS_ALL	CST_AP_PO_RECONCILIATION.PO_DISTRIBUTION_ID
CST_AP_VARIANCE_LINES	PO_DISTRIBUTIONS_ALL	CST_AP_VARIANCE_LINES.PO_DISTRIBUTION_ID
CST_MISC_RECONCILIATION	PO_DISTRIBUTIONS_ALL	CST_MISC_RECONCILIATION.PO_DISTRIBUTION_ID
CST_RECONCILIATION_SUMMARY	PO_DISTRIBUTIONS_ALL	CST_RECONCILIATION_SUMMARY.PO_DISTRIBUTION_ID
CST_WRITE_OFFS	PO_DISTRIBUTIONS_ALL	CST_WRITE_OFFS.PO_DISTRIBUTION_ID
FA_ASSET_INVOICES	PO_DISTRIBUTIONS_ALL	FA_ASSET_INVOICES.PO_DISTRIBUTION_ID
FA_MASSADD_REP_ITF	PO_DISTRIBUTIONS_ALL	FA_MASSADD_REP_ITF.PO_DISTRIBUTION_ID
FA_MASS_ADDITIONS	PO_DISTRIBUTIONS_ALL	FA_MASS_ADDITIONS.PO_DISTRIBUTION_ID
FA_MC_ASSET_INVOICES	PO_DISTRIBUTIONS_ALL	FA_MC_ASSET_INVOICES.PO_DISTRIBUTION_ID
FV_INV_SELECTED_DUEDATE	PO_DISTRIBUTIONS_ALL	FV_INV_SELECTED_DUEDATE.PO_DISTRIBUTION_ID
GMS_AWARD_DISTRIBUTIONS	PO_DISTRIBUTIONS_ALL	GMS_AWARD_DISTRIBUTIONS.PO_DISTRIBUTION_ID
JAI_AP_MATCH_ERS_T	PO_DISTRIBUTIONS_ALL	JAI_AP_MATCH_ERS_T.PO_DISTRIBUTION_ID
JAI_AP_MATCH_INV_TAXES	PO_DISTRIBUTIONS_ALL	JAI_AP_MATCH_INV_TAXES.PO_DISTRIBUTION_ID
JAI_ENCUM_TAX_DETAILS	PO_DISTRIBUTIONS_ALL	JAI_ENCUM_TAX_DETAILS.DISTRIBUTION_ID
JAI_PO_OSP_LINES	PO_DISTRIBUTIONS_ALL	JAI_PO_OSP_LINES.PO_DISTRIBUTION_ID
JAI_PO_REP_PRRG_T	PO_DISTRIBUTIONS_ALL	JAI_PO_REP_PRRG_T.PO_DISTRIBUTION_ID
MTL_KANBAN_CARD_ACTIVITY	PO_DISTRIBUTIONS_ALL	MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_DETAIL_ID
MTL_SUPPLY	PO_DISTRIBUTIONS_ALL	MTL_SUPPLY.PO_DISTRIBUTION_ID
IGC_CC_ARC_DET_PF	PO_DISTRIBUTIONS_ALL	IGC_CC_ARC_DET_PF.CC_DET_PF_LINE_ID
IGC_CC_DET_PF_INTERFACE	PO_DISTRIBUTIONS_ALL	IGC_CC_DET_PF_INTERFACE.INTERFACE_DET_PF_LINE_ID
PA_BC_COMMITMENTS_ALL	PO_DISTRIBUTIONS_ALL	PA_BC_COMMITMENTS_ALL.DOCUMENT_DISTRIBUTION_ID
PA_BC_COMMITMENTS_ALL	PO_DISTRIBUTIONS_ALL	PA_BC_COMMITMENTS_ALL.DOCUMENT_DISTRIBUTION_ID
PA_BC_PACKETS	PO_DISTRIBUTIONS_ALL	PA_BC_PACKETS.DOCUMENT_DISTRIBUTION_ID
PA_BC_COMMITMENTS_ALL	PO_DISTRIBUTIONS_ALL	PA_BC_COMMITMENTS_ALL.PDL_PO_DISTRIBUTION_ID
PO_ACCRUAL_RECONCILE_TEMP_ALL	PO_DISTRIBUTIONS_ALL	PO_ACCRUAL_RECONCILE_TEMP_ALL.PO_DISTRIBUTION_ID
PO_ACCRUAL_WRITE_OFFS_ALL	PO_DISTRIBUTIONS_ALL	PO_ACCRUAL_WRITE_OFFS_ALL.PO_DISTRIBUTION_ID
PO_DISTRIBUTIONS_ARCHIVE_ALL	PO_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_DISTRIBUTION_ID
PO_DISTRIBUTIONS_ARCHIVE_ALL	PO_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ARCHIVE_ALL.SOURCE_DISTRIBUTION_ID
PO_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ALL.SOURCE_DISTRIBUTION_ID
RCV_ACCOUNTING_EVENTS	PO_DISTRIBUTIONS_ALL	RCV_ACCOUNTING_EVENTS.PO_DISTRIBUTION_ID
RCV_SHIPMENT_LINES	PO_DISTRIBUTIONS_ALL	RCV_SHIPMENT_LINES.PO_DISTRIBUTION_ID
RCV_SUPPLY	PO_DISTRIBUTIONS_ALL	RCV_SUPPLY.PO_DISTRIBUTION_ID
RCV_TRANSACTIONS	PO_DISTRIBUTIONS_ALL	RCV_TRANSACTIONS.PO_DISTRIBUTION_ID
RCV_TRANSACTIONS_INTERFACE	PO_DISTRIBUTIONS_ALL	RCV_TRANSACTIONS_INTERFACE.PO_DISTRIBUTION_ID