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.BIM_PMV_DBI_UTL_PKG dependencies on FND_LOOKUP_VALUES

Line 630: FROM FND_LOOKUP_VALUES

626: /* PLD */
627: l_per_lead:='';
628:
629: SELECT MEANING into l_rev
630: FROM FND_LOOKUP_VALUES
631: WHERE LOOKUP_TYPE = 'BIM_REVENUE'
632: AND lookup_code=fnd_profile.VALUE('BIM_REVENUE')
633: AND language = USERENV('LANG');
634:

Line 642: FROM FND_LOOKUP_VALUES

638: /* to get PTD revenue and Total revenue*/
639:
640:
641: SELECT MEANING into l_period
642: FROM FND_LOOKUP_VALUES
643: WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
644: AND lookup_code=p_name
645: AND language = USERENV('LANG');
646:

Line 657: FROM FND_LOOKUP_VALUES

653:
654: /* to get <> per lead and Total <> per lead */
655:
656: SELECT MEANING into l_per_lead
657: FROM FND_LOOKUP_VALUES
658: WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
659: AND lookup_code=pld
660: AND language = USERENV('LANG');
661:

Line 672: FROM FND_LOOKUP_VALUES

668:
669: /* to get PTD <> per lead and Total <> per lead */
670:
671: SELECT MEANING into l_period
672: FROM FND_LOOKUP_VALUES
673: WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
674: AND lookup_code=p_name
675: AND language = USERENV('LANG');
676:

Line 680: FROM FND_LOOKUP_VALUES

676:
677:
678:
679: SELECT MEANING into l_per_lead
680: FROM FND_LOOKUP_VALUES
681: WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
682: AND lookup_code=pld
683: AND language = USERENV('LANG');
684:

Line 694: FROM FND_LOOKUP_VALUES

690:
691: /* to get <> Forecast */
692:
693: SELECT MEANING into l_per_lead
694: FROM FND_LOOKUP_VALUES
695: WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
696: AND lookup_code=pld
697: AND language = USERENV('LANG');
698:

Line 708: FROM FND_LOOKUP_VALUES

704:
705: /* to get <> variance */
706:
707: SELECT MEANING into l_per_lead
708: FROM FND_LOOKUP_VALUES
709: WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
710: AND lookup_code=pld
711: AND language = USERENV('LANG');
712:

Line 729: FROM fnd_lookup_values

725: l_meaning varchar2(100) ;
726:
727: CURSOR c_rid (code varchar2) IS
728: SELECT MEANING
729: FROM fnd_lookup_values
730: WHERE lookup_type = 'BIM_GEN_LOOKUP'
731: AND lookup_code =code
732: AND language = USERENV('LANG');
733: