DBA Data[Home] [Help]

APPS.PRODUCT_FAMILY_PKG dependencies on MFG_LOOKUPS

Line 159: MFG_Lookups ML1,

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

Line 160: MFG_Lookups ML2,

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

Line 161: MFG_Lookups ML3

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'