FND Design Data [Home] [Help]

Table: PO_DISTRIBUTIONS_ALL

Product: PO - Purchasing
Description: Purchase order distributions
Implementation/DBA Data: TablePO.PO_DISTRIBUTIONS_ALL
Primary Key: PO_DISTRIBUTIONS_PK
  1. ColumnPO_DISTRIBUTION_ID
Primary Key: PO_DISTRIBUTIONS_UK1
  1. ColumnPO_HEADER_ID
  2. ColumnPO_LINE_ID
  3. ColumnLINE_LOCATION_ID
  4. ColumnDISTRIBUTION_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_DISTRIBUTIONS_ALL FK Joins to TablePO_HEADERS_ALL PO_DISTRIBUTIONS_ALL.PO_HEADER_ID
PO_DISTRIBUTIONS_ALL FK Joins to TableMTL_SECONDARY_INVENTORIES PO_DISTRIBUTIONS_ALL.DESTINATION_SUBINVENTORY
PO_DISTRIBUTIONS_ALL.DESTINATION_ORGANIZATION_ID
PO_DISTRIBUTIONS_ALL FK Joins to TableBOM_RESOURCES PO_DISTRIBUTIONS_ALL.BOM_RESOURCE_ID
PO_DISTRIBUTIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS PO_DISTRIBUTIONS_ALL.BUDGET_ACCOUNT_ID
PO_DISTRIBUTIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS PO_DISTRIBUTIONS_ALL.ACCRUAL_ACCOUNT_ID
PO_DISTRIBUTIONS_ALL FK Joins to TablePO_LINES_ALL PO_DISTRIBUTIONS_ALL.PO_LINE_ID
PO_DISTRIBUTIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS PO_DISTRIBUTIONS_ALL.VARIANCE_ACCOUNT_ID
PO_DISTRIBUTIONS_ALL FK Joins to TablePO_DISTRIBUTIONS_ALL PO_DISTRIBUTIONS_ALL.SOURCE_DISTRIBUTION_ID
PO_DISTRIBUTIONS_ALL FK Joins to TablePA_TASKS PO_DISTRIBUTIONS_ALL.TASK_ID
PO_DISTRIBUTIONS_ALL FK Joins to TablePO_LINE_LOCATIONS_ALL PO_DISTRIBUTIONS_ALL.LINE_LOCATION_ID
PO_DISTRIBUTIONS_ALL FK Joins to TablePO_RELEASES_ALL PO_DISTRIBUTIONS_ALL.PO_RELEASE_ID
PO_DISTRIBUTIONS_ALL FK Joins to TablePO_REQ_DISTRIBUTIONS_ALL PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID
PO_DISTRIBUTIONS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I PO_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
PO_DISTRIBUTIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID
Table% FK Joins to PO_DISTRIBUTIONS_ALL
TableAP_INVOICE_DISTRIBUTIONS_ALL FK Joins to PO_DISTRIBUTIONS_ALL AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
TableIGC_CC_DET_PF FK Joins to PO_DISTRIBUTIONS_ALL IGC_CC_DET_PF.CC_DET_PF_LINE_ID
TableCST_AP_PO_RECONCILIATION FK Joins to PO_DISTRIBUTIONS_ALL CST_AP_PO_RECONCILIATION.PO_DISTRIBUTION_ID
TableCST_AP_VARIANCE_LINES FK Joins to PO_DISTRIBUTIONS_ALL CST_AP_VARIANCE_LINES.PO_DISTRIBUTION_ID
TableCST_MISC_RECONCILIATION FK Joins to PO_DISTRIBUTIONS_ALL CST_MISC_RECONCILIATION.PO_DISTRIBUTION_ID
TableCST_RECONCILIATION_SUMMARY FK Joins to PO_DISTRIBUTIONS_ALL CST_RECONCILIATION_SUMMARY.PO_DISTRIBUTION_ID
TableCST_WRITE_OFFS FK Joins to PO_DISTRIBUTIONS_ALL CST_WRITE_OFFS.PO_DISTRIBUTION_ID
TableFA_ASSET_INVOICES FK Joins to PO_DISTRIBUTIONS_ALL FA_ASSET_INVOICES.PO_DISTRIBUTION_ID
TableFA_MASSADD_REP_ITF FK Joins to PO_DISTRIBUTIONS_ALL FA_MASSADD_REP_ITF.PO_DISTRIBUTION_ID
TableFA_MASS_ADDITIONS FK Joins to PO_DISTRIBUTIONS_ALL FA_MASS_ADDITIONS.PO_DISTRIBUTION_ID
TableFA_MC_ASSET_INVOICES FK Joins to PO_DISTRIBUTIONS_ALL FA_MC_ASSET_INVOICES.PO_DISTRIBUTION_ID
TableFV_INV_SELECTED_DUEDATE FK Joins to PO_DISTRIBUTIONS_ALL FV_INV_SELECTED_DUEDATE.PO_DISTRIBUTION_ID
TableGMS_AWARD_DISTRIBUTIONS FK Joins to PO_DISTRIBUTIONS_ALL GMS_AWARD_DISTRIBUTIONS.PO_DISTRIBUTION_ID
TableJAI_AP_MATCH_ERS_T FK Joins to PO_DISTRIBUTIONS_ALL JAI_AP_MATCH_ERS_T.PO_DISTRIBUTION_ID
TableJAI_AP_MATCH_INV_TAXES FK Joins to PO_DISTRIBUTIONS_ALL JAI_AP_MATCH_INV_TAXES.PO_DISTRIBUTION_ID
TableJAI_ENCUM_TAX_DETAILS FK Joins to PO_DISTRIBUTIONS_ALL JAI_ENCUM_TAX_DETAILS.DISTRIBUTION_ID
TableJAI_PO_OSP_LINES FK Joins to PO_DISTRIBUTIONS_ALL JAI_PO_OSP_LINES.PO_DISTRIBUTION_ID
TableJAI_PO_REP_PRRG_T FK Joins to PO_DISTRIBUTIONS_ALL JAI_PO_REP_PRRG_T.PO_DISTRIBUTION_ID
TableMTL_KANBAN_CARD_ACTIVITY FK Joins to PO_DISTRIBUTIONS_ALL MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_DETAIL_ID
TableMTL_SUPPLY FK Joins to PO_DISTRIBUTIONS_ALL MTL_SUPPLY.PO_DISTRIBUTION_ID
TableIGC_CC_ARC_DET_PF FK Joins to PO_DISTRIBUTIONS_ALL IGC_CC_ARC_DET_PF.CC_DET_PF_LINE_ID
TableIGC_CC_DET_PF_INTERFACE FK Joins to PO_DISTRIBUTIONS_ALL IGC_CC_DET_PF_INTERFACE.INTERFACE_DET_PF_LINE_ID
TablePA_BC_COMMITMENTS_ALL FK Joins to PO_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.DOCUMENT_DISTRIBUTION_ID
TablePA_BC_COMMITMENTS_ALL FK Joins to PO_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.DOCUMENT_DISTRIBUTION_ID
TablePA_BC_PACKETS FK Joins to PO_DISTRIBUTIONS_ALL PA_BC_PACKETS.DOCUMENT_DISTRIBUTION_ID
TablePA_BC_COMMITMENTS_ALL FK Joins to PO_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.PDL_PO_DISTRIBUTION_ID
TablePO_ACCRUAL_RECONCILE_TEMP_ALL FK Joins to PO_DISTRIBUTIONS_ALL PO_ACCRUAL_RECONCILE_TEMP_ALL.PO_DISTRIBUTION_ID
TablePO_ACCRUAL_WRITE_OFFS_ALL FK Joins to PO_DISTRIBUTIONS_ALL PO_ACCRUAL_WRITE_OFFS_ALL.PO_DISTRIBUTION_ID
TablePO_DISTRIBUTIONS_ARCHIVE_ALL FK Joins to PO_DISTRIBUTIONS_ALL PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_DISTRIBUTION_ID
TablePO_DISTRIBUTIONS_ARCHIVE_ALL FK Joins to PO_DISTRIBUTIONS_ALL PO_DISTRIBUTIONS_ARCHIVE_ALL.SOURCE_DISTRIBUTION_ID
TablePO_DISTRIBUTIONS_ALL FK Joins to PO_DISTRIBUTIONS_ALL PO_DISTRIBUTIONS_ALL.SOURCE_DISTRIBUTION_ID
TableRCV_ACCOUNTING_EVENTS FK Joins to PO_DISTRIBUTIONS_ALL RCV_ACCOUNTING_EVENTS.PO_DISTRIBUTION_ID
TableRCV_SHIPMENT_LINES FK Joins to PO_DISTRIBUTIONS_ALL RCV_SHIPMENT_LINES.PO_DISTRIBUTION_ID
TableRCV_SUPPLY FK Joins to PO_DISTRIBUTIONS_ALL RCV_SUPPLY.PO_DISTRIBUTION_ID
TableRCV_TRANSACTIONS FK Joins to PO_DISTRIBUTIONS_ALL RCV_TRANSACTIONS.PO_DISTRIBUTION_ID
TableRCV_TRANSACTIONS_INTERFACE FK Joins to PO_DISTRIBUTIONS_ALL RCV_TRANSACTIONS_INTERFACE.PO_DISTRIBUTION_ID