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_CALC_LATE_CHARGE dependencies on HZ_PARTIES

Line 1367: FROM ar_lc_cust_sites_t lc_site,hz_cust_accounts cust_acct,hz_parties party,ar_charge_schedules c_schdl,ar_charge_schedule_headers_v h_schdl

1363: /*Late charge changes for amount per tier Enhacement 6469663*/
1364: CURSOR wrong_setup(fin_charge_date in date ) is
1365: select substrb(party.party_name,1,50) name,lc_site.lc_cust_sites_id,lc_site.customer_id,lc_site.currency_code,lc_site.customer_site_use_id,
1366: 'INTEREST' type
1367: FROM ar_lc_cust_sites_t lc_site,hz_cust_accounts cust_acct,hz_parties party,ar_charge_schedules c_schdl,ar_charge_schedule_headers_v h_schdl
1368: WHERE lc_site.interest_type = 'CHARGE_PER_TIER'
1369: AND lc_site.interest_schedule_id = c_schdl.schedule_id
1370: AND c_schdl.schedule_id = h_schdl.schedule_id
1371: AND fin_charge_date between h_schdl.start_date and nvl(h_schdl.end_date,to_date('31-12-4712','DD-MM-YYYY'))

Line 1378: FROM ar_lc_cust_sites_t lc_site,hz_cust_accounts cust_acct,hz_parties party,ar_charge_schedules c_schdl,ar_charge_schedule_headers_v h_schdl

1374: AND cust_acct.party_id = party.party_id
1375: UNION
1376: select substrb(party.party_name,1,50) name,lc_site.lc_cust_sites_id,lc_site.customer_id,lc_site.currency_code,lc_site.customer_site_use_id,
1377: 'PENALTY' type
1378: FROM ar_lc_cust_sites_t lc_site,hz_cust_accounts cust_acct,hz_parties party,ar_charge_schedules c_schdl,ar_charge_schedule_headers_v h_schdl
1379: WHERE lc_site.penalty_type = 'CHARGE_PER_TIER'
1380: AND lc_site.penalty_schedule_id = c_schdl.schedule_id
1381: AND c_schdl.schedule_id = h_schdl.schedule_id
1382: AND fin_charge_date between h_schdl.start_date and nvl(h_schdl.end_date,to_date('31-12-4712','DD-MM-YYYY'))

Line 1391: l_customer_name_from hz_parties.party_name%type;

1387:
1388:
1389:
1390: l_org_id NUMBER;
1391: l_customer_name_from hz_parties.party_name%type;
1392: l_customer_name_to hz_parties.party_name%type;
1393: l_customer_number_from hz_cust_accounts.account_number%type;
1394: l_customer_number_to hz_cust_accounts.account_number%type;
1395: l_cust_site_use_id number;

Line 1392: l_customer_name_to hz_parties.party_name%type;

1388:
1389:
1390: l_org_id NUMBER;
1391: l_customer_name_from hz_parties.party_name%type;
1392: l_customer_name_to hz_parties.party_name%type;
1393: l_customer_number_from hz_cust_accounts.account_number%type;
1394: l_customer_number_to hz_cust_accounts.account_number%type;
1395: l_cust_site_use_id number;
1396: l_fin_charge_date date;

Line 1625: hz_parties party,

1621: from ar_payment_schedules ps,
1622: ar_transaction_history th,
1623: ra_customer_trx trx,
1624: hz_cust_accounts cust_acct,
1625: hz_parties party,
1626: hz_customer_profiles profiles,
1627: hz_cust_profile_amts prof_amts,
1628: hz_cust_site_uses site_use,
1629: ar_system_parameters sysparam

Line 1750: FROM ar_lc_cust_sites_t lc_site,hz_cust_accounts cust_acct,hz_parties party,ar_charge_schedules c_schdl,ar_charge_schedule_headers_v h_schdl

1746: /*Late Charge Changes for charge per tier Enhacement 6469663*/
1747: UPDATE ar_lc_cust_sites_t set penalty_type = NULL
1748: WHERE lc_cust_sites_id IN
1749: ( select lc_cust_sites_id
1750: FROM ar_lc_cust_sites_t lc_site,hz_cust_accounts cust_acct,hz_parties party,ar_charge_schedules c_schdl,ar_charge_schedule_headers_v h_schdl
1751: WHERE lc_site.penalty_type = 'CHARGE_PER_TIER'
1752: AND lc_site.penalty_schedule_id = c_schdl.schedule_id
1753: AND c_schdl.schedule_id = h_schdl.schedule_id
1754: AND p_fin_charge_date between h_schdl.start_date and nvl(h_schdl.end_date,to_date('31-12-4712','DD-MM-YYYY'))

Line 1764: FROM ar_lc_cust_sites_t lc_site,hz_cust_accounts cust_acct,hz_parties party,ar_charge_schedules c_schdl,ar_charge_schedule_headers_v h_schdl

1760: delete from ar_lc_cust_sites_t
1761: where lc_cust_sites_id IN
1762: (
1763: select lc_cust_sites_id
1764: FROM ar_lc_cust_sites_t lc_site,hz_cust_accounts cust_acct,hz_parties party,ar_charge_schedules c_schdl,ar_charge_schedule_headers_v h_schdl
1765: WHERE lc_site.interest_type = 'CHARGE_PER_TIER'
1766: AND lc_site.interest_schedule_id = c_schdl.schedule_id
1767: AND c_schdl.schedule_id = h_schdl.schedule_id
1768: AND p_fin_charge_date between h_schdl.start_date and nvl(h_schdl.end_date,to_date('31-12-4712','DD-MM-YYYY'))

Line 7089: l_customer_name_from hz_parties.party_name%type;

7085: p_master_request_id IN VARCHAR2) IS
7086:
7087: l_org_id number(15);
7088: l_mode varchar2(1);
7089: l_customer_name_from hz_parties.party_name%type;
7090: l_customer_name_to hz_parties.party_name%type;
7091: l_customer_number_from hz_cust_accounts.account_number%type;
7092: l_customer_number_to hz_cust_accounts.account_number%type;
7093: l_cust_site_use_id number;

Line 7090: l_customer_name_to hz_parties.party_name%type;

7086:
7087: l_org_id number(15);
7088: l_mode varchar2(1);
7089: l_customer_name_from hz_parties.party_name%type;
7090: l_customer_name_to hz_parties.party_name%type;
7091: l_customer_number_from hz_cust_accounts.account_number%type;
7092: l_customer_number_to hz_cust_accounts.account_number%type;
7093: l_cust_site_use_id number;
7094: l_fin_charge_date date;

Line 7380: l_customer_name_from hz_parties.party_name%TYPE;

7376: l_worker_number NUMBER ;
7377: l_req_id NUMBER;
7378: l_rep_req_id NUMBER := 0;
7379: l_batch_name ar_interest_batches.batch_name%type;
7380: l_customer_name_from hz_parties.party_name%TYPE;
7381: l_customer_name_to hz_parties.party_name%TYPE;
7382: l_late_charge_batch VARCHAR2(100);
7383: l_fin_charge_date DATE;
7384: l_gl_date DATE;

Line 7381: l_customer_name_to hz_parties.party_name%TYPE;

7377: l_req_id NUMBER;
7378: l_rep_req_id NUMBER := 0;
7379: l_batch_name ar_interest_batches.batch_name%type;
7380: l_customer_name_from hz_parties.party_name%TYPE;
7381: l_customer_name_to hz_parties.party_name%TYPE;
7382: l_late_charge_batch VARCHAR2(100);
7383: l_fin_charge_date DATE;
7384: l_gl_date DATE;
7385: l_req_data VARCHAR2(2000);

Line 7470: from hz_parties hp,

7466: BEGIN
7467: IF p_customer_id_from IS NOT NULL THEN
7468: select hp.party_name
7469: into l_customer_name_from
7470: from hz_parties hp,
7471: hz_cust_accounts cust_acct
7472: where hp.party_id = cust_acct.party_id
7473: and cust_acct.cust_account_id = p_customer_id_from;
7474: ELSE

Line 7487: from hz_parties hp,

7483: BEGIN
7484: IF p_customer_id_to IS NOT NULL THEN
7485: select hp.party_name
7486: into l_customer_name_to
7487: from hz_parties hp,
7488: hz_cust_accounts cust_acct
7489: where hp.party_id = cust_acct.party_id
7490: and cust_acct.cust_account_id = p_customer_id_to;
7491: ELSE