FND Design Data [Home] [Help]

Table: QC_SPEC_MST

Product: GMD - Process Manufacturing Product Development
Description: QC specification master.
Implementation/DBA Data: TableGMD.QC_SPEC_MST
Primary Key: QC_SPEC_MST_PK
  1. ColumnQC_SPEC_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
QC_SPEC_MST FK Joins to TableFM_MATL_DTL QC_SPEC_MST.FORMULALINE_ID
QC_SPEC_MST FK Joins to TableFM_OPRN_MST QC_SPEC_MST.OPRN_ID
QC_SPEC_MST FK Joins to TableFM_ROUT_DTL QC_SPEC_MST.ROUTING_ID
QC_SPEC_MST.ROUTINGSTEP_NO
QC_SPEC_MST FK Joins to Table% QC_SPEC_MST.QCASSY_TYP_ID
QC_SPEC_MST FK Joins to TableGMD_UNITS_B QC_SPEC_MST.QCUNIT_CODE
QC_SPEC_MST FK Joins to TableIC_ITEM_MST_B QC_SPEC_MST.ITEM_ID
QC_SPEC_MST FK Joins to TableIC_ITEM_MST QC_SPEC_MST.ITEM_ID
QC_SPEC_MST FK Joins to TableIC_LOCT_MST QC_SPEC_MST.WHSE_CODE
QC_SPEC_MST.LOCATION
QC_SPEC_MST FK Joins to TableIC_LOTS_MST QC_SPEC_MST.ITEM_ID
QC_SPEC_MST.LOT_ID
QC_SPEC_MST FK Joins to TableIC_WHSE_MST QC_SPEC_MST.WHSE_CODE
QC_SPEC_MST FK Joins to TableOP_CUST_MST QC_SPEC_MST.CUST_ID
QC_SPEC_MST FK Joins to TablePM_BTCH_HDR QC_SPEC_MST.BATCH_ID
QC_SPEC_MST FK Joins to TablePO_VEND_MST QC_SPEC_MST.VENDOR_ID
QC_SPEC_MST FK Joins to TableQC_ACTN_MST QC_SPEC_MST.OUTACTION_CODE
QC_SPEC_MST FK Joins to TableQC_ASSY_TYP QC_SPEC_MST.QCASSY_TYP_ID
QC_SPEC_MST FK Joins to TableQC_TEXT_HDR QC_SPEC_MST.TEXT_CODE
QC_SPEC_MST FK Joins to TableQC_UNIT_MST QC_SPEC_MST.QCUNIT_CODE
QC_SPEC_MST FK Joins to TableSY_ORGN_MST_B QC_SPEC_MST.ORGN_CODE
QC_SPEC_MST FK Joins to TableSY_ORGN_MST QC_SPEC_MST.ORGN_CODE
TableQC_RSLT_MST FK Joins to QC_SPEC_MST QC_RSLT_MST.QC_SPEC_ID