FND Design Data [Home] [Help]

Table: PO_LINE_LOCATIONS_ARCHIVE_ALL

Product: PO - Purchasing
Description: Archived purchase order shipments
Implementation/DBA Data: TablePO.PO_LINE_LOCATIONS_ARCHIVE_ALL
Primary Key: PO_LINE_LOCATIONS_ARCHIVE_PK
  1. ColumnLINE_LOCATION_ID
  2. ColumnREVISION_NUM
Primary Key: PO_LINE_LOCATIONS_ARCHIVE_UK1
  1. ColumnPO_LINE_ID
  2. ColumnSHIPMENT_NUM
  3. ColumnREVISION_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TablePO_HEADERS_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_HEADER_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TablePO_LINE_LOCATIONS_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.SOURCE_SHIPMENT_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TableRCV_ROUTING_HEADERS PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIVING_ROUTING_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TableAP_TAX_CODES_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_CODE_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TablePO_LINES_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TablePO_RELEASES_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_RELEASE_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TablePO_HEADERS_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_HEADER_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TablePO_LINES_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL FK Joins to TablePO_LINE_LOCATIONS_ALL PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_LOCATION_ID
TableICX_PO_REVISIONS_TEMP FK Joins to PO_LINE_LOCATIONS_ARCHIVE_ALL ICX_PO_REVISIONS_TEMP.LOCATION_ID
ICX_PO_REVISIONS_TEMP.REVISION_NUM