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.JE_JEPLPSSR_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 44: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

40: RETURN (FALSE);
41: END GET_COVER_PAGE_VALUES;
42:
43: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
44: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: NLS_YES FND_LOOKUPS.MEANING%TYPE;
48: NLS_NO FND_LOOKUPS.MEANING%TYPE;

Line 45: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

41: END GET_COVER_PAGE_VALUES;
42:
43: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
44: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: NLS_YES FND_LOOKUPS.MEANING%TYPE;
48: NLS_NO FND_LOOKUPS.MEANING%TYPE;
49: BEGIN

Line 46: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

42:
43: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
44: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: NLS_YES FND_LOOKUPS.MEANING%TYPE;
48: NLS_NO FND_LOOKUPS.MEANING%TYPE;
49: BEGIN
50: SELECT

Line 60: AP_LOOKUP_CODES L1,

56: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
57: FROM
58: FND_LOOKUPS LY,
59: FND_LOOKUPS LN,
60: AP_LOOKUP_CODES L1,
61: AP_LOOKUP_CODES L2,
62: AP_LOOKUP_CODES L3
63: WHERE LY.LOOKUP_TYPE = 'YES_NO'
64: AND LY.LOOKUP_CODE = 'Y'

Line 61: AP_LOOKUP_CODES L2,

57: FROM
58: FND_LOOKUPS LY,
59: FND_LOOKUPS LN,
60: AP_LOOKUP_CODES L1,
61: AP_LOOKUP_CODES L2,
62: AP_LOOKUP_CODES L3
63: WHERE LY.LOOKUP_TYPE = 'YES_NO'
64: AND LY.LOOKUP_CODE = 'Y'
65: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 62: AP_LOOKUP_CODES L3

58: FND_LOOKUPS LY,
59: FND_LOOKUPS LN,
60: AP_LOOKUP_CODES L1,
61: AP_LOOKUP_CODES L2,
62: AP_LOOKUP_CODES L3
63: WHERE LY.LOOKUP_TYPE = 'YES_NO'
64: AND LY.LOOKUP_CODE = 'Y'
65: AND LN.LOOKUP_TYPE = 'YES_NO'
66: AND LN.LOOKUP_CODE = 'N'

Line 670: AP_LOOKUP_CODES ALC

666: INTO L_PREPAY_AMOUNT
667: FROM
668: AP_INVOICES_ALL AI,
669: AP_INVOICE_DISTRIBUTIONS_ALL AID,
670: AP_LOOKUP_CODES ALC
671: WHERE AID.ACCOUNTING_DATE <= P_END_DATE
672: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'PREPAYMENT'
673: AND AID.LINE_TYPE_LOOKUP_CODE = 'ITEM'
674: AND AI.INVOICE_ID = AID.INVOICE_ID