FND Design Data [Home] [Help]

Table: PM_MATL_DTL

Product: GME - Process Manufacturing Process Execution
Description: Batch or FPO material details.
Implementation/DBA Data: Not implemented in this database
Primary Key: PM_MATL_DTLI1
  1. ColumnLINE_ID
Primary Key: PM_MATL_DTL_PK
  1. ColumnBATCH_ID
  2. ColumnLINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PM_MATL_DTL FK Joins to Table% PM_MATL_DTL.ITEM_ID
PM_MATL_DTL FK Joins to TableIC_ITEM_MST PM_MATL_DTL.ITEM_ID
PM_MATL_DTL FK Joins to TablePM_BTCH_HDR PM_MATL_DTL.BATCH_ID
PM_MATL_DTL FK Joins to TablePM_TEXT_HDR PM_MATL_DTL.TEXT_CODE
PM_MATL_DTL FK Joins to TableSY_UOMS_MST PM_MATL_DTL.ITEM_UM
PM_MATL_DTL FK Joins to TableSY_UOMS_MST PM_MATL_DTL.ITEM_UM2
TablePM_BTCH_HDR FK Joins to PM_MATL_DTL PM_BTCH_HDR.PARENTLINE_ID
TablePM_BTCH_PKG FK Joins to PM_MATL_DTL PM_BTCH_PKG.BULK_BATCH_ID
PM_BTCH_PKG.BULK_LINE_ID
TablePM_ROUT_MTL FK Joins to PM_MATL_DTL PM_ROUT_MTL.BATCH_ID
PM_ROUT_MTL.BATCHLINE_ID