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 734: l_late_charge_site_use_id hz_cust_site_uses.site_use_id%type;

730: FUNCTION get_late_charge_site (
731: p_customer_id IN NUMBER,
732: p_org_id IN NUMBER) RETURN NUMBER IS
733:
734: l_late_charge_site_use_id hz_cust_site_uses.site_use_id%type;
735:
736: BEGIN
737:
738: select site_uses.site_use_id

Line 741: hz_cust_site_uses site_uses

737:
738: select site_uses.site_use_id
739: into l_late_charge_site_use_id
740: from hz_cust_acct_sites acct_site,
741: hz_cust_site_uses site_uses
742: where acct_site.cust_account_id = p_customer_id
743: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
744: and site_uses.site_use_code = 'LATE_CHARGE'
745: and site_uses.org_id = p_org_id

Line 792: from hz_cust_site_uses

788: select site_use_id
789: into l_profile_class_site_use_id
790: from hz_customer_profiles
791: where site_use_id in ( select site_use_id
792: from hz_cust_site_uses
793: where cust_acct_site_id =
794: ( SELECT cust_acct_site_id
795: FROM hz_cust_site_uses
796: WHERE site_use_id = p_site_use_id)

Line 795: FROM hz_cust_site_uses

791: where site_use_id in ( select site_use_id
792: from hz_cust_site_uses
793: where cust_acct_site_id =
794: ( SELECT cust_acct_site_id
795: FROM hz_cust_site_uses
796: WHERE site_use_id = p_site_use_id)
797: and status = 'A'
798: and site_use_code in ('BILL_TO','LATE_CHARGE'));
799: return l_profile_class_site_use_id;

Line 809: from hz_cust_site_uses

805: select site_use_id
806: into l_profile_class_site_use_id
807: from hz_customer_profiles
808: where site_use_id in ( select site_use_id
809: from hz_cust_site_uses
810: where cust_acct_site_id =
811: ( SELECT cust_acct_site_id
812: FROM hz_cust_site_uses
813: WHERE site_use_id = p_site_use_id)

Line 812: FROM hz_cust_site_uses

808: where site_use_id in ( select site_use_id
809: from hz_cust_site_uses
810: where cust_acct_site_id =
811: ( SELECT cust_acct_site_id
812: FROM hz_cust_site_uses
813: WHERE site_use_id = p_site_use_id)
814: and status = 'A'
815: and site_use_code = 'BILL_TO');
816:

Line 844: from hz_cust_site_uses

840: select cust_acct_site_id,
841: site_use_code
842: into l_cust_acct_site_id,
843: l_site_use_code
844: from hz_cust_site_uses
845: where site_use_id = p_site_use_id
846: and org_id = p_org_id;
847:
848: IF l_site_use_code = 'BILL_TO' THEN

Line 855: from hz_cust_site_uses

851: BEGIN
852: /* Check if the passed site has a bill to usage */
853: select site_use_id
854: into l_bill_to_site_use_id
855: from hz_cust_site_uses
856: where cust_acct_site_id = l_cust_acct_site_id
857: and site_use_code = 'BILL_TO'
858: and org_id = p_org_id;
859:

Line 868: from hz_cust_site_uses site_use,

864: BEGIN
865: /* Get the primary bill to site */
866: select site_use.site_use_id
867: into l_bill_to_site_use_id
868: from hz_cust_site_uses site_use,
869: hz_cust_acct_sites sites
870: where sites.cust_account_id = p_customer_id
871: and sites.bill_to_flag = 'P'
872: and sites.status ='A'

Line 978: hz_cust_site_uses rsu_st,

974: rsu_bt.finchrg_receivables_trx_id),
975: rsu_st.finchrg_receivables_trx_id
976: )
977: from ra_customer_trx ctrx,
978: hz_cust_site_uses rsu_st,
979: hz_cust_site_uses rsu_bt,
980: ar_system_parameters sp
981: where ctrx.customer_trx_id = p_customer_trx_id
982: and ctrx.org_id = p_org_id

Line 979: hz_cust_site_uses rsu_bt,

975: rsu_st.finchrg_receivables_trx_id
976: )
977: from ra_customer_trx ctrx,
978: hz_cust_site_uses rsu_st,
979: hz_cust_site_uses rsu_bt,
980: ar_system_parameters sp
981: where ctrx.customer_trx_id = p_customer_trx_id
982: and ctrx.org_id = p_org_id
983: and sp.org_id = p_org_id

Line 1628: hz_cust_site_uses site_use,

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
1630: WHERE cust_acct.party_id = party.party_id
1631: '|| l_customer_name_where ||'
1632: '|| l_customer_number_where || '

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

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