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.ARP_STAGED_DUNNING dependencies on HZ_CUST_PROFILE_AMTS

Line 596: ,hz_cust_profile_amts cust_cpa

592: nvl(cust_cpa.min_dunning_invoice_amount, 0 ))
593: INTO min_dun_amount
594: ,min_dun_inv_amount
595: FROM hz_customer_profiles cust_cp
596: ,hz_cust_profile_amts cust_cpa
597: ,hz_customer_profiles site_cp
598: ,hz_cust_profile_amts site_cpa
599: where CUST_CP.CUST_ACCOUNT_ID = site.customer_id
600: AND cust_cp.site_use_id IS NULL

Line 598: ,hz_cust_profile_amts site_cpa

594: ,min_dun_inv_amount
595: FROM hz_customer_profiles cust_cp
596: ,hz_cust_profile_amts cust_cpa
597: ,hz_customer_profiles site_cp
598: ,hz_cust_profile_amts site_cpa
599: where CUST_CP.CUST_ACCOUNT_ID = site.customer_id
600: AND cust_cp.site_use_id IS NULL
601: AND cust_cpa.cust_account_profile_id(+)= cust_cp.cust_account_profile_id
602: AND cust_cpa.currency_code(+) = curr_code

Line 617: ,hz_cust_profile_amts cust_cpa

613: ,nvl(cust_cpa.min_dunning_invoice_amount, 0)
614: INTO min_dun_amount
615: ,min_dun_inv_amount
616: FROM hz_customer_profiles cust_cp
617: ,hz_cust_profile_amts cust_cpa
618: WHERE cust_cp.cust_account_id = site.customer_id
619: AND cust_cp.site_use_id IS NULL
620: AND cust_cpa.cust_account_profile_id(+)
621: = cust_cp.cust_account_profile_id

Line 628: FROM hz_cust_profile_amts

624: SELECT NVL(min_dunning_amount, 0) ,
625: NVL(min_dunning_invoice_amount, 0)
626: INTO min_dun_amount,
627: min_dun_inv_amount
628: FROM hz_cust_profile_amts
629: WHERE CUST_ACCOUNT_PROFILE_ID =
630: (SELECT cust_account_profile_id
631: FROM hz_customer_profiles
632: WHERE site_use_id = arpt_sql_func_util.get_bill_id(site.site_use_id))