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.JG_JGZZARIN_XMLP_PKG dependencies on FND_LOOKUPS

Line 26: FND_LOOKUPS LC1,

22: ' ' || LC2.MEANING || ' ',
23: ' ' || LC3.MEANING || ' '
24: INTO C_PL_CENT_E,C_PL_CENT_Y,C_PL_CENT
25: FROM
26: FND_LOOKUPS LC1,
27: FND_LOOKUPS LC2,
28: FND_LOOKUPS LC3
29: WHERE LC1.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'
30: AND LC1.LOOKUP_CODE = 'PL_CENT_E'

Line 27: FND_LOOKUPS LC2,

23: ' ' || LC3.MEANING || ' '
24: INTO C_PL_CENT_E,C_PL_CENT_Y,C_PL_CENT
25: FROM
26: FND_LOOKUPS LC1,
27: FND_LOOKUPS LC2,
28: FND_LOOKUPS LC3
29: WHERE LC1.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'
30: AND LC1.LOOKUP_CODE = 'PL_CENT_E'
31: AND LC2.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'

Line 28: FND_LOOKUPS LC3

24: INTO C_PL_CENT_E,C_PL_CENT_Y,C_PL_CENT
25: FROM
26: FND_LOOKUPS LC1,
27: FND_LOOKUPS LC2,
28: FND_LOOKUPS LC3
29: WHERE LC1.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'
30: AND LC1.LOOKUP_CODE = 'PL_CENT_E'
31: AND LC2.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'
32: AND LC2.LOOKUP_CODE = 'PL_CENT_Y'

Line 393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;

389: C_ZERO AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
390: C_THOUSAND AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
391: C_MILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;

Line 394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;

390: C_THOUSAND AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
391: C_MILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;
398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;

Line 395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;

391: C_MILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;
398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;
399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;

Line 396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;

392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;
398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;
399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;
400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;

Line 397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;

393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;
398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;
399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;
400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;
401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;

Line 398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;

394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;
398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;
399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;
400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;
401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;
402: C_PL_CURRENCY FND_LOOKUPS.MEANING%TYPE;

Line 399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;

395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;
398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;
399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;
400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;
401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;
402: C_PL_CURRENCY FND_LOOKUPS.MEANING%TYPE;
403: C_PL_CURRENCY_E FND_LOOKUPS.MEANING%TYPE;

Line 400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;

396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;
398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;
399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;
400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;
401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;
402: C_PL_CURRENCY FND_LOOKUPS.MEANING%TYPE;
403: C_PL_CURRENCY_E FND_LOOKUPS.MEANING%TYPE;
404: C_PL_CURRENCY_YCH FND_LOOKUPS.MEANING%TYPE;

Line 401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;

397: C_PL_MILLION_Y FND_LOOKUPS.MEANING%TYPE;
398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;
399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;
400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;
401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;
402: C_PL_CURRENCY FND_LOOKUPS.MEANING%TYPE;
403: C_PL_CURRENCY_E FND_LOOKUPS.MEANING%TYPE;
404: C_PL_CURRENCY_YCH FND_LOOKUPS.MEANING%TYPE;
405: NUMBER_TOO_LARGE EXCEPTION;

Line 402: C_PL_CURRENCY FND_LOOKUPS.MEANING%TYPE;

398: C_PL_MILLION_OW FND_LOOKUPS.MEANING%TYPE;
399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;
400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;
401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;
402: C_PL_CURRENCY FND_LOOKUPS.MEANING%TYPE;
403: C_PL_CURRENCY_E FND_LOOKUPS.MEANING%TYPE;
404: C_PL_CURRENCY_YCH FND_LOOKUPS.MEANING%TYPE;
405: NUMBER_TOO_LARGE EXCEPTION;
406: NUMERAL INTEGER := ABS(IN_NUMERAL);

Line 403: C_PL_CURRENCY_E FND_LOOKUPS.MEANING%TYPE;

399: C_PL_BILLION FND_LOOKUPS.MEANING%TYPE;
400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;
401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;
402: C_PL_CURRENCY FND_LOOKUPS.MEANING%TYPE;
403: C_PL_CURRENCY_E FND_LOOKUPS.MEANING%TYPE;
404: C_PL_CURRENCY_YCH FND_LOOKUPS.MEANING%TYPE;
405: NUMBER_TOO_LARGE EXCEPTION;
406: NUMERAL INTEGER := ABS(IN_NUMERAL);
407: MAX_DIGIT INTEGER := 12;

Line 404: C_PL_CURRENCY_YCH FND_LOOKUPS.MEANING%TYPE;

400: C_PL_BILLION_Y FND_LOOKUPS.MEANING%TYPE;
401: C_PL_BILLION_OW FND_LOOKUPS.MEANING%TYPE;
402: C_PL_CURRENCY FND_LOOKUPS.MEANING%TYPE;
403: C_PL_CURRENCY_E FND_LOOKUPS.MEANING%TYPE;
404: C_PL_CURRENCY_YCH FND_LOOKUPS.MEANING%TYPE;
405: NUMBER_TOO_LARGE EXCEPTION;
406: NUMERAL INTEGER := ABS(IN_NUMERAL);
407: MAX_DIGIT INTEGER := 12;
408: NUMBER_TEXT VARCHAR2(240) := '';

Line 494: FND_LOOKUPS LC10,

490: ' ' || LC41.MEANING || ' ',
491: ' ' || LC42.MEANING || ' '
492: INTO C_PL_BILLION,C_PL_BILLION_Y,C_PL_BILLION_OW,C_PL_MILLION,C_PL_MILLION_Y,C_PL_MILLION_OW,C_PL_THOUSAND,C_PL_THOUSAND_Y,C_PL_THOUSAND_E,C_PL_CURRENCY,C_PL_CURRENCY_E,C_PL_CURRENCY_YCH
493: FROM
494: FND_LOOKUPS LC10,
495: FND_LOOKUPS LC11,
496: FND_LOOKUPS LC12,
497: FND_LOOKUPS LC20,
498: FND_LOOKUPS LC21,

Line 495: FND_LOOKUPS LC11,

491: ' ' || LC42.MEANING || ' '
492: INTO C_PL_BILLION,C_PL_BILLION_Y,C_PL_BILLION_OW,C_PL_MILLION,C_PL_MILLION_Y,C_PL_MILLION_OW,C_PL_THOUSAND,C_PL_THOUSAND_Y,C_PL_THOUSAND_E,C_PL_CURRENCY,C_PL_CURRENCY_E,C_PL_CURRENCY_YCH
493: FROM
494: FND_LOOKUPS LC10,
495: FND_LOOKUPS LC11,
496: FND_LOOKUPS LC12,
497: FND_LOOKUPS LC20,
498: FND_LOOKUPS LC21,
499: FND_LOOKUPS LC22,

Line 496: FND_LOOKUPS LC12,

492: INTO C_PL_BILLION,C_PL_BILLION_Y,C_PL_BILLION_OW,C_PL_MILLION,C_PL_MILLION_Y,C_PL_MILLION_OW,C_PL_THOUSAND,C_PL_THOUSAND_Y,C_PL_THOUSAND_E,C_PL_CURRENCY,C_PL_CURRENCY_E,C_PL_CURRENCY_YCH
493: FROM
494: FND_LOOKUPS LC10,
495: FND_LOOKUPS LC11,
496: FND_LOOKUPS LC12,
497: FND_LOOKUPS LC20,
498: FND_LOOKUPS LC21,
499: FND_LOOKUPS LC22,
500: FND_LOOKUPS LC30,

Line 497: FND_LOOKUPS LC20,

493: FROM
494: FND_LOOKUPS LC10,
495: FND_LOOKUPS LC11,
496: FND_LOOKUPS LC12,
497: FND_LOOKUPS LC20,
498: FND_LOOKUPS LC21,
499: FND_LOOKUPS LC22,
500: FND_LOOKUPS LC30,
501: FND_LOOKUPS LC31,

Line 498: FND_LOOKUPS LC21,

494: FND_LOOKUPS LC10,
495: FND_LOOKUPS LC11,
496: FND_LOOKUPS LC12,
497: FND_LOOKUPS LC20,
498: FND_LOOKUPS LC21,
499: FND_LOOKUPS LC22,
500: FND_LOOKUPS LC30,
501: FND_LOOKUPS LC31,
502: FND_LOOKUPS LC32,

Line 499: FND_LOOKUPS LC22,

495: FND_LOOKUPS LC11,
496: FND_LOOKUPS LC12,
497: FND_LOOKUPS LC20,
498: FND_LOOKUPS LC21,
499: FND_LOOKUPS LC22,
500: FND_LOOKUPS LC30,
501: FND_LOOKUPS LC31,
502: FND_LOOKUPS LC32,
503: FND_LOOKUPS LC40,

Line 500: FND_LOOKUPS LC30,

496: FND_LOOKUPS LC12,
497: FND_LOOKUPS LC20,
498: FND_LOOKUPS LC21,
499: FND_LOOKUPS LC22,
500: FND_LOOKUPS LC30,
501: FND_LOOKUPS LC31,
502: FND_LOOKUPS LC32,
503: FND_LOOKUPS LC40,
504: FND_LOOKUPS LC41,

Line 501: FND_LOOKUPS LC31,

497: FND_LOOKUPS LC20,
498: FND_LOOKUPS LC21,
499: FND_LOOKUPS LC22,
500: FND_LOOKUPS LC30,
501: FND_LOOKUPS LC31,
502: FND_LOOKUPS LC32,
503: FND_LOOKUPS LC40,
504: FND_LOOKUPS LC41,
505: FND_LOOKUPS LC42

Line 502: FND_LOOKUPS LC32,

498: FND_LOOKUPS LC21,
499: FND_LOOKUPS LC22,
500: FND_LOOKUPS LC30,
501: FND_LOOKUPS LC31,
502: FND_LOOKUPS LC32,
503: FND_LOOKUPS LC40,
504: FND_LOOKUPS LC41,
505: FND_LOOKUPS LC42
506: WHERE LC10.LOOKUP_CODE = 'PL_BILLION'

Line 503: FND_LOOKUPS LC40,

499: FND_LOOKUPS LC22,
500: FND_LOOKUPS LC30,
501: FND_LOOKUPS LC31,
502: FND_LOOKUPS LC32,
503: FND_LOOKUPS LC40,
504: FND_LOOKUPS LC41,
505: FND_LOOKUPS LC42
506: WHERE LC10.LOOKUP_CODE = 'PL_BILLION'
507: AND LC10.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'

Line 504: FND_LOOKUPS LC41,

500: FND_LOOKUPS LC30,
501: FND_LOOKUPS LC31,
502: FND_LOOKUPS LC32,
503: FND_LOOKUPS LC40,
504: FND_LOOKUPS LC41,
505: FND_LOOKUPS LC42
506: WHERE LC10.LOOKUP_CODE = 'PL_BILLION'
507: AND LC10.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'
508: AND LC11.LOOKUP_CODE = 'PL_BILLION_Y'

Line 505: FND_LOOKUPS LC42

501: FND_LOOKUPS LC31,
502: FND_LOOKUPS LC32,
503: FND_LOOKUPS LC40,
504: FND_LOOKUPS LC41,
505: FND_LOOKUPS LC42
506: WHERE LC10.LOOKUP_CODE = 'PL_BILLION'
507: AND LC10.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'
508: AND LC11.LOOKUP_CODE = 'PL_BILLION_Y'
509: AND LC11.LOOKUP_TYPE = 'JE_NLS_TRANSLATION'