FND Design Data [Home] [Help]

Table: CSP_PACKLIST_SERIAL_LOTS

Product: CSP - Spares Management
Description: Packlist serial and lot numbers
Implementation/DBA Data: TableCSP.CSP_PACKLIST_SERIAL_LOTS
Primary Key: CSP_PACKLIST_SERIAL_LOTS_PK
  1. ColumnPACKLIST_SERIAL_LOT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CSP_PACKLIST_SERIAL_LOTS FK Joins to TableCSP_PACKLIST_LINES CSP_PACKLIST_SERIAL_LOTS.PACKLIST_LINE_ID
CSP_PACKLIST_SERIAL_LOTS FK Joins to TableMTL_SERIAL_NUMBERS CSP_PACKLIST_SERIAL_LOTS.SERIAL_NUMBER
CSP_PACKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID
CSP_PACKLIST_SERIAL_LOTS.ORGANIZATION_ID
CSP_PACKLIST_SERIAL_LOTS FK Joins to TableMTL_LOT_NUMBERS CSP_PACKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID
CSP_PACKLIST_SERIAL_LOTS.ORGANIZATION_ID
CSP_PACKLIST_SERIAL_LOTS.LOT_NUMBER