FND Design Data [Home] [Help]

Table: CR_RSRC_DTL

Product: GMP - Process Manufacturing Process Planning
Description: Plant-specific resource information
Implementation/DBA Data: TableGMP.CR_RSRC_DTL
Primary Key: CR_RSRC_DTL_I1
  1. ColumnORGN_CODE
  2. ColumnRESOURCES
Primary Key: CR_RSRC_DTL_PK
  1. ColumnRESOURCE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CR_RSRC_DTL FK Joins to TableCR_RSRC_MST_B CR_RSRC_DTL.RESOURCES
CR_RSRC_DTL FK Joins to TableCR_RSRC_MST_B CR_RSRC_DTL.GROUP_RESOURCE
CR_RSRC_DTL FK Joins to TableCR_RSRC_MST CR_RSRC_DTL.RESOURCES
CR_RSRC_DTL FK Joins to TableCR_RSRC_MST CR_RSRC_DTL.GROUP_RESOURCE
CR_RSRC_DTL FK Joins to TableCR_TEXT_HDR CR_RSRC_DTL.TEXT_CODE
CR_RSRC_DTL FK Joins to TableSY_ORGN_MST_B CR_RSRC_DTL.ORGN_CODE
CR_RSRC_DTL FK Joins to TableSY_ORGN_MST CR_RSRC_DTL.ORGN_CODE
CR_RSRC_DTL FK Joins to TableSY_UOMS_MST CR_RSRC_DTL.USAGE_UM
TableGMP_PLANT_RSRC_PARAMETERS FK Joins to CR_RSRC_DTL GMP_PLANT_RSRC_PARAMETERS.RESOURCE_ID
TableGMP_RSRC_EXCP_ASNMT FK Joins to CR_RSRC_DTL GMP_RSRC_EXCP_ASNMT.RESOURCE_ID
TableGMP_RSRC_UNAVAIL_MAN FK Joins to CR_RSRC_DTL GMP_RSRC_UNAVAIL_MAN.RESOURCE_ID