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.INV_ITEM_STATUS_CP dependencies on MTL_PARAMETERS

Line 137: FROM mtl_parameters p1,

133: OR
134: (p_control_level = G_ITEM
135: AND msi.organization_id IN
136: (SELECT p2.organization_id
137: FROM mtl_parameters p1,
138: mtl_parameters p2
139: WHERE p1.organization_id = p_Org_Id
140: AND p1.master_organization_id = p2.master_organization_id)))
141: AND rownum < 2

Line 138: mtl_parameters p2

134: (p_control_level = G_ITEM
135: AND msi.organization_id IN
136: (SELECT p2.organization_id
137: FROM mtl_parameters p1,
138: mtl_parameters p2
139: WHERE p1.organization_id = p_Org_Id
140: AND p1.master_organization_id = p2.master_organization_id)))
141: AND rownum < 2
142: FOR UPDATE NOWAIT;

Line 178: from mtl_parameters

174: from bom_bill_of_materials bom
175: where bom.assembly_item_id = p_Item_Id
176: and bom.organization_id in
177: ( select organization_id
178: from mtl_parameters
179: where master_organization_id = p_Org_Id
180: and 1 = l_bom_cntrl_level
181: union all
182: select organization_id

Line 183: from mtl_parameters

179: where master_organization_id = p_Org_Id
180: and 1 = l_bom_cntrl_level
181: union all
182: select organization_id
183: from mtl_parameters
184: where organization_id = p_Org_Id
185: and 2 =l_bom_cntrl_level));
186: end if; */
187:

Line 234: FROM mtl_parameters p1,

230: OR
231: (p_control_level = G_ITEM
232: AND msi.organization_id IN
233: (SELECT p2.organization_id
234: FROM mtl_parameters p1,
235: mtl_parameters p2
236: WHERE p1.organization_id = p_Org_Id
237: AND p1.master_organization_id = p2.master_organization_id)));
238:

Line 235: mtl_parameters p2

231: (p_control_level = G_ITEM
232: AND msi.organization_id IN
233: (SELECT p2.organization_id
234: FROM mtl_parameters p1,
235: mtl_parameters p2
236: WHERE p1.organization_id = p_Org_Id
237: AND p1.master_organization_id = p2.master_organization_id)));
238:
239: /* Update all the Eight Item Attributes */

Line 260: FROM mtl_parameters p1,

256: OR
257: (p_control_level = G_ITEM
258: AND msi.organization_id IN
259: (SELECT p2.organization_id
260: FROM mtl_parameters p1,
261: mtl_parameters p2
262: WHERE p1.organization_id = p_Org_Id
263: AND p1.master_organization_id = p2.master_organization_id)));
264:

Line 261: mtl_parameters p2

257: (p_control_level = G_ITEM
258: AND msi.organization_id IN
259: (SELECT p2.organization_id
260: FROM mtl_parameters p1,
261: mtl_parameters p2
262: WHERE p1.organization_id = p_Org_Id
263: AND p1.master_organization_id = p2.master_organization_id)));
264:
265: UPDATE mtl_system_items msi

Line 284: FROM mtl_parameters p1,

280: OR
281: (p_control_level = G_ITEM
282: AND msi.organization_id IN
283: (SELECT p2.organization_id
284: FROM mtl_parameters p1,
285: mtl_parameters p2
286: WHERE p1.organization_id = p_Org_Id
287: AND p1.master_organization_id = p2.master_organization_id)));
288:

Line 285: mtl_parameters p2

281: (p_control_level = G_ITEM
282: AND msi.organization_id IN
283: (SELECT p2.organization_id
284: FROM mtl_parameters p1,
285: mtl_parameters p2
286: WHERE p1.organization_id = p_Org_Id
287: AND p1.master_organization_id = p2.master_organization_id)));
288:
289: /* Updating pending Item Status */

Line 309: FROM mtl_parameters p1,

305: OR
306: (p_control_level = G_ITEM
307: AND msi.organization_id IN
308: (SELECT p2.organization_id
309: FROM mtl_parameters p1,
310: mtl_parameters p2
311: WHERE p1.organization_id = p_Org_Id
312: AND p1.master_organization_id = p2.master_organization_id)));
313:

Line 310: mtl_parameters p2

306: (p_control_level = G_ITEM
307: AND msi.organization_id IN
308: (SELECT p2.organization_id
309: FROM mtl_parameters p1,
310: mtl_parameters p2
311: WHERE p1.organization_id = p_Org_Id
312: AND p1.master_organization_id = p2.master_organization_id)));
313:
314: UPDATE mtl_system_items msi

Line 333: FROM mtl_parameters p1,

329: OR
330: (p_control_level = G_ITEM
331: AND msi.organization_id IN
332: (SELECT p2.organization_id
333: FROM mtl_parameters p1,
334: mtl_parameters p2
335: WHERE p1.organization_id = p_Org_Id
336: AND p1.master_organization_id = p2.master_organization_id)));
337:

Line 334: mtl_parameters p2

330: (p_control_level = G_ITEM
331: AND msi.organization_id IN
332: (SELECT p2.organization_id
333: FROM mtl_parameters p1,
334: mtl_parameters p2
335: WHERE p1.organization_id = p_Org_Id
336: AND p1.master_organization_id = p2.master_organization_id)));
337:
338: UPDATE mtl_system_items msi

Line 358: FROM mtl_parameters p1,

354: OR
355: (p_control_level = G_ITEM
356: AND msi.organization_id IN
357: (SELECT p2.organization_id
358: FROM mtl_parameters p1,
359: mtl_parameters p2
360: WHERE p1.organization_id = p_Org_Id
361: AND p1.master_organization_id = p2.master_organization_id)));
362:

Line 359: mtl_parameters p2

355: (p_control_level = G_ITEM
356: AND msi.organization_id IN
357: (SELECT p2.organization_id
358: FROM mtl_parameters p1,
359: mtl_parameters p2
360: WHERE p1.organization_id = p_Org_Id
361: AND p1.master_organization_id = p2.master_organization_id)));
362:
363: UPDATE mtl_system_items msi

Line 382: FROM mtl_parameters p1,

378: OR
379: (p_control_level = G_ITEM
380: AND msi.organization_id IN
381: (SELECT p2.organization_id
382: FROM mtl_parameters p1,
383: mtl_parameters p2
384: WHERE p1.organization_id = p_Org_Id
385: AND p1.master_organization_id = p2.master_organization_id)));
386:

Line 383: mtl_parameters p2

379: (p_control_level = G_ITEM
380: AND msi.organization_id IN
381: (SELECT p2.organization_id
382: FROM mtl_parameters p1,
383: mtl_parameters p2
384: WHERE p1.organization_id = p_Org_Id
385: AND p1.master_organization_id = p2.master_organization_id)));
386:
387:

Line 407: FROM mtl_parameters p1,

403: OR
404: (p_control_level = G_ITEM
405: AND msi.organization_id IN
406: (SELECT p2.organization_id
407: FROM mtl_parameters p1,
408: mtl_parameters p2
409: WHERE p1.organization_id = p_Org_Id
410: AND p1.master_organization_id = p2.master_organization_id)));
411:

Line 408: mtl_parameters p2

404: (p_control_level = G_ITEM
405: AND msi.organization_id IN
406: (SELECT p2.organization_id
407: FROM mtl_parameters p1,
408: mtl_parameters p2
409: WHERE p1.organization_id = p_Org_Id
410: AND p1.master_organization_id = p2.master_organization_id)));
411:
412:

Line 433: FROM mtl_parameters p1,

429: OR
430: (p_control_level = G_ITEM
431: AND msi.organization_id IN
432: (SELECT p2.organization_id
433: FROM mtl_parameters p1,
434: mtl_parameters p2
435: WHERE p1.organization_id = p_Org_Id
436: AND p1.master_organization_id = p2.master_organization_id)));
437:

Line 434: mtl_parameters p2

430: (p_control_level = G_ITEM
431: AND msi.organization_id IN
432: (SELECT p2.organization_id
433: FROM mtl_parameters p1,
434: mtl_parameters p2
435: WHERE p1.organization_id = p_Org_Id
436: AND p1.master_organization_id = p2.master_organization_id)));
437:
438: /* Start Bug 3713912 */

Line 455: FROM mtl_parameters p1,

451: OR
452: (p_control_level = G_ITEM
453: AND msi.organization_id IN
454: (SELECT p2.organization_id
455: FROM mtl_parameters p1,
456: mtl_parameters p2
457: WHERE p1.organization_id = p_Org_Id
458: AND p1.master_organization_id = p2.master_organization_id)));
459:

Line 456: mtl_parameters p2

452: (p_control_level = G_ITEM
453: AND msi.organization_id IN
454: (SELECT p2.organization_id
455: FROM mtl_parameters p1,
456: mtl_parameters p2
457: WHERE p1.organization_id = p_Org_Id
458: AND p1.master_organization_id = p2.master_organization_id)));
459:
460: --update process_execution enabled flag based on status

Line 478: FROM mtl_parameters p1,

474: OR
475: (p_control_level = G_ITEM
476: AND msi.organization_id IN
477: (SELECT p2.organization_id
478: FROM mtl_parameters p1,
479: mtl_parameters p2
480: WHERE p1.organization_id = p_Org_Id
481: AND p1.master_organization_id = p2.master_organization_id)));
482:

Line 479: mtl_parameters p2

475: (p_control_level = G_ITEM
476: AND msi.organization_id IN
477: (SELECT p2.organization_id
478: FROM mtl_parameters p1,
479: mtl_parameters p2
480: WHERE p1.organization_id = p_Org_Id
481: AND p1.master_organization_id = p2.master_organization_id)));
482:
483: /* End Bug 3713912 */