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 1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;

1408: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1409: l_requestor_user_name fnd_user.user_name%type;
1410: l_requestor_display_name per_people_f.full_name%type;
1411: l_party_id hz_parties.party_id%type;
1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1413: l_party_name hz_parties.party_name%type;
1414: l_party_number hz_parties.party_number%type;
1415: l_account_number hz_cust_accounts.account_number%type;
1416: l_application_date ar_cmgt_credit_requests.application_date%type;

Line 1415: l_account_number hz_cust_accounts.account_number%type;

1411: l_party_id hz_parties.party_id%type;
1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1413: l_party_name hz_parties.party_name%type;
1414: l_party_number hz_parties.party_number%type;
1415: l_account_number hz_cust_accounts.account_number%type;
1416: l_application_date ar_cmgt_credit_requests.application_date%type;
1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;

Line 1660: FROM hz_cust_accounts

1656: THEN
1657: BEGIN
1658: SELECT ACCOUNT_NUMBER
1659: INTO l_account_number
1660: FROM hz_cust_accounts
1661: WHERE cust_account_id = l_cust_account_id;
1662: EXCEPTION
1663: WHEN NO_DATA_FOUND THEN
1664: l_account_number := null;

Line 4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;

4327: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
4328: l_requestor_user_name fnd_user.user_name%type;
4329: l_requestor_display_name per_people_f.full_name%type;
4330: l_party_id hz_parties.party_id%type;
4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;
4332: l_party_name hz_parties.party_name%type;
4333: l_party_number hz_parties.party_number%type;
4334: l_account_number hz_cust_accounts.account_number%type;
4335: l_application_date ar_cmgt_credit_requests.application_date%type;

Line 4334: l_account_number hz_cust_accounts.account_number%type;

4330: l_party_id hz_parties.party_id%type;
4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;
4332: l_party_name hz_parties.party_name%type;
4333: l_party_number hz_parties.party_number%type;
4334: l_account_number hz_cust_accounts.account_number%type;
4335: l_application_date ar_cmgt_credit_requests.application_date%type;
4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;

Line 4551: FROM hz_cust_accounts

4547: THEN
4548: BEGIN
4549: SELECT ACCOUNT_NUMBER
4550: INTO l_account_number
4551: FROM hz_cust_accounts
4552: WHERE cust_account_id = l_cust_account_id;
4553: EXCEPTION
4554: WHEN NO_DATA_FOUND THEN
4555: l_account_number := null;