APPS.MRP_MANAGER_PK dependencies on MRP_RELIEF_INTERFACE

Line 31: -- 1. Items in MRP_RELIEF_INTERFACE

27: 'N');
28:
29: --
30: -- Insert the following into MRP_FORM_QUERY:
31: -- 1. Items in MRP_RELIEF_INTERFACE
32: -- 2. Product family of items in (1)
33: -- 3. Components of config items in (1)
34: -- 4. Other items that are in the same product family as items in (1)
35: --

Line 53: FROM mrp_relief_interface upd

49: SYSDATE,
50: -1,
51: SYSDATE,
52: -1
53: FROM mrp_relief_interface upd
54: WHERE upd.relief_type = 1
55: AND upd.request_id IS NOT NULL
56: AND upd.error_message IS NULL
57: AND upd.process_status = 3

Line 68: FROM mrp_relief_interface upd1,

64: SYSDATE,
65: -1,
66: SYSDATE,
67: -1
68: FROM mrp_relief_interface upd1,
69: mtl_system_items item
70: WHERE item.organization_id = upd1.organization_id
71: AND item.inventory_item_id = upd1.inventory_item_id
72: AND upd1.relief_type = 1

Line 86: FROM mrp_relief_interface upd2,

82: SYSDATE,
83: -1,
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

Line 116: FROM mrp_relief_interface upd3,

112: SYSDATE,
113: -1,
114: SYSDATE,
115: -1
116: FROM mrp_relief_interface upd3,
117: mtl_system_items item1,
118: mtl_system_items item2
119: WHERE item2.product_family_item_id = item1.product_family_item_id
120: AND item2.organization_id = item1.organization_id