155: SELECT ML1.Meaning Bom_Item_Type,
156: ML2.Meaning Forecast_Control,
157: ML3.Meaning Planning_Method
158: FROM MTL_System_Items MSI,
159: MFG_Lookups ML1,
160: MFG_Lookups ML2,
161: MFG_Lookups ML3
162: WHERE MSI.Inventory_Item_Id = p_Component_Item_Id
163: AND MSI.Organization_Id = p_Organization_Id
156: ML2.Meaning Forecast_Control,
157: ML3.Meaning Planning_Method
158: FROM MTL_System_Items MSI,
159: MFG_Lookups ML1,
160: MFG_Lookups ML2,
161: MFG_Lookups ML3
162: WHERE MSI.Inventory_Item_Id = p_Component_Item_Id
163: AND MSI.Organization_Id = p_Organization_Id
164: AND ML1.Lookup_Code(+) = MSI.Bom_Item_Type
157: ML3.Meaning Planning_Method
158: FROM MTL_System_Items MSI,
159: MFG_Lookups ML1,
160: MFG_Lookups ML2,
161: MFG_Lookups ML3
162: WHERE MSI.Inventory_Item_Id = p_Component_Item_Id
163: AND MSI.Organization_Id = p_Organization_Id
164: AND ML1.Lookup_Code(+) = MSI.Bom_Item_Type
165: AND ML1.Lookup_Type(+) = 'BOM_ITEM_TYPE'