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_WF_ENGINE dependencies on HZ_CUST_ACCOUNTS

Line 1168: l_cust_account_id hz_cust_accounts.cust_account_id%type;

1164: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1165: l_requestor_user_name fnd_user.user_name%type;
1166: l_requestor_display_name per_people_f.full_name%type;
1167: l_party_id hz_parties.party_id%type;
1168: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1169: l_party_name hz_parties.party_name%type;
1170: l_party_number hz_parties.party_number%type;
1171: l_account_number hz_cust_accounts.account_number%type;
1172: l_application_date ar_cmgt_credit_requests.application_date%type;

Line 1171: l_account_number hz_cust_accounts.account_number%type;

1167: l_party_id hz_parties.party_id%type;
1168: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1169: l_party_name hz_parties.party_name%type;
1170: l_party_number hz_parties.party_number%type;
1171: l_account_number hz_cust_accounts.account_number%type;
1172: l_application_date ar_cmgt_credit_requests.application_date%type;
1173: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1174: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1175: l_source_column3 ar_cmgt_credit_requests.source_column3%type;

Line 1416: FROM hz_cust_accounts

1412: THEN
1413: BEGIN
1414: SELECT ACCOUNT_NUMBER
1415: INTO l_account_number
1416: FROM hz_cust_accounts
1417: WHERE cust_account_id = l_cust_account_id;
1418: EXCEPTION
1419: WHEN NO_DATA_FOUND THEN
1420: l_account_number := null;

Line 3823: l_cust_account_id hz_cust_accounts.cust_account_id%type;

3819: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
3820: l_requestor_user_name fnd_user.user_name%type;
3821: l_requestor_display_name per_people_f.full_name%type;
3822: l_party_id hz_parties.party_id%type;
3823: l_cust_account_id hz_cust_accounts.cust_account_id%type;
3824: l_party_name hz_parties.party_name%type;
3825: l_party_number hz_parties.party_number%type;
3826: l_account_number hz_cust_accounts.account_number%type;
3827: l_application_date ar_cmgt_credit_requests.application_date%type;

Line 3826: l_account_number hz_cust_accounts.account_number%type;

3822: l_party_id hz_parties.party_id%type;
3823: l_cust_account_id hz_cust_accounts.cust_account_id%type;
3824: l_party_name hz_parties.party_name%type;
3825: l_party_number hz_parties.party_number%type;
3826: l_account_number hz_cust_accounts.account_number%type;
3827: l_application_date ar_cmgt_credit_requests.application_date%type;
3828: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
3829: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
3830: l_source_column3 ar_cmgt_credit_requests.source_column3%type;

Line 4042: FROM hz_cust_accounts

4038: THEN
4039: BEGIN
4040: SELECT ACCOUNT_NUMBER
4041: INTO l_account_number
4042: FROM hz_cust_accounts
4043: WHERE cust_account_id = l_cust_account_id;
4044: EXCEPTION
4045: WHEN NO_DATA_FOUND THEN
4046: l_account_number := null;