FND Design Data [Home] [Help]

Table: PO_LINES_DRAFT_ALL

Product: PO - Purchasing
Description: Draft table for purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
Implementation/DBA Data: TablePO.PO_LINES_DRAFT_ALL
Primary Key: PO_LINES_DRAFT_PK
  1. ColumnPO_LINE_ID
  2. ColumnDRAFT_ID
Primary Key: PO_LINES_DRAFT_UK1
  1. ColumnPO_HEADER_ID
  2. ColumnLINE_NUM
  3. ColumnDRAFT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_LINES_DRAFT_ALL FK Joins to TableMTL_CATEGORIES_B PO_LINES_DRAFT_ALL.CATEGORY_ID
PO_LINES_DRAFT_ALL FK Joins to TablePO_LINE_TYPES_B PO_LINES_DRAFT_ALL.LINE_TYPE_ID
PO_LINES_DRAFT_ALL FK Joins to TablePO_UN_NUMBERS_B PO_LINES_DRAFT_ALL.UN_NUMBER_ID
PO_LINES_DRAFT_ALL FK Joins to TablePO_HAZARD_CLASSES_B PO_LINES_DRAFT_ALL.HAZARD_CLASS_ID
PO_LINES_DRAFT_ALL FK Joins to TablePO_HEADERS_ALL PO_LINES_DRAFT_ALL.FROM_HEADER_ID
PO_LINES_DRAFT_ALL FK Joins to TablePO_LINES_ALL PO_LINES_DRAFT_ALL.FROM_LINE_ID