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_CMGT_REVIEW_CONC dependencies on AR_CMGT_CHECK_LISTS

Line 273: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

269:
270: --Declare Local variables
271: l_review_cycle VARCHAR2(30);
272: l_review_match_rule VARCHAR2(30);
273: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
274: l_match_prev_cf_checklist VARCHAR2(80);
275: l_profile_class_id NUMBER(15);
276: l_credit_classification VARCHAR2(30);
277: l_processing_option VARCHAR2(30);

Line 306: review_type ar_cmgt_check_lists.review_type%type,

302: site_use_id hz_customer_profiles.site_use_id%type,
303: review_cycle hz_customer_profiles.review_cycle%type,
304: next_review_date hz_customer_profiles.NEXT_CREDIT_REVIEW_DATE%type ,
305: last_review_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE %type,
306: review_type ar_cmgt_check_lists.review_type%type,
307: credit_classification ar_cmgt_check_lists.credit_classification%type,
308: profile_id hz_customer_profiles.CUST_ACCOUNT_PROFILE_ID%type,
309: cp_credit_classification ar_cmgt_check_lists.credit_classification%type
310: );

Line 307: credit_classification ar_cmgt_check_lists.credit_classification%type,

303: review_cycle hz_customer_profiles.review_cycle%type,
304: next_review_date hz_customer_profiles.NEXT_CREDIT_REVIEW_DATE%type ,
305: last_review_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE %type,
306: review_type ar_cmgt_check_lists.review_type%type,
307: credit_classification ar_cmgt_check_lists.credit_classification%type,
308: profile_id hz_customer_profiles.CUST_ACCOUNT_PROFILE_ID%type,
309: cp_credit_classification ar_cmgt_check_lists.credit_classification%type
310: );
311:

Line 309: cp_credit_classification ar_cmgt_check_lists.credit_classification%type

305: last_review_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE %type,
306: review_type ar_cmgt_check_lists.review_type%type,
307: credit_classification ar_cmgt_check_lists.credit_classification%type,
308: profile_id hz_customer_profiles.CUST_ACCOUNT_PROFILE_ID%type,
309: cp_credit_classification ar_cmgt_check_lists.credit_classification%type
310: );
311:
312: --Changes End------------------------------------------------------------------------------------------------------
313:

Line 356: ar_cmgt_check_lists checklist,

352: checklist.credit_classification credit_classification,
353: hcp.CUST_ACCOUNT_PROFILE_ID profile_id,
354: hcp.credit_classification cp_credit_classification
355: FROM hz_customer_profiles hcp,
356: ar_cmgt_check_lists checklist,
357: hz_parties party
358: WHERE hcp.party_id = NVL(:bnd_party_id ,hcp.party_id)
359: AND :bnd_cust_account_id IS NULL
360: AND hcp.cust_account_id = -1

Line 385: ar_cmgt_check_lists checklist,

381: hcp.CUST_ACCOUNT_PROFILE_ID profile_id,
382: hcp.credit_classification cp_credit_classification
383: FROM hz_parties party,
384: hz_customer_profiles hcp,
385: ar_cmgt_check_lists checklist,
386: hz_cust_accounts cust
387: WHERE hcp.party_id = NVL(:bnd_party_id ,hcp.party_id)
388: AND party.party_id = hcp.party_id
389: AND hcp.CUST_ACCOUNT_ID = NVL(:bnd_cust_account_id ,hcp.CUST_ACCOUNT_ID)

Line 416: ar_cmgt_check_lists checklist

412: hcp.credit_classification cp_credit_classification
413: FROM hz_parties party,
414: HZ_CUST_SITE_USES_ALL uses ,
415: hz_customer_profiles hcp,
416: ar_cmgt_check_lists checklist
417: WHERE hcp.party_id = NVL(:bnd_party_id,hcp.party_id)
418: AND hcp.CUST_ACCOUNT_ID = NVL(:bnd_cust_account_id ,hcp.CUST_ACCOUNT_ID)
419: AND party.party_id = hcp.party_id
420: AND hcp.cust_account_id <> -1

Line 445: ar_cmgt_check_lists checklist,

441: checklist.credit_classification,
442: hcp.CUST_ACCOUNT_PROFILE_ID profile_id,
443: hcp.credit_classification cp_credit_classification
444: FROM hz_customer_profiles hcp,
445: ar_cmgt_check_lists checklist,
446: hz_parties party,
447: HZ_CUST_SITE_USES_ALL uses
448: WHERE party.party_id = hcp.party_id
449: AND :bnd_party_id IS NULL