VIEW: APPS.BOM_PRODUCTFAMILY_MEM_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'