Table: PO_LINES_ALL

Product:	PO - Purchasing
Description:	Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
Implementation/DBA Data:	PO.PO_LINES_ALL

Primary Key: PO_LINES_PK

1. PO_LINE_ID

Primary Key: PO_LINES_UK1

1. PO_HEADER_ID
2. LINE_NUM

Foreign Keys

Table		Foreign Table	Foreign Key Column
PO_LINES_ALL		MTL_CATEGORIES_B	PO_LINES_ALL.CATEGORY_ID
PO_LINES_ALL		PO_LINE_TYPES_B	PO_LINES_ALL.LINE_TYPE_ID
PO_LINES_ALL		PO_UN_NUMBERS_B	PO_LINES_ALL.UN_NUMBER_ID
PO_LINES_ALL		PO_HAZARD_CLASSES_B	PO_LINES_ALL.HAZARD_CLASS_ID
PO_LINES_ALL		PO_HEADERS_ALL	PO_LINES_ALL.FROM_HEADER_ID
PO_LINES_ALL		PO_LINES_ALL	PO_LINES_ALL.FROM_LINE_ID
AHL_OSP_ORDER_LINES		PO_LINES_ALL	AHL_OSP_ORDER_LINES.PO_LINE_ID
CSI_ITEM_INSTANCES		PO_LINES_ALL	CSI_ITEM_INSTANCES.PO_ORDER_LINE_ID
CST_RCV_ACQ_COST_DETAILS		PO_LINES_ALL	CST_RCV_ACQ_COST_DETAILS.PO_LINE_LOCATION_ID
ICX_SHOPPING_CART_LINES		PO_LINES_ALL	ICX_SHOPPING_CART_LINES.AUTOSOURCE_DOC_HEADER_ID ICX_SHOPPING_CART_LINES.AUTOSOURCE_DOC_LINE_NUM
IGC_CC_ACCT_LINES		PO_LINES_ALL	IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID
JAI_AP_MATCH_INV_TAXES		PO_LINES_ALL	JAI_AP_MATCH_INV_TAXES.PO_LINE_ID
JAI_CMN_LINES		PO_LINES_ALL	JAI_CMN_LINES.PO_LINE_ID
JAI_CMN_RG_23AC_I_TRXS		PO_LINES_ALL	JAI_CMN_RG_23AC_I_TRXS.PO_LINE_ID
JAI_ENCUM_TAX_DETAILS		PO_LINES_ALL	JAI_ENCUM_TAX_DETAILS.DOC_LINE_ID
JAI_PO_COPYDOC_T		PO_LINES_ALL	JAI_PO_COPYDOC_T.PO_LINE_ID
JAI_PO_COPY_T		PO_LINES_ALL	JAI_PO_COPY_T.PO_LINE_ID
JAI_PO_LINE_LOCATIONS		PO_LINES_ALL	JAI_PO_LINE_LOCATIONS.PO_LINE_ID
JAI_PO_OSP_LINES		PO_LINES_ALL	JAI_PO_OSP_LINES.PO_LINE_ID
JAI_PO_QUOT_LINES_T		PO_LINES_ALL	JAI_PO_QUOT_LINES_T.PO_LINE_ID
JAI_PO_QUOT_LINES_T		PO_LINES_ALL	JAI_PO_QUOT_LINES_T.FROM_LINE_ID
JAI_PO_REQUEST_T		PO_LINES_ALL	JAI_PO_REQUEST_T.PO_LINE_ID
JAI_PO_TAXES		PO_LINES_ALL	JAI_PO_TAXES.PO_LINE_ID
JAI_RETRO_LINE_CHANGES		PO_LINES_ALL	JAI_RETRO_LINE_CHANGES.DOC_LINE_ID
JAI_RETRO_LINE_CHANGES		PO_LINES_ALL	JAI_RETRO_LINE_CHANGES.FROM_LINE_ID
MTL_SUPPLY		PO_LINES_ALL	MTL_SUPPLY.PO_LINE_ID
IGC_CC_ARC_ACCT_LINES		PO_LINES_ALL	IGC_CC_ARC_ACCT_LINES.CC_ACCT_LINE_ID
IGC_CC_ACCT_LINES_INTERFACE		PO_LINES_ALL	IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_ACCT_LINE_ID
OE_DROP_SHIP_SOURCES		PO_LINES_ALL	OE_DROP_SHIP_SOURCES.PO_LINE_ID
PA_CI_SUPPLIER_DETAILS		PO_LINES_ALL	PA_CI_SUPPLIER_DETAILS.PO_LINE_ID
PA_EXPENDITURE_ITEMS_AR		PO_LINES_ALL	PA_EXPENDITURE_ITEMS_AR.PO_LINE_ID
PA_TRANSACTION_INTERFACE_ALL		PO_LINES_ALL	PA_TRANSACTION_INTERFACE_ALL.PO_LINE_ID
PA_TXN_INTERFACE_AUDIT_AR		PO_LINES_ALL	PA_TXN_INTERFACE_AUDIT_AR.PO_LINE_ID
PA_TXN_INTERFACE_AUDIT_ALL		PO_LINES_ALL	PA_TXN_INTERFACE_AUDIT_ALL.PO_LINE_ID
PO_ACCRUAL_RECONCILE_TEMP_ALL		PO_LINES_ALL	PO_ACCRUAL_RECONCILE_TEMP_ALL.PO_LINE_ID
PO_ACCRUAL_WRITE_OFFS_ALL		PO_LINES_ALL	PO_ACCRUAL_WRITE_OFFS_ALL.PO_LINE_ID
PO_AUTOSOURCE_DOCUMENTS_ALL		PO_LINES_ALL	PO_AUTOSOURCE_DOCUMENTS_ALL.DOCUMENT_LINE_ID
PO_DISTRIBUTIONS_ARCHIVE_ALL		PO_LINES_ALL	PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_LINE_ID
PO_DISTRIBUTIONS_ALL		PO_LINES_ALL	PO_DISTRIBUTIONS_ALL.PO_LINE_ID
PO_LINES_ARCHIVE_ALL		PO_LINES_ALL	PO_LINES_ARCHIVE_ALL.FROM_LINE_ID
PO_LINES_ARCHIVE_ALL		PO_LINES_ALL	PO_LINES_ARCHIVE_ALL.PO_LINE_ID
PO_LINES_ALL		PO_LINES_ALL	PO_LINES_ALL.FROM_LINE_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL		PO_LINES_ALL	PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL		PO_LINES_ALL	PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_ID
PO_LINE_LOCATIONS_ALL		PO_LINES_ALL	PO_LINE_LOCATIONS_ALL.FROM_LINE_ID
PO_LINE_LOCATIONS_ALL		PO_LINES_ALL	PO_LINE_LOCATIONS_ALL.PO_LINE_ID
PO_REQEXPRESS_LINES_ALL		PO_LINES_ALL	PO_REQEXPRESS_LINES_ALL.PO_LINE_ID
RCV_ACCOUNTING_EVENTS		PO_LINES_ALL	RCV_ACCOUNTING_EVENTS.PO_LINE_ID
RCV_SHIPMENT_LINES		PO_LINES_ALL	RCV_SHIPMENT_LINES.PO_LINE_ID
RCV_SUPPLY		PO_LINES_ALL	RCV_SUPPLY.PO_LINE_ID
RCV_TRANSACTIONS		PO_LINES_ALL	RCV_TRANSACTIONS.PO_LINE_ID
RCV_TRANSACTIONS_INTERFACE		PO_LINES_ALL	RCV_TRANSACTIONS_INTERFACE.PO_LINE_ID
SO_DROP_SHIP_SOURCES		PO_LINES_ALL	SO_DROP_SHIP_SOURCES.PO_LINE_ID
WIP_COST_TXN_INTERFACE		PO_LINES_ALL	WIP_COST_TXN_INTERFACE.PO_LINE_ID
WIP_TRANSACTIONS		PO_LINES_ALL	WIP_TRANSACTIONS.PO_LINE_ID