FND Design Data [Home] [Help]

Table: CM_CMPT_DTL

Product: GMF - Process Manufacturing Financials
Description: Cost Component Details
Implementation/DBA Data: TableGMF.CM_CMPT_DTL
Primary Key: CM_CMPT_DTL_PK
  1. ColumnCMPNTCOST_ID
Primary Key: CM_CMPT_DTL_U1
  1. ColumnITEM_ID
  2. ColumnWHSE_CODE
  3. ColumnCALENDAR_CODE
  4. ColumnPERIOD_CODE
  5. ColumnCOST_MTHD_CODE
  6. ColumnCOST_CMPNTCLS_ID
  7. ColumnCOST_ANALYSIS_CODE
  8. ColumnCOST_LEVEL
Foreign Keys
Table
Foreign Table Foreign Key Column
CM_CMPT_DTL FK Joins to TableCM_ACPR_CTL CM_CMPT_DTL.ACPROC_ID
CM_CMPT_DTL FK Joins to TableCM_ALYS_MST CM_CMPT_DTL.COST_ANALYSIS_CODE
CM_CMPT_DTL FK Joins to TableCM_CLDR_DTL CM_CMPT_DTL.CALENDAR_CODE
CM_CMPT_DTL.PERIOD_CODE
CM_CMPT_DTL FK Joins to TableCM_CMPT_MST_B CM_CMPT_DTL.COST_CMPNTCLS_ID
CM_CMPT_DTL FK Joins to TableCM_CMPT_MST CM_CMPT_DTL.COST_CMPNTCLS_ID
CM_CMPT_DTL FK Joins to TableCM_MTHD_MST CM_CMPT_DTL.COST_MTHD_CODE
CM_CMPT_DTL FK Joins to TableCM_RLUP_CTL CM_CMPT_DTL.ROLLUP_REF_NO
CM_CMPT_DTL FK Joins to TableCM_TEXT_HDR CM_CMPT_DTL.TEXT_CODE
CM_CMPT_DTL FK Joins to TableFM_FORM_EFF CM_CMPT_DTL.FMEFF_ID
CM_CMPT_DTL FK Joins to TableIC_ITEM_MST_B CM_CMPT_DTL.ITEM_ID
CM_CMPT_DTL FK Joins to TableIC_ITEM_MST CM_CMPT_DTL.ITEM_ID
CM_CMPT_DTL FK Joins to TableIC_WHSE_MST CM_CMPT_DTL.WHSE_CODE
TableCM_ACST_LED FK Joins to CM_CMPT_DTL CM_ACST_LED.CMPNTCOST_ID
TableCM_BRDN_DTL FK Joins to CM_CMPT_DTL CM_BRDN_DTL.CMPNTCOST_ID
TableCM_SCST_LED FK Joins to CM_CMPT_DTL CM_SCST_LED.CMPNTCOST_ID