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_CUST_SITE_USES

Line 340: l_late_charge_site_use_id hz_cust_site_uses.site_use_id%type;

336: FUNCTION get_late_charge_site (
337: p_customer_id IN NUMBER,
338: p_org_id IN NUMBER) RETURN NUMBER IS
339:
340: l_late_charge_site_use_id hz_cust_site_uses.site_use_id%type;
341:
342: BEGIN
343:
344: select site_uses.site_use_id

Line 347: hz_cust_site_uses site_uses

343:
344: select site_uses.site_use_id
345: into l_late_charge_site_use_id
346: from hz_cust_acct_sites acct_site,
347: hz_cust_site_uses site_uses
348: where acct_site.cust_account_id = p_customer_id
349: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
350: and site_uses.site_use_code = 'LATE_CHARGE'
351: and site_uses.org_id = p_org_id

Line 398: from hz_cust_site_uses

394: select site_use_id
395: into l_profile_class_site_use_id
396: from hz_customer_profiles
397: where site_use_id in ( select site_use_id
398: from hz_cust_site_uses
399: where cust_acct_site_id =
400: ( SELECT cust_acct_site_id
401: FROM hz_cust_site_uses
402: WHERE site_use_id = p_site_use_id)

Line 401: FROM hz_cust_site_uses

397: where site_use_id in ( select site_use_id
398: from hz_cust_site_uses
399: where cust_acct_site_id =
400: ( SELECT cust_acct_site_id
401: FROM hz_cust_site_uses
402: WHERE site_use_id = p_site_use_id)
403: and status = 'A'
404: and site_use_code in ('BILL_TO','LATE_CHARGE'));
405: return l_profile_class_site_use_id;

Line 415: from hz_cust_site_uses

411: select site_use_id
412: into l_profile_class_site_use_id
413: from hz_customer_profiles
414: where site_use_id in ( select site_use_id
415: from hz_cust_site_uses
416: where cust_acct_site_id =
417: ( SELECT cust_acct_site_id
418: FROM hz_cust_site_uses
419: WHERE site_use_id = p_site_use_id)

Line 418: FROM hz_cust_site_uses

414: where site_use_id in ( select site_use_id
415: from hz_cust_site_uses
416: where cust_acct_site_id =
417: ( SELECT cust_acct_site_id
418: FROM hz_cust_site_uses
419: WHERE site_use_id = p_site_use_id)
420: and status = 'A'
421: and site_use_code = 'BILL_TO');
422:

Line 450: from hz_cust_site_uses

446: select cust_acct_site_id,
447: site_use_code
448: into l_cust_acct_site_id,
449: l_site_use_code
450: from hz_cust_site_uses
451: where site_use_id = p_site_use_id
452: and org_id = p_org_id;
453:
454: IF l_site_use_code = 'BILL_TO' THEN

Line 461: from hz_cust_site_uses

457: BEGIN
458: /* Check if the passed site has a bill to usage */
459: select site_use_id
460: into l_bill_to_site_use_id
461: from hz_cust_site_uses
462: where cust_acct_site_id = l_cust_acct_site_id
463: and site_use_code = 'BILL_TO'
464: and org_id = p_org_id;
465:

Line 474: from hz_cust_site_uses site_use,

470: BEGIN
471: /* Get the primary bill to site */
472: select site_use.site_use_id
473: into l_bill_to_site_use_id
474: from hz_cust_site_uses site_use,
475: hz_cust_acct_sites sites
476: where sites.cust_account_id = p_customer_id
477: and sites.bill_to_flag = 'P'
478: and sites.status ='A'

Line 584: hz_cust_site_uses rsu_st,

580: rsu_bt.finchrg_receivables_trx_id),
581: rsu_st.finchrg_receivables_trx_id
582: )
583: from ra_customer_trx ctrx,
584: hz_cust_site_uses rsu_st,
585: hz_cust_site_uses rsu_bt,
586: ar_system_parameters sp
587: where ctrx.customer_trx_id = p_customer_trx_id
588: and ctrx.org_id = p_org_id

Line 585: hz_cust_site_uses rsu_bt,

581: rsu_st.finchrg_receivables_trx_id
582: )
583: from ra_customer_trx ctrx,
584: hz_cust_site_uses rsu_st,
585: hz_cust_site_uses rsu_bt,
586: ar_system_parameters sp
587: where ctrx.customer_trx_id = p_customer_trx_id
588: and ctrx.org_id = p_org_id
589: and sp.org_id = p_org_id

Line 1237: hz_cust_site_uses site_use,

1233: hz_cust_accounts cust_acct,
1234: hz_parties party,
1235: hz_customer_profiles profiles,
1236: hz_cust_profile_amts prof_amts,
1237: hz_cust_site_uses site_use,
1238: ar_system_parameters sysparam
1239: WHERE cust_acct.party_id = party.party_id
1240: '|| l_customer_name_where ||'
1241: '|| l_customer_number_where || '

Line 6424: | in hz_cust_site_uses to store the last date on which Finance Charge was computed on |

6420: | How to determine this? 11i Interest Invoice feature uses ps.last_charge_date to |
6421: | store the last date on which interest is calculated on a payment_schedule. So if this|
6422: | is populated, we can assume that Interest Invoice was created on this payment |
6423: | schedule. 11i AR Finance Charge functionality uses the field last_accrue_charge_date |
6424: | in hz_cust_site_uses to store the last date on which Finance Charge was computed on |
6425: | the invoices of a given customer site use. Such finance charges will be created as |
6426: | Adjustments and can be derived from ar_adjustments. If any of these two conditions |
6427: | are satisfied, the payment_schedule is treated as if Interest was computed on it. |
6428: | If hold_charged_invoices_flag = 'Y' then |