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 158: FROM mtl_parameters p1,

154: OR
155: (p_control_level = G_ITEM
156: AND msi.organization_id IN
157: (SELECT p2.organization_id
158: FROM mtl_parameters p1,
159: mtl_parameters p2
160: WHERE p1.organization_id = p_Org_Id
161: AND p1.master_organization_id = p2.master_organization_id)))
162: AND rownum < 2

Line 159: mtl_parameters p2

155: (p_control_level = G_ITEM
156: AND msi.organization_id IN
157: (SELECT p2.organization_id
158: FROM mtl_parameters p1,
159: mtl_parameters p2
160: WHERE p1.organization_id = p_Org_Id
161: AND p1.master_organization_id = p2.master_organization_id)))
162: AND rownum < 2
163: FOR UPDATE NOWAIT;

Line 199: from mtl_parameters

195: from bom_bill_of_materials bom
196: where bom.assembly_item_id = p_Item_Id
197: and bom.organization_id in
198: ( select organization_id
199: from mtl_parameters
200: where master_organization_id = p_Org_Id
201: and 1 = l_bom_cntrl_level
202: union all
203: select organization_id

Line 204: from mtl_parameters

200: where master_organization_id = p_Org_Id
201: and 1 = l_bom_cntrl_level
202: union all
203: select organization_id
204: from mtl_parameters
205: where organization_id = p_Org_Id
206: and 2 =l_bom_cntrl_level));
207: end if; */
208:

Line 255: FROM mtl_parameters p1,

251: OR
252: (p_control_level = G_ITEM
253: AND msi.organization_id IN
254: (SELECT p2.organization_id
255: FROM mtl_parameters p1,
256: mtl_parameters p2
257: WHERE p1.organization_id = p_Org_Id
258: AND p1.master_organization_id = p2.master_organization_id)));
259:

Line 256: mtl_parameters p2

252: (p_control_level = G_ITEM
253: AND msi.organization_id IN
254: (SELECT p2.organization_id
255: FROM mtl_parameters p1,
256: mtl_parameters p2
257: WHERE p1.organization_id = p_Org_Id
258: AND p1.master_organization_id = p2.master_organization_id)));
259:
260: /* Update all the Eight Item Attributes */

Line 281: FROM mtl_parameters p1,

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

Line 282: mtl_parameters p2

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

Line 305: FROM mtl_parameters p1,

301: OR
302: (p_control_level = G_ITEM
303: AND msi.organization_id IN
304: (SELECT p2.organization_id
305: FROM mtl_parameters p1,
306: mtl_parameters p2
307: WHERE p1.organization_id = p_Org_Id
308: AND p1.master_organization_id = p2.master_organization_id)));
309:

Line 306: mtl_parameters p2

302: (p_control_level = G_ITEM
303: AND msi.organization_id IN
304: (SELECT p2.organization_id
305: FROM mtl_parameters p1,
306: mtl_parameters p2
307: WHERE p1.organization_id = p_Org_Id
308: AND p1.master_organization_id = p2.master_organization_id)));
309:
310: /* Updating pending Item Status */

Line 330: FROM mtl_parameters p1,

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

Line 331: mtl_parameters p2

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

Line 354: FROM mtl_parameters p1,

350: OR
351: (p_control_level = G_ITEM
352: AND msi.organization_id IN
353: (SELECT p2.organization_id
354: FROM mtl_parameters p1,
355: mtl_parameters p2
356: WHERE p1.organization_id = p_Org_Id
357: AND p1.master_organization_id = p2.master_organization_id)));
358:

Line 355: mtl_parameters p2

351: (p_control_level = G_ITEM
352: AND msi.organization_id IN
353: (SELECT p2.organization_id
354: FROM mtl_parameters p1,
355: mtl_parameters p2
356: WHERE p1.organization_id = p_Org_Id
357: AND p1.master_organization_id = p2.master_organization_id)));
358:
359: UPDATE mtl_system_items msi

Line 379: FROM mtl_parameters p1,

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

Line 380: mtl_parameters p2

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

Line 403: FROM mtl_parameters p1,

399: OR
400: (p_control_level = G_ITEM
401: AND msi.organization_id IN
402: (SELECT p2.organization_id
403: FROM mtl_parameters p1,
404: mtl_parameters p2
405: WHERE p1.organization_id = p_Org_Id
406: AND p1.master_organization_id = p2.master_organization_id)));
407:

Line 404: mtl_parameters p2

400: (p_control_level = G_ITEM
401: AND msi.organization_id IN
402: (SELECT p2.organization_id
403: FROM mtl_parameters p1,
404: mtl_parameters p2
405: WHERE p1.organization_id = p_Org_Id
406: AND p1.master_organization_id = p2.master_organization_id)));
407:
408:

Line 428: FROM mtl_parameters p1,

424: OR
425: (p_control_level = G_ITEM
426: AND msi.organization_id IN
427: (SELECT p2.organization_id
428: FROM mtl_parameters p1,
429: mtl_parameters p2
430: WHERE p1.organization_id = p_Org_Id
431: AND p1.master_organization_id = p2.master_organization_id)));
432:

Line 429: mtl_parameters p2

425: (p_control_level = G_ITEM
426: AND msi.organization_id IN
427: (SELECT p2.organization_id
428: FROM mtl_parameters p1,
429: mtl_parameters p2
430: WHERE p1.organization_id = p_Org_Id
431: AND p1.master_organization_id = p2.master_organization_id)));
432:
433:

Line 454: FROM mtl_parameters p1,

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

Line 455: mtl_parameters p2

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

Line 476: FROM mtl_parameters p1,

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

Line 477: mtl_parameters p2

473: (p_control_level = G_ITEM
474: AND msi.organization_id IN
475: (SELECT p2.organization_id
476: FROM mtl_parameters p1,
477: mtl_parameters p2
478: WHERE p1.organization_id = p_Org_Id
479: AND p1.master_organization_id = p2.master_organization_id)));
480:
481: --update process_execution enabled flag based on status

Line 499: FROM mtl_parameters p1,

495: OR
496: (p_control_level = G_ITEM
497: AND msi.organization_id IN
498: (SELECT p2.organization_id
499: FROM mtl_parameters p1,
500: mtl_parameters p2
501: WHERE p1.organization_id = p_Org_Id
502: AND p1.master_organization_id = p2.master_organization_id)));
503:

Line 500: mtl_parameters p2

496: (p_control_level = G_ITEM
497: AND msi.organization_id IN
498: (SELECT p2.organization_id
499: FROM mtl_parameters p1,
500: mtl_parameters p2
501: WHERE p1.organization_id = p_Org_Id
502: AND p1.master_organization_id = p2.master_organization_id)));
503:
504: /* End Bug 3713912 */