eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_MANAGER_PK dependencies on MTL_SYSTEM_ITEMS

Line 69: mtl_system_items item

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
73: AND upd1.request_id IS NOT NULL

Line 87: mtl_system_items bom_item,

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
91: WHERE NVL(comp_item.ato_forecast_control, ATO_NONE) <> ATO_NONE

Line 90: mtl_system_items comp_item

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
93: AND comp_item.organization_id = bom.organization_id
94: AND comp.bill_sequence_id = bom.common_bill_sequence_id

Line 107: index (item2 mtl_system_items_b_n7) */

103: AND upd2.error_message IS NULL
104: AND upd2.process_status = 3
105: UNION
106: SELECT /*+ ordered use_nl(upd3, item1, item2)
107: index (item2 mtl_system_items_b_n7) */
108: var_batch_id,
109: item2.inventory_item_id, /* other items that belong to */
110: item2.organization_id, /* the same product family */
111: 1,

Line 117: mtl_system_items item1,

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
121: AND item2.inventory_item_id <> item1.inventory_item_id

Line 118: mtl_system_items item2

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
121: AND item2.inventory_item_id <> item1.inventory_item_id
122: AND item1.organization_id = upd3.organization_id

Line 165: FROM mtl_system_items bom_item,

161: SYSDATE,
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

Line 168: mtl_system_items comp_item,

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
171: AND bom_item.organization_id = bom.organization_id
172: AND bom_item.inventory_item_id = bom.assembly_item_id

Line 257: mtl_system_items item

253: -1,
254: SYSDATE,
255: -1
256: FROM mrp_sales_order_updates upd1,
257: mtl_system_items item
258: WHERE item.organization_id = upd1.organization_id
259: AND item.inventory_item_id = upd1.inventory_item_id
260: AND upd1.request_id IS NOT NULL
261: AND upd1.error_message IS NULL

Line 276: mtl_system_items bom_item,

272: -1,
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

Line 279: mtl_system_items comp_item

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: --
282: -- This is the logic we have added to skip explosion of
283: -- option classes if the profile is set to SYS_NO.

Line 305: INDEX (item2 MTL_SYSTEM_ITEMS_B_N7)

301: AND upd2.error_message IS NULL
302: AND upd2.process_status = 3
303: UNION
304: SELECT /*+ INDEX (upd3 MRP_SALES_ORDER_UPDATES_N4)
305: INDEX (item2 MTL_SYSTEM_ITEMS_B_N7)
306: ORDERED
307: USE_NL (upd3, item1,item2) */
308: var_batch_id,
309: item2.inventory_item_id, /* other items that belong to */

Line 317: mtl_system_items item1,

313: -1,
314: SYSDATE,
315: -1
316: FROM mrp_sales_order_updates upd3,
317: mtl_system_items item1,
318: mtl_system_items item2
319: WHERE item2.product_family_item_id = item1.product_family_item_id
320: AND item2.organization_id = item1.organization_id
321: AND item2.inventory_item_id <> item1.inventory_item_id

Line 318: mtl_system_items item2

314: SYSDATE,
315: -1
316: FROM mrp_sales_order_updates upd3,
317: mtl_system_items item1,
318: mtl_system_items item2
319: WHERE item2.product_family_item_id = item1.product_family_item_id
320: AND item2.organization_id = item1.organization_id
321: AND item2.inventory_item_id <> item1.inventory_item_id
322: AND item1.organization_id = upd3.organization_id

Line 371: mtl_system_items comp_item,

367: -1,
368: SYSDATE,
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

Line 374: mtl_system_items bom_item

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
378: -- option classes if the profile is set to SYS_NO.