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_CREDIT_REQUESTS

Line 294: l_last_review_date_for_curr ar_cmgt_credit_requests.application_date%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);
296: l_exist_trx_currency ar_cmgt_credit_requests.trx_currency%type;
297:
298: Type review_row IS RECORD

Line 296: l_exist_trx_currency ar_cmgt_credit_requests.trx_currency%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);
296: l_exist_trx_currency ar_cmgt_credit_requests.trx_currency%type;
297:
298: Type review_row IS RECORD
299: (
300: party_id hz_parties.party_id%type,

Line 599: FROM ar_cmgt_credit_requests

595: THEN
596: BEGIN
597: SELECT trx_currency
598: INTO l_exist_trx_currency
599: FROM ar_cmgt_credit_requests
600: WHERE party_id = review_rec.party_id
601: AND cust_account_id = review_rec.cust_account_id
602: AND site_use_id = review_rec.site_use_id
603: AND source_name = 'AR_PERIODIC_REVIEW'