View: BOM_PRODUCTFAMILY_MEM_V

Product:	BOM - Bills of Material
Description:	View on BOM_INVENTORY_COMPONENTS and MTL_SYSTEMS_ITEMS, used by the product family functionality in R11
Implementation/DBA Data:	APPS.BOM_PRODUCTFAMILY_MEM_V

View Text

SELECT DISTINCT BOM.ORGANIZATION_ID
, BIC.COMPONENT_ITEM_ID
, BIC.BILL_SEQUENCE_ID
, ML1.MEANING FORECAST_CONTROL
, ML2.MEANING PLANNING_METHOD
, ML3.MEANING BOM_ITEM_TYPE
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MTL_SYSTEM_ITEMS MSI
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM
WHERE BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
AND BIC.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND BOM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ML1.LOOKUP_CODE (+) = MSI.ATO_FORECAST_CONTROL
AND ML1.LOOKUP_TYPE (+) = 'MRP_ATO_FORECAST_CONTROL'
AND ML2.LOOKUP_CODE (+) = MSI.MRP_PLANNING_CODE
AND ML2.LOOKUP_TYPE (+) = 'MRP_PLANNING_CODE'
AND ML3.LOOKUP_CODE = BIC.BOM_ITEM_TYPE
AND ML3.LOOKUP_TYPE = 'BOM_ITEM_TYPE'

Columns