FND Design Data [Home] [Help]

Table: PO_LINES_ARCHIVE_ALL

Product: PO - Purchasing
Description: Archived purchase order lines
Implementation/DBA Data: TablePO.PO_LINES_ARCHIVE_ALL
Primary Key: PO_LINES_ARCHIVE_PK
  1. ColumnPO_LINE_ID
  2. ColumnREVISION_NUM
Primary Key: PO_LINES_ARCHIVE_UK1
  1. ColumnPO_HEADER_ID
  2. ColumnLINE_NUM
  3. ColumnREVISION_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_LINES_ARCHIVE_ALL FK Joins to TablePO_HEADERS_ALL PO_LINES_ARCHIVE_ALL.PO_HEADER_ID
PO_LINES_ARCHIVE_ALL FK Joins to TablePO_HEADERS_ALL PO_LINES_ARCHIVE_ALL.FROM_HEADER_ID
PO_LINES_ARCHIVE_ALL FK Joins to TablePO_LINES_ALL PO_LINES_ARCHIVE_ALL.FROM_LINE_ID
PO_LINES_ARCHIVE_ALL FK Joins to TablePO_LINES_ALL PO_LINES_ARCHIVE_ALL.PO_LINE_ID
PO_LINES_ARCHIVE_ALL FK Joins to TablePO_LINE_TYPES_B PO_LINES_ARCHIVE_ALL.LINE_TYPE_ID
PO_LINES_ARCHIVE_ALL FK Joins to TableMTL_CATEGORIES_B PO_LINES_ARCHIVE_ALL.CATEGORY_ID
PO_LINES_ARCHIVE_ALL FK Joins to TablePO_UN_NUMBERS_B PO_LINES_ARCHIVE_ALL.UN_NUMBER_ID
PO_LINES_ARCHIVE_ALL FK Joins to TablePO_HAZARD_CLASSES_B PO_LINES_ARCHIVE_ALL.HAZARD_CLASS_ID
TableICX_PO_REVISIONS_TEMP FK Joins to PO_LINES_ARCHIVE_ALL ICX_PO_REVISIONS_TEMP.LINE_ID
ICX_PO_REVISIONS_TEMP.REVISION_NUM