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 HZ_CUSTOMER_PROFILES

Line 290: l_review_cycle_as_of_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE %type;

286: l_create_request_flag VARCHAR2(1) := 'N';
287: l_case_folder_count NUMBER;
288: l_review_type VARCHAR2(30);
289: l_currency_code hz_cust_profile_amts.currency_code%type;
290: l_review_cycle_as_of_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE %type;
291: l_next_review_date hz_customer_profiles.NEXT_CREDIT_REVIEW_DATE%type;
292: l_cust_level VARCHAR2(30);
293: l_cust_account_id VARCHAR2(360);
294: l_last_review_date_for_curr ar_cmgt_credit_requests.application_date%type;

Line 291: l_next_review_date hz_customer_profiles.NEXT_CREDIT_REVIEW_DATE%type;

287: l_case_folder_count NUMBER;
288: l_review_type VARCHAR2(30);
289: l_currency_code hz_cust_profile_amts.currency_code%type;
290: l_review_cycle_as_of_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE %type;
291: l_next_review_date hz_customer_profiles.NEXT_CREDIT_REVIEW_DATE%type;
292: l_cust_level VARCHAR2(30);
293: l_cust_account_id VARCHAR2(360);
294: l_last_review_date_for_curr ar_cmgt_credit_requests.application_date%type;
295: l_results VARCHAR2(1);

Line 301: cust_account_id hz_customer_profiles.cust_account_id%type,

297:
298: Type review_row IS RECORD
299: (
300: party_id hz_parties.party_id%type,
301: cust_account_id hz_customer_profiles.cust_account_id%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,

Line 302: site_use_id hz_customer_profiles.site_use_id%type,

298: Type review_row IS RECORD
299: (
300: party_id hz_parties.party_id%type,
301: cust_account_id hz_customer_profiles.cust_account_id%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,

Line 303: review_cycle hz_customer_profiles.review_cycle%type,

299: (
300: party_id hz_parties.party_id%type,
301: cust_account_id hz_customer_profiles.cust_account_id%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,

Line 304: next_review_date hz_customer_profiles.NEXT_CREDIT_REVIEW_DATE%type ,

300: party_id hz_parties.party_id%type,
301: cust_account_id hz_customer_profiles.cust_account_id%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,

Line 305: last_review_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE %type,

301: cust_account_id hz_customer_profiles.cust_account_id%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

Line 308: profile_id hz_customer_profiles.CUST_ACCOUNT_PROFILE_ID%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:
312: --Changes End------------------------------------------------------------------------------------------------------

Line 355: FROM hz_customer_profiles hcp,

351: checklist.review_type review_type,
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

Line 384: hz_customer_profiles hcp,

380: checklist.credit_classification credit_classification,
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

Line 415: hz_customer_profiles hcp,

411: hcp.CUST_ACCOUNT_PROFILE_ID profile_id,
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

Line 444: FROM hz_customer_profiles hcp,

440: checklist.review_type,
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

Line 750: UPDATE HZ_CUSTOMER_PROFILES

746: BEGIN
747: IF pg_debug = 'Y' THEN
748: debug ('Updating HZ table' );
749: END IF;
750: UPDATE HZ_CUSTOMER_PROFILES
751: SET NEXT_CREDIT_REVIEW_DATE =
752: DECODE(review_cycle,
753: 'YEARLY', (trunc(sysdate) + 365),
754: 'HALF_YEARLY', (trunc(sysdate) + 180),

Line 763: WHERE HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_PROFILE_ID = review_rec.profile_id;

759: LAST_CREDIT_REVIEW_DATE = trunc(SYSDATE),
760: LAST_UPDATED_BY = fnd_global.user_id,
761: LAST_UPDATE_DATE = sysdate,
762: last_update_login = fnd_global.login_id
763: WHERE HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_PROFILE_ID = review_rec.profile_id;
764: END;
765: END IF;
766: END IF;
767: END LOOP;