DBA Data[Home] [Help]

APPS.MRP_MANAGER_PK dependencies on BOM_BILL_OF_MATERIALS

Line 88: bom_bill_of_materials bom,

84: SYSDATE,
85: -1
86: FROM mrp_relief_interface upd2,
87: mtl_system_items bom_item,
88: bom_bill_of_materials bom,
89: bom_inventory_components comp,
90: mtl_system_items comp_item
91: WHERE NVL(comp_item.ato_forecast_control, ATO_NONE) <> ATO_NONE
92: AND comp_item.inventory_item_id = comp.component_item_id

Line 166: bom_bill_of_materials bom,

162: -1,
163: SYSDATE,
164: -1
165: FROM mtl_system_items bom_item,
166: bom_bill_of_materials bom,
167: bom_inventory_components comp,
168: mtl_system_items comp_item,
169: mrp_form_query query
170: WHERE bom_item.base_item_id IS NOT NULL

Line 277: bom_bill_of_materials bom,

273: SYSDATE,
274: -1
275: FROM mrp_sales_order_updates upd2,
276: mtl_system_items bom_item,
277: bom_bill_of_materials bom,
278: bom_inventory_components comp,
279: mtl_system_items comp_item
280: WHERE (((bom_item.bom_item_type = ITEM_TYPE_MODEL
281: --

Line 373: bom_bill_of_materials bom,

369: -1
370: FROM mrp_form_query query,
371: mtl_system_items comp_item,
372: bom_inventory_components comp,
373: bom_bill_of_materials bom,
374: mtl_system_items bom_item
375: WHERE (((bom_item.bom_item_type = ITEM_TYPE_MODEL
376: --
377: -- This is the logic we have added to skip explosion of