FND Design Data [Home] [Help]

Table: PO_LINES_ALL

Product: PO - Purchasing
Description: Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
Implementation/DBA Data: TablePO.PO_LINES_ALL
Primary Key: PO_LINES_PK
  1. ColumnPO_LINE_ID
Primary Key: PO_LINES_UK1
  1. ColumnPO_HEADER_ID
  2. ColumnLINE_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_LINES_ALL FK Joins to TableMTL_CATEGORIES_B PO_LINES_ALL.CATEGORY_ID
PO_LINES_ALL FK Joins to TablePO_LINE_TYPES_B PO_LINES_ALL.LINE_TYPE_ID
PO_LINES_ALL FK Joins to TablePO_UN_NUMBERS_B PO_LINES_ALL.UN_NUMBER_ID
PO_LINES_ALL FK Joins to TablePO_HAZARD_CLASSES_B PO_LINES_ALL.HAZARD_CLASS_ID
PO_LINES_ALL FK Joins to TablePO_HEADERS_ALL PO_LINES_ALL.FROM_HEADER_ID
PO_LINES_ALL FK Joins to TablePO_LINES_ALL PO_LINES_ALL.FROM_LINE_ID
TableAHL_OSP_ORDER_LINES FK Joins to PO_LINES_ALL AHL_OSP_ORDER_LINES.PO_LINE_ID
TableCSI_ITEM_INSTANCES FK Joins to PO_LINES_ALL CSI_ITEM_INSTANCES.PO_ORDER_LINE_ID
TableCST_RCV_ACQ_COST_DETAILS FK Joins to PO_LINES_ALL CST_RCV_ACQ_COST_DETAILS.PO_LINE_LOCATION_ID
TableICX_SHOPPING_CART_LINES FK Joins to PO_LINES_ALL ICX_SHOPPING_CART_LINES.AUTOSOURCE_DOC_HEADER_ID
ICX_SHOPPING_CART_LINES.AUTOSOURCE_DOC_LINE_NUM
TableIGC_CC_ACCT_LINES FK Joins to PO_LINES_ALL IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID
TableJAI_AP_MATCH_INV_TAXES FK Joins to PO_LINES_ALL JAI_AP_MATCH_INV_TAXES.PO_LINE_ID
TableJAI_CMN_LINES FK Joins to PO_LINES_ALL JAI_CMN_LINES.PO_LINE_ID
TableJAI_CMN_RG_23AC_I_TRXS FK Joins to PO_LINES_ALL JAI_CMN_RG_23AC_I_TRXS.PO_LINE_ID
TableJAI_ENCUM_TAX_DETAILS FK Joins to PO_LINES_ALL JAI_ENCUM_TAX_DETAILS.DOC_LINE_ID
TableJAI_PO_COPYDOC_T FK Joins to PO_LINES_ALL JAI_PO_COPYDOC_T.PO_LINE_ID
TableJAI_PO_COPY_T FK Joins to PO_LINES_ALL JAI_PO_COPY_T.PO_LINE_ID
TableJAI_PO_LINE_LOCATIONS FK Joins to PO_LINES_ALL JAI_PO_LINE_LOCATIONS.PO_LINE_ID
TableJAI_PO_OSP_LINES FK Joins to PO_LINES_ALL JAI_PO_OSP_LINES.PO_LINE_ID
TableJAI_PO_QUOT_LINES_T FK Joins to PO_LINES_ALL JAI_PO_QUOT_LINES_T.PO_LINE_ID
TableJAI_PO_QUOT_LINES_T FK Joins to PO_LINES_ALL JAI_PO_QUOT_LINES_T.FROM_LINE_ID
TableJAI_PO_REQUEST_T FK Joins to PO_LINES_ALL JAI_PO_REQUEST_T.PO_LINE_ID
TableJAI_PO_TAXES FK Joins to PO_LINES_ALL JAI_PO_TAXES.PO_LINE_ID
TableJAI_RETRO_LINE_CHANGES FK Joins to PO_LINES_ALL JAI_RETRO_LINE_CHANGES.DOC_LINE_ID
TableJAI_RETRO_LINE_CHANGES FK Joins to PO_LINES_ALL JAI_RETRO_LINE_CHANGES.FROM_LINE_ID
TableMTL_SUPPLY FK Joins to PO_LINES_ALL MTL_SUPPLY.PO_LINE_ID
TableIGC_CC_ARC_ACCT_LINES FK Joins to PO_LINES_ALL IGC_CC_ARC_ACCT_LINES.CC_ACCT_LINE_ID
TableIGC_CC_ACCT_LINES_INTERFACE FK Joins to PO_LINES_ALL IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_ACCT_LINE_ID
TableOE_DROP_SHIP_SOURCES FK Joins to PO_LINES_ALL OE_DROP_SHIP_SOURCES.PO_LINE_ID
TablePA_CI_SUPPLIER_DETAILS FK Joins to PO_LINES_ALL PA_CI_SUPPLIER_DETAILS.PO_LINE_ID
TablePA_EXPENDITURE_ITEMS_AR FK Joins to PO_LINES_ALL PA_EXPENDITURE_ITEMS_AR.PO_LINE_ID
TablePA_TRANSACTION_INTERFACE_ALL FK Joins to PO_LINES_ALL PA_TRANSACTION_INTERFACE_ALL.PO_LINE_ID
TablePA_TXN_INTERFACE_AUDIT_AR FK Joins to PO_LINES_ALL PA_TXN_INTERFACE_AUDIT_AR.PO_LINE_ID
TablePA_TXN_INTERFACE_AUDIT_ALL FK Joins to PO_LINES_ALL PA_TXN_INTERFACE_AUDIT_ALL.PO_LINE_ID
TablePO_ACCRUAL_RECONCILE_TEMP_ALL FK Joins to PO_LINES_ALL PO_ACCRUAL_RECONCILE_TEMP_ALL.PO_LINE_ID
TablePO_ACCRUAL_WRITE_OFFS_ALL FK Joins to PO_LINES_ALL PO_ACCRUAL_WRITE_OFFS_ALL.PO_LINE_ID
TablePO_AUTOSOURCE_DOCUMENTS_ALL FK Joins to PO_LINES_ALL PO_AUTOSOURCE_DOCUMENTS_ALL.DOCUMENT_LINE_ID
TablePO_DISTRIBUTIONS_ARCHIVE_ALL FK Joins to PO_LINES_ALL PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_LINE_ID
TablePO_DISTRIBUTIONS_DRAFT_ALL FK Joins to PO_LINES_ALL PO_DISTRIBUTIONS_DRAFT_ALL.PO_LINE_ID
TablePO_DISTRIBUTIONS_ALL FK Joins to PO_LINES_ALL PO_DISTRIBUTIONS_ALL.PO_LINE_ID
TablePO_LINES_ARCHIVE_ALL FK Joins to PO_LINES_ALL PO_LINES_ARCHIVE_ALL.FROM_LINE_ID
TablePO_LINES_ARCHIVE_ALL FK Joins to PO_LINES_ALL PO_LINES_ARCHIVE_ALL.PO_LINE_ID
TablePO_LINES_DRAFT_ALL FK Joins to PO_LINES_ALL PO_LINES_DRAFT_ALL.FROM_LINE_ID
TablePO_LINES_ALL FK Joins to PO_LINES_ALL PO_LINES_ALL.FROM_LINE_ID
TablePO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to PO_LINES_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID
TablePO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to PO_LINES_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_ID
TablePO_LINE_LOCATIONS_DRAFT_ALL FK Joins to PO_LINES_ALL PO_LINE_LOCATIONS_DRAFT_ALL.FROM_LINE_ID
TablePO_LINE_LOCATIONS_DRAFT_ALL FK Joins to PO_LINES_ALL PO_LINE_LOCATIONS_DRAFT_ALL.PO_LINE_ID
TablePO_LINE_LOCATIONS_ALL FK Joins to PO_LINES_ALL PO_LINE_LOCATIONS_ALL.FROM_LINE_ID
TablePO_LINE_LOCATIONS_ALL FK Joins to PO_LINES_ALL PO_LINE_LOCATIONS_ALL.PO_LINE_ID
TablePO_REQEXPRESS_LINES_ALL FK Joins to PO_LINES_ALL PO_REQEXPRESS_LINES_ALL.PO_LINE_ID
TableRCV_ACCOUNTING_EVENTS FK Joins to PO_LINES_ALL RCV_ACCOUNTING_EVENTS.PO_LINE_ID
TableRCV_SHIPMENT_LINES FK Joins to PO_LINES_ALL RCV_SHIPMENT_LINES.PO_LINE_ID
TableRCV_SUPPLY FK Joins to PO_LINES_ALL RCV_SUPPLY.PO_LINE_ID
TableRCV_TRANSACTIONS FK Joins to PO_LINES_ALL RCV_TRANSACTIONS.PO_LINE_ID
TableRCV_TRANSACTIONS_INTERFACE FK Joins to PO_LINES_ALL RCV_TRANSACTIONS_INTERFACE.PO_LINE_ID
TableSO_DROP_SHIP_SOURCES FK Joins to PO_LINES_ALL SO_DROP_SHIP_SOURCES.PO_LINE_ID
TableWIP_COST_TXN_INTERFACE FK Joins to PO_LINES_ALL WIP_COST_TXN_INTERFACE.PO_LINE_ID
TableWIP_TRANSACTIONS FK Joins to PO_LINES_ALL WIP_TRANSACTIONS.PO_LINE_ID