FND Design Data [Home] [Help]

Table: FM_ROUT_DTL

Product: GMD - Process Manufacturing Product Development
Description: Routing details
Implementation/DBA Data: TableGMD.FM_ROUT_DTL
Primary Key: FM_ROUT_DTLI1
  1. ColumnROUTINGSTEP_ID
Primary Key: FM_ROUT_DTL_PK
  1. ColumnROUTING_ID
  2. ColumnROUTINGSTEP_NO
Foreign Keys
Table
Foreign Table Foreign Key Column
FM_ROUT_DTL FK Joins to TableFM_OPRN_MST FM_ROUT_DTL.OPRN_ID
FM_ROUT_DTL FK Joins to TableFM_ROUT_HDR FM_ROUT_DTL.ROUTING_ID
FM_ROUT_DTL FK Joins to TableFM_TEXT_HDR FM_ROUT_DTL.TEXT_CODE
FM_ROUT_DTL FK Joins to TableGMD_ROUTINGS_B FM_ROUT_DTL.ROUTING_ID
TableFM_ROUT_DEP FK Joins to FM_ROUT_DTL FM_ROUT_DEP.ROUTING_ID
FM_ROUT_DEP.ROUTINGSTEP_NO
TableFM_ROUT_DEP FK Joins to FM_ROUT_DTL FM_ROUT_DEP.ROUTING_ID
FM_ROUT_DEP.DEP_ROUTINGSTEP_NO
TableGMD_RECIPE_PROCESS_PARAMETERS FK Joins to FM_ROUT_DTL GMD_RECIPE_PROCESS_PARAMETERS.ROUTINGSTEP_ID
TablePM_ROUT_DTL FK Joins to FM_ROUT_DTL PM_ROUT_DTL.ROUTINGSTEP_ID
TableQC_RSLT_MST FK Joins to FM_ROUT_DTL QC_RSLT_MST.ROUTING_ID
QC_RSLT_MST.ROUTINGSTEP_NO
TableQC_SMPL_MST FK Joins to FM_ROUT_DTL QC_SMPL_MST.ROUTING_ID
QC_SMPL_MST.ROUTINGSTEP_NO
TableQC_SPEC_MST FK Joins to FM_ROUT_DTL QC_SPEC_MST.ROUTING_ID
QC_SPEC_MST.ROUTINGSTEP_NO