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_UTIL dependencies on FND_INSTALLATION

Line 104: lv_retval := FND_INSTALLATION.GET_APP_INFO('FND', lv_dummy1,lv_dummy2, v_applsys_schema);

100: lv_prod_short_name VARCHAR2(30);
101: v_sql_stmt VARCHAR2(6000);
102:
103: begin
104: lv_retval := FND_INSTALLATION.GET_APP_INFO('FND', lv_dummy1,lv_dummy2, v_applsys_schema);
105: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(401);
106: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_inv_schema);
107:
108: v_sql_stmt:= 'CREATE MATERIALIZED VIEW log ON '||lv_inv_schema ||'.'||p_table_name||' WITH ROWID ' ;

Line 106: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_inv_schema);

102:
103: begin
104: lv_retval := FND_INSTALLATION.GET_APP_INFO('FND', lv_dummy1,lv_dummy2, v_applsys_schema);
105: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(401);
106: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_inv_schema);
107:
108: v_sql_stmt:= 'CREATE MATERIALIZED VIEW log ON '||lv_inv_schema ||'.'||p_table_name||' WITH ROWID ' ;
109: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
110: application_short_name => lv_prod_short_name ,

Line 381: l_installed := fnd_installation.get( appl_id => 401, dep_appl_id => 401,

377: /* Package initialization block (runs only once per session) */
378: /*-----------------------------------------------------------*/
379:
380: BEGIN
381: l_installed := fnd_installation.get( appl_id => 401, dep_appl_id => 401,
382: status => l_status, industry => l_industry );
383: if (l_status = 'I')
384: then g_Appl_Inst.inv := 401;
385: else g_Appl_Inst.inv := 0;

Line 388: l_installed := fnd_installation.get( appl_id => 201, dep_appl_id => 201,

384: then g_Appl_Inst.inv := 401;
385: else g_Appl_Inst.inv := 0;
386: end if;
387:
388: l_installed := fnd_installation.get( appl_id => 201, dep_appl_id => 201,
389: status => l_status, industry => l_industry );
390: if (l_status = 'I')
391: then g_Appl_Inst.po := 201;
392: else g_Appl_Inst.po := 0;

Line 395: l_installed := fnd_installation.get( appl_id => 702, dep_appl_id => 702,

391: then g_Appl_Inst.po := 201;
392: else g_Appl_Inst.po := 0;
393: end if;
394:
395: l_installed := fnd_installation.get( appl_id => 702, dep_appl_id => 702,
396: status => l_status, industry => l_industry );
397: if (l_status = 'I')
398: then g_Appl_Inst.bom := 702;
399: else g_Appl_Inst.bom := 0;

Line 402: l_installed := fnd_installation.get( appl_id => 703, dep_appl_id => 703,

398: then g_Appl_Inst.bom := 702;
399: else g_Appl_Inst.bom := 0;
400: end if;
401:
402: l_installed := fnd_installation.get( appl_id => 703, dep_appl_id => 703,
403: status => l_status, industry => l_industry );
404: if (l_status = 'I')
405: then g_Appl_Inst.eng := 703;
406: else g_Appl_Inst.eng := 0;

Line 409: l_installed := fnd_installation.get( appl_id => 170, dep_appl_id => 170,

405: then g_Appl_Inst.eng := 703;
406: else g_Appl_Inst.eng := 0;
407: end if;
408:
409: l_installed := fnd_installation.get( appl_id => 170, dep_appl_id => 170,
410: status => l_status, industry => l_industry );
411: if (l_status = 'I')
412: then g_Appl_Inst.cs := 170;
413: else g_Appl_Inst.cs := 0;

Line 416: l_installed := fnd_installation.get( appl_id => 222, dep_appl_id => 222,

412: then g_Appl_Inst.cs := 170;
413: else g_Appl_Inst.cs := 0;
414: end if;
415:
416: l_installed := fnd_installation.get( appl_id => 222, dep_appl_id => 222,
417: status => l_status, industry => l_industry );
418: if (l_status = 'I')
419: then g_Appl_Inst.ar := 222;
420: else g_Appl_Inst.ar := 0;

Line 423: l_installed := fnd_installation.get( appl_id => 704, dep_appl_id => 704,

419: then g_Appl_Inst.ar := 222;
420: else g_Appl_Inst.ar := 0;
421: end if;
422:
423: l_installed := fnd_installation.get( appl_id => 704, dep_appl_id => 704,
424: status => l_status, industry => l_industry );
425: if (l_status in ('I', 'S'))
426: then g_Appl_Inst.mrp := 704;
427: else g_Appl_Inst.mrp := 0;

Line 430: l_installed := fnd_installation.get( appl_id => 300, dep_appl_id => 300,

426: then g_Appl_Inst.mrp := 704;
427: else g_Appl_Inst.mrp := 0;
428: end if;
429:
430: l_installed := fnd_installation.get( appl_id => 300, dep_appl_id => 300,
431: status => l_status, industry => l_industry );
432: if (l_status = 'I')
433: then g_Appl_Inst.oe := 300;
434: else g_Appl_Inst.oe := 0;

Line 437: l_installed := fnd_installation.get( appl_id => 660, dep_appl_id => 660,

433: then g_Appl_Inst.oe := 300;
434: else g_Appl_Inst.oe := 0;
435: end if;
436:
437: l_installed := fnd_installation.get( appl_id => 660, dep_appl_id => 660,
438: status => l_status, industry => l_industry );
439: if (l_status = 'I')
440: then g_Appl_Inst.ONT := 660;
441: else g_Appl_Inst.ONT := 0;

Line 444: l_installed := fnd_installation.get( appl_id => 661, dep_appl_id => 661,

440: then g_Appl_Inst.ONT := 660;
441: else g_Appl_Inst.ONT := 0;
442: end if;
443:
444: l_installed := fnd_installation.get( appl_id => 661, dep_appl_id => 661,
445: status => l_status, industry => l_industry );
446: if (l_status = 'I')
447: then g_Appl_Inst.QP := 661;
448: else g_Appl_Inst.QP := 0;

Line 451: l_installed := fnd_installation.get( appl_id => 706, dep_appl_id => 706,

447: then g_Appl_Inst.QP := 661;
448: else g_Appl_Inst.QP := 0;
449: end if;
450:
451: l_installed := fnd_installation.get( appl_id => 706, dep_appl_id => 706,
452: status => l_status, industry => l_industry );
453: if (l_status in ('I', 'S'))
454: then g_Appl_Inst.wip := 706;
455: else g_Appl_Inst.wip := 0;

Line 458: l_installed := fnd_installation.get( appl_id => 140, dep_appl_id => 140,

454: then g_Appl_Inst.wip := 706;
455: else g_Appl_Inst.wip := 0;
456: end if;
457:
458: l_installed := fnd_installation.get( appl_id => 140, dep_appl_id => 140,
459: status => l_status, industry => l_industry );
460: if (l_status = 'I')
461: then g_Appl_Inst.fa := 140;
462: else g_Appl_Inst.fa := 0;

Line 465: l_installed := fnd_installation.get( appl_id => 7004, dep_appl_id => 7004,

461: then g_Appl_Inst.fa := 140;
462: else g_Appl_Inst.fa := 0;
463: end if;
464:
465: l_installed := fnd_installation.get( appl_id => 7004, dep_appl_id => 7004,
466: status => l_status, industry => l_industry );
467: -- Depends on Latin America Localizations profile value
468: --
469: --Bug: 4880971 The profile option JGZZ_PRODUCT_CODE is getting obsoleted

Line 475: l_installed := fnd_installation.get( appl_id => 385, dep_appl_id => 385,

471: then g_Appl_Inst.jl := 7004;
472: else g_Appl_Inst.jl := 0;
473: end if;
474:
475: l_installed := fnd_installation.get( appl_id => 385, dep_appl_id => 385,
476: status => l_status, industry => l_industry );
477: if (l_status = 'I')
478: then g_Appl_Inst.WMS := 385;
479: else g_Appl_Inst.WMS := 0;

Line 482: l_installed := fnd_installation.get( appl_id => 523, dep_appl_id => 523,

478: then g_Appl_Inst.WMS := 385;
479: else g_Appl_Inst.WMS := 0;
480: end if;
481:
482: l_installed := fnd_installation.get( appl_id => 523, dep_appl_id => 523,
483: status => l_status, industry => l_industry );
484: if (l_status = 'I')
485: then g_Appl_Inst.CSP := 523;
486: else g_Appl_Inst.CSP := 0;

Line 489: l_installed := fnd_installation.get( appl_id => 514, dep_appl_id => 514,

485: then g_Appl_Inst.CSP := 523;
486: else g_Appl_Inst.CSP := 0;
487: end if;
488:
489: l_installed := fnd_installation.get( appl_id => 514, dep_appl_id => 514,
490: status => l_status, industry => l_industry );
491: if (l_status = 'I')
492: then g_Appl_Inst.CSS := 514;
493: else g_Appl_Inst.CSS := 0;

Line 496: l_installed := fnd_installation.get( appl_id => 515, dep_appl_id => 515,

492: then g_Appl_Inst.CSS := 514;
493: else g_Appl_Inst.CSS := 0;
494: end if;
495:
496: l_installed := fnd_installation.get( appl_id => 515, dep_appl_id => 515,
497: status => l_status, industry => l_industry );
498: if (l_status = 'I')
499: then g_Appl_Inst.OKS := 515;
500: else g_Appl_Inst.OKS := 0;

Line 503: l_installed := fnd_installation.get( appl_id => 530, dep_appl_id => 530,

499: then g_Appl_Inst.OKS := 515;
500: else g_Appl_Inst.OKS := 0;
501: end if;
502:
503: l_installed := fnd_installation.get( appl_id => 530, dep_appl_id => 530,
504: status => l_status, industry => l_industry );
505: if (l_status = 'I')
506: then g_Appl_Inst.AMS := 530;
507: else g_Appl_Inst.AMS := 0;

Line 510: l_installed := fnd_installation.get( appl_id => 670, dep_appl_id => 670,

506: then g_Appl_Inst.AMS := 530;
507: else g_Appl_Inst.AMS := 0;
508: end if;
509:
510: l_installed := fnd_installation.get( appl_id => 670, dep_appl_id => 670,
511: status => l_status, industry => l_industry );
512: if (l_status = 'I')
513: then g_Appl_Inst.IBA := 670;
514: else g_Appl_Inst.IBA := 0;

Line 517: l_installed := fnd_installation.get( appl_id => 671, dep_appl_id => 671,

513: then g_Appl_Inst.IBA := 670;
514: else g_Appl_Inst.IBA := 0;
515: end if;
516:
517: l_installed := fnd_installation.get( appl_id => 671, dep_appl_id => 671,
518: status => l_status, industry => l_industry );
519: if (l_status = 'I')
520: then g_Appl_Inst.IBE := 671;
521: else g_Appl_Inst.IBE := 0;

Line 524: l_installed := fnd_installation.get( appl_id => 8722, dep_appl_id => 8722,

520: then g_Appl_Inst.IBE := 671;
521: else g_Appl_Inst.IBE := 0;
522: end if;
523:
524: l_installed := fnd_installation.get( appl_id => 8722, dep_appl_id => 8722,
525: status => l_status, industry => l_industry );
526: if (l_status = 'I')
527: then g_Appl_Inst.CUI := 8722;
528: else g_Appl_Inst.CUI := 0;

Line 531: l_installed := fnd_installation.get( appl_id => 532, dep_appl_id => 532,

527: then g_Appl_Inst.CUI := 8722;
528: else g_Appl_Inst.CUI := 0;
529: end if;
530:
531: l_installed := fnd_installation.get( appl_id => 532, dep_appl_id => 532,
532: status => l_status, industry => l_industry );
533: if (l_status = 'I')
534: then g_Appl_Inst.XNC := 532;
535: else g_Appl_Inst.XNC := 0;

Line 538: l_installed := fnd_installation.get( appl_id => 8729, dep_appl_id => 8729,

534: then g_Appl_Inst.XNC := 532;
535: else g_Appl_Inst.XNC := 0;
536: end if;
537:
538: l_installed := fnd_installation.get( appl_id => 8729, dep_appl_id => 8729,
539: status => l_status, industry => l_industry );
540: if (l_status = 'I')
541: then g_Appl_Inst.CUN := 8729;
542: else g_Appl_Inst.CUN := 0;

Line 545: l_installed := fnd_installation.get( appl_id => 8727, dep_appl_id => 8727,

541: then g_Appl_Inst.CUN := 8729;
542: else g_Appl_Inst.CUN := 0;
543: end if;
544:
545: l_installed := fnd_installation.get( appl_id => 8727, dep_appl_id => 8727,
546: status => l_status, industry => l_industry );
547: if (l_status = 'I')
548: then g_Appl_Inst.CUS := 8727;
549: else g_Appl_Inst.CUS := 0;

Line 552: l_installed := fnd_installation.get( appl_id => 388, dep_appl_id => 388,

548: then g_Appl_Inst.CUS := 8727;
549: else g_Appl_Inst.CUS := 0;
550: end if;
551:
552: l_installed := fnd_installation.get( appl_id => 388, dep_appl_id => 388,
553: status => l_status, industry => l_industry );
554: if (l_status = 'I')
555: then g_Appl_Inst.WPS := 388;
556: else g_Appl_Inst.WPS := 0;

Line 559: l_installed := fnd_installation.get( appl_id => 426, dep_appl_id => 426,

555: then g_Appl_Inst.WPS := 388;
556: else g_Appl_Inst.WPS := 0;
557: end if;
558:
559: l_installed := fnd_installation.get( appl_id => 426, dep_appl_id => 426,
560: status => l_status, industry => l_industry );
561: if (l_status = 'I')
562: then g_Appl_Inst.EAM := 426;
563: else g_Appl_Inst.EAM := 0;

Line 567: l_installed := fnd_installation.get( appl_id => 455, dep_appl_id => 455,

563: else g_Appl_Inst.EAM := 0;
564: end if;
565:
566: /*Bug 3013937: Eni application installed check not required.
567: l_installed := fnd_installation.get( appl_id => 455, dep_appl_id => 455,
568: status => l_status, industry => l_industry );
569: if (l_status = 'I') then
570: */
571: --Bug: 2858117 Checking for ENI package

Line 586: l_installed := fnd_installation.get( appl_id => 431, dep_appl_id => 431,

582: else
583: g_Appl_Inst.ENI := 0;
584: end if;
585: */
586: l_installed := fnd_installation.get( appl_id => 431, dep_appl_id => 431,
587: status => l_status, industry => l_industry );
588: if (l_status = 'I')
589: then g_Appl_Inst.EGO := 431;
590: else g_Appl_Inst.EGO := 0;

Line 593: l_installed := fnd_installation.get( appl_id => 542, dep_appl_id => 542,

589: then g_Appl_Inst.EGO := 431;
590: else g_Appl_Inst.EGO := 0;
591: end if;
592:
593: l_installed := fnd_installation.get( appl_id => 542, dep_appl_id => 542,
594: status => l_status, industry => l_industry );
595: if (l_status = 'I')
596: then g_Appl_Inst.CSI := 542;
597: else g_Appl_Inst.CSI := 0;

Line 600: l_installed := fnd_installation.get( appl_id => 708, dep_appl_id => 708,

596: then g_Appl_Inst.CSI := 542;
597: else g_Appl_Inst.CSI := 0;
598: end if;
599:
600: l_installed := fnd_installation.get( appl_id => 708, dep_appl_id => 708,
601: status => l_status, industry => l_industry );
602: if (l_status = 'I')
603: then g_Appl_Inst.CZ := 708;
604: else g_Appl_Inst.CZ := 0;

Line 608: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 716,

604: else g_Appl_Inst.CZ := 0;
605: end if;
606:
607: --Bug: 2691174
608: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 716,
609: status => l_status, industry => l_industry );
610: if (l_status = 'I')
611: then g_Appl_Inst.FTE := 716;
612: else g_Appl_Inst.FTE := 0;

Line 614: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 551,

610: if (l_status = 'I')
611: then g_Appl_Inst.FTE := 716;
612: else g_Appl_Inst.FTE := 0;
613: end if;
614: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 551,
615: status => l_status, industry => l_industry );
616: if (l_status = 'I')
617: then g_Appl_Inst.GMI := 551;
618: else g_Appl_Inst.GMI := 0;

Line 621: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 552,

617: then g_Appl_Inst.GMI := 551;
618: else g_Appl_Inst.GMI := 0;
619: end if;
620: /* Start Bug 3713912 */
621: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 552,
622: status => l_status, industry => l_industry );
623: if (l_status = 'I')
624: then g_Appl_Inst.GMD := 552;
625: else g_Appl_Inst.GMD := 0;

Line 627: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 553,

623: if (l_status = 'I')
624: then g_Appl_Inst.GMD := 552;
625: else g_Appl_Inst.GMD := 0;
626: end if;
627: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 553,
628: status => l_status, industry => l_industry );
629: if (l_status = 'I')
630: then g_Appl_Inst.GME := 553;
631: else g_Appl_Inst.GME := 0;

Line 633: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 557,

629: if (l_status = 'I')
630: then g_Appl_Inst.GME := 553;
631: else g_Appl_Inst.GME := 0;
632: end if;
633: l_installed := fnd_installation.get( appl_id => 716, dep_appl_id => 557,
634: status => l_status, industry => l_industry );
635: if (l_status = 'I')
636: then g_Appl_Inst.GR := 557;
637: else g_Appl_Inst.GR := 0;

Line 643: l_installed := fnd_installation.get( appl_id => 535, dep_appl_id => 535,

639:
640: /* End Bug 3713912 */
641:
642: /* Start Bug 5015595 */
643: l_installed := fnd_installation.get( appl_id => 535, dep_appl_id => 535,
644: status => l_status, industry => l_industry );
645: if (l_status = 'I')
646: then g_Appl_Inst.XDP := 535;
647: else g_Appl_Inst.XDP := 0;

Line 657: l_installed := fnd_installation.get( appl_id => 178, dep_appl_id => 178,

653: --
654: g_Appl_Inst.PJM_Unit_Eff_flag := PJM_UNIT_EFF.Enabled();
655:
656: -- 6531763: Adding ICX install check
657: l_installed := fnd_installation.get( appl_id => 178, dep_appl_id => 178,
658: status => l_status, industry => l_industry );
659: if (l_status = 'I')
660: then g_Appl_Inst.ICX := 178;
661: else g_Appl_Inst.ICX := 0;