Table: PO_LINES_ARCHIVE_ALL

Product:	PO - Purchasing
Description:	Archived purchase order lines
Implementation/DBA Data:	PO.PO_LINES_ARCHIVE_ALL

Primary Key: PO_LINES_ARCHIVE_PK

1. PO_LINE_ID
2. REVISION_NUM

Primary Key: PO_LINES_ARCHIVE_UK1

1. PO_HEADER_ID
2. LINE_NUM
3. REVISION_NUM

Foreign Keys

Table		Foreign Table	Foreign Key Column
PO_LINES_ARCHIVE_ALL		PO_HEADERS_ALL	PO_LINES_ARCHIVE_ALL.PO_HEADER_ID
PO_LINES_ARCHIVE_ALL		PO_HEADERS_ALL	PO_LINES_ARCHIVE_ALL.FROM_HEADER_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_ARCHIVE_ALL		PO_LINE_TYPES_B	PO_LINES_ARCHIVE_ALL.LINE_TYPE_ID
PO_LINES_ARCHIVE_ALL		MTL_CATEGORIES_B	PO_LINES_ARCHIVE_ALL.CATEGORY_ID
PO_LINES_ARCHIVE_ALL		PO_UN_NUMBERS_B	PO_LINES_ARCHIVE_ALL.UN_NUMBER_ID
PO_LINES_ARCHIVE_ALL		PO_HAZARD_CLASSES_B	PO_LINES_ARCHIVE_ALL.HAZARD_CLASS_ID
ICX_PO_REVISIONS_TEMP		PO_LINES_ARCHIVE_ALL	ICX_PO_REVISIONS_TEMP.LINE_ID ICX_PO_REVISIONS_TEMP.REVISION_NUM