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.AR_ARXCCS_XMLP_PKG dependencies on AR_LOOKUPS

Line 595: ar_lookups lk,

591: NULL, '*', ' '))), ' ')
592: into l_ytd_writeoff_amount,
593: l_ytd_convert_writeoff
594: from ar_adjustments,
595: ar_lookups lk,
596: ar_payment_schedules
597: where ar_adjustments.reason_code
598: = lk.lookup_code(+)
599: and lk.lookup_code(+) = 'WRITE OFF'

Line 855: l_cred_summ_credit_hold ar_lookups.meaning%type;

851:
852: l_cred_summ_limit_tolerance VARCHAR2(30);
853: l_cred_summ_credit_rating VARCHAR2(30);
854: l_cred_summ_risk_code VARCHAR2(30);
855: l_cred_summ_credit_hold ar_lookups.meaning%type;
856: l_cred_summ_account_status VARCHAR2(30);
857: l_cred_summ_terms VARCHAR2(20);
858: l_cred_summ_exempt_dun ar_lookups.meaning%type;
859: l_cred_summ_collector VARCHAR2(30);

Line 858: l_cred_summ_exempt_dun ar_lookups.meaning%type;

854: l_cred_summ_risk_code VARCHAR2(30);
855: l_cred_summ_credit_hold ar_lookups.meaning%type;
856: l_cred_summ_account_status VARCHAR2(30);
857: l_cred_summ_terms VARCHAR2(20);
858: l_cred_summ_exempt_dun ar_lookups.meaning%type;
859: l_cred_summ_collector VARCHAR2(30);
860: l_customer_profile_id NUMBER(30);
861: l_profile_site_use_id NUMBER(30);
862: ct_prof NUMBER(2);

Line 863: yes ar_lookups.meaning%type;

859: l_cred_summ_collector VARCHAR2(30);
860: l_customer_profile_id NUMBER(30);
861: l_profile_site_use_id NUMBER(30);
862: ct_prof NUMBER(2);
863: yes ar_lookups.meaning%type;
864: no ar_lookups.meaning%type;
865:
866: BEGIN
867:

Line 864: no ar_lookups.meaning%type;

860: l_customer_profile_id NUMBER(30);
861: l_profile_site_use_id NUMBER(30);
862: ct_prof NUMBER(2);
863: yes ar_lookups.meaning%type;
864: no ar_lookups.meaning%type;
865:
866: BEGIN
867:
868: /*srw.reference (customer_id);*/null;

Line 903: FROM AR_LOOKUPS YES,

899: SELECT INITCAP(YES.MEANING) yes,
900: INITCAP(NO.MEANING) no
901: INTO yes,
902: no
903: FROM AR_LOOKUPS YES,
904: AR_LOOKUPS NO
905: WHERE YES.LOOKUP_TYPE = 'YES/NO' AND
906: YES.LOOKUP_CODE = 'Y' AND
907: NO.LOOKUP_TYPE = 'YES/NO' AND

Line 904: AR_LOOKUPS NO

900: INITCAP(NO.MEANING) no
901: INTO yes,
902: no
903: FROM AR_LOOKUPS YES,
904: AR_LOOKUPS NO
905: WHERE YES.LOOKUP_TYPE = 'YES/NO' AND
906: YES.LOOKUP_CODE = 'Y' AND
907: NO.LOOKUP_TYPE = 'YES/NO' AND
908: NO.LOOKUP_CODE = 'N';

Line 934: ar_lookups lk,

930: l_cred_summ_collector,
931: l_customer_profile_id
932: from hz_customer_profiles cp,
933: ar_collectors coll,
934: ar_lookups lk,
935: ra_terms term
936: where cp.collector_id = coll.collector_id
937: and cp.standard_terms = term.term_id (+)
938: and cp.cust_account_id = customer_id

Line 971: ar_lookups lk,

967: l_customer_profile_id
968:
969: from hz_customer_profiles cp,
970: ar_collectors coll,
971: ar_lookups lk,
972: ra_terms term
973:
974: where cp.collector_id = coll.collector_id
975: and cp.standard_terms = term.term_id (+)

Line 1823: AR_LOOKUPS.MEANING,

1819: l_dummy NUMBER (1);
1820:
1821: CURSOR C_PAYMENT IS
1822: SELECT AR_CASH_RECEIPTS.RECEIPT_NUMBER,
1823: AR_LOOKUPS.MEANING,
1824: AR_CASH_RECEIPTS.CURRENCY_CODE,
1825: AR_CASH_RECEIPTS.AMOUNT,
1826: DECODE(AR_CASH_RECEIPTS.CURRENCY_CODE, functional_currency, ' ',
1827: DECODE(AR_CASH_RECEIPTS.EXCHANGE_RATE, NULL, '*', ' ')),

Line 1831: FROM AR_LOOKUPS,

1827: DECODE(AR_CASH_RECEIPTS.EXCHANGE_RATE, NULL, '*', ' ')),
1828: CRH.GL_DATE,
1829: ROUND(TRUNC(SYSDATE) - CRH.GL_DATE),
1830: RA_CUSTOMER_TRX.TRX_NUMBER
1831: FROM AR_LOOKUPS,
1832: AR_CASH_RECEIPTS,
1833: AR_CASH_RECEIPT_HISTORY CRH,
1834: AR_RECEIVABLE_APPLICATIONS,
1835: RA_CUSTOMER_TRX

Line 1836: WHERE NVL(AR_CASH_RECEIPTS.TYPE, 'CASH') = AR_LOOKUPS.LOOKUP_CODE

1832: AR_CASH_RECEIPTS,
1833: AR_CASH_RECEIPT_HISTORY CRH,
1834: AR_RECEIVABLE_APPLICATIONS,
1835: RA_CUSTOMER_TRX
1836: WHERE NVL(AR_CASH_RECEIPTS.TYPE, 'CASH') = AR_LOOKUPS.LOOKUP_CODE
1837: AND AR_LOOKUPS.LOOKUP_TYPE = 'PAYMENT_CATEGORY_TYPE'
1838: AND AR_CASH_RECEIPTS.PAY_FROM_CUSTOMER = CUSTOMER_ID
1839: AND AR_CASH_RECEIPTS.CUSTOMER_SITE_USE_ID = site_use_id
1840: AND AR_CASH_RECEIPTS.CASH_RECEIPT_ID =

Line 1837: AND AR_LOOKUPS.LOOKUP_TYPE = 'PAYMENT_CATEGORY_TYPE'

1833: AR_CASH_RECEIPT_HISTORY CRH,
1834: AR_RECEIVABLE_APPLICATIONS,
1835: RA_CUSTOMER_TRX
1836: WHERE NVL(AR_CASH_RECEIPTS.TYPE, 'CASH') = AR_LOOKUPS.LOOKUP_CODE
1837: AND AR_LOOKUPS.LOOKUP_TYPE = 'PAYMENT_CATEGORY_TYPE'
1838: AND AR_CASH_RECEIPTS.PAY_FROM_CUSTOMER = CUSTOMER_ID
1839: AND AR_CASH_RECEIPTS.CUSTOMER_SITE_USE_ID = site_use_id
1840: AND AR_CASH_RECEIPTS.CASH_RECEIPT_ID =
1841: AR_RECEIVABLE_APPLICATIONS.CASH_RECEIPT_ID

Line 1937: AR_LOOKUPS LK,

1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1934: AR_ADJUSTMENTS.APPLY_DATE,
1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
1936: FROM AR_ADJUSTMENTS,
1937: AR_LOOKUPS LK,
1938: AR_PAYMENT_SCHEDULES
1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)
1940: AND LK.LOOKUP_TYPE = 'ADJUST_REASON'
1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =

Line 2034: AR_LOOKUPS LK,

2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
2031: AR_ADJUSTMENTS.APPLY_DATE,
2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
2033: FROM AR_ADJUSTMENTS,
2034: AR_LOOKUPS LK,
2035: AR_PAYMENT_SCHEDULES
2036: WHERE AR_ADJUSTMENTS.REASON_CODE
2037: = LK.LOOKUP_CODE(+)
2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID

Line 2488: hz_cust_account_roles car, AR_LOOKUPS LKUPS,

2484: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' '))),
2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,
2486: ROUND(TRUNC(SYSDATE) - AR_CUSTOMER_CALL_TOPICS.CALL_DATE)
2487: FROM hz_contact_points cont_point,
2488: hz_cust_account_roles car, AR_LOOKUPS LKUPS,
2489: AR_PAYMENT_SCHEDULES, AR_CUSTOMER_CALL_TOPICS, AR_CALL_ACTIONS
2490: --WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID
2491: WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID_1
2492: --and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id

Line 3550: FROM AR_LOOKUPS YES,

3546: SELECT substr(INITCAP(YES.MEANING),1,3) yes,
3547: substr(INITCAP(NO.MEANING),1,3) no
3548: INTO yes,
3549: no
3550: FROM AR_LOOKUPS YES,
3551: AR_LOOKUPS NO
3552: WHERE YES.LOOKUP_TYPE = 'YES/NO' AND
3553: YES.LOOKUP_CODE = 'Y' AND
3554: NO.LOOKUP_TYPE = 'YES/NO' AND

Line 3551: AR_LOOKUPS NO

3547: substr(INITCAP(NO.MEANING),1,3) no
3548: INTO yes,
3549: no
3550: FROM AR_LOOKUPS YES,
3551: AR_LOOKUPS NO
3552: WHERE YES.LOOKUP_TYPE = 'YES/NO' AND
3553: YES.LOOKUP_CODE = 'Y' AND
3554: NO.LOOKUP_TYPE = 'YES/NO' AND
3555: NO.LOOKUP_CODE = 'N';

Line 3568: ar_lookups lk

3564: l_cred_summ_credit_rating,
3565: l_cred_summ_credit_hold,
3566: l_credit_profile_id
3567: from HZ_credit_profiles cp,
3568: ar_lookups lk
3569: where
3570: nvl(cp.credit_hold,'N') = lk.lookup_code
3571: and lk.lookup_type = 'YES/NO'
3572: and cp.organization_id = p_reporting_entity_id