FND Design Data [Home] [Help]

Table: CRP_BILL_OF_RESOURCE_ITEMS

Product: CRP - Capacity
Description: Items in a bill of resource set
Implementation/DBA Data: TableCRP.CRP_BILL_OF_RESOURCE_ITEMS
Primary Key: CRP_BILL_OF_RESOURCE_ITEMS_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnBILL_OF_RESOURCES
  3. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CRP_BILL_OF_RESOURCE_ITEMS FK Joins to TableMTL_SYSTEM_ITEMS_B CRP_BILL_OF_RESOURCE_ITEMS.INVENTORY_ITEM_ID
CRP_BILL_OF_RESOURCE_ITEMS.ORGANIZATION_ID
CRP_BILL_OF_RESOURCE_ITEMS FK Joins to TableCRP_BILLS_OF_RESOURCES CRP_BILL_OF_RESOURCE_ITEMS.BILL_OF_RESOURCES
CRP_BILL_OF_RESOURCE_ITEMS.ORGANIZATION_ID
TableCRP_RESOURCE_HOURS FK Joins to CRP_BILL_OF_RESOURCE_ITEMS CRP_RESOURCE_HOURS.ASSEMBLY_ITEM_ID
CRP_RESOURCE_HOURS.BILL_OF_RESOURCES
CRP_RESOURCE_HOURS.ORGANIZATION_ID