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_AUTOAPPLY_API dependencies on HZ_CUSTOMER_PROFILES

Line 4576: hz_customer_profiles cust

4572:
4573: SELECT NVL(NVL(site.discount_terms, cust.discount_terms),'Y')
4574: INTO l_allow_discount
4575: FROM
4576: hz_customer_profiles cust
4577: , hz_customer_profiles site
4578: WHERE
4579: cust.cust_account_id = l_customer_id
4580: AND cust.site_use_id IS NULL

Line 4577: , hz_customer_profiles site

4573: SELECT NVL(NVL(site.discount_terms, cust.discount_terms),'Y')
4574: INTO l_allow_discount
4575: FROM
4576: hz_customer_profiles cust
4577: , hz_customer_profiles site
4578: WHERE
4579: cust.cust_account_id = l_customer_id
4580: AND cust.site_use_id IS NULL
4581: AND site.cust_account_id (+) = cust.cust_account_id

Line 4587: hz_customer_profiles cust

4583:
4584: SELECT NVL(NVL(site.discount_grace_days, cust.discount_grace_days),0)
4585: INTO l_grace_days
4586: FROM
4587: hz_customer_profiles cust
4588: , hz_customer_profiles site
4589: , hz_cust_accounts cust_acct
4590: WHERE
4591: cust_acct.cust_account_id = l_customer_id

Line 4588: , hz_customer_profiles site

4584: SELECT NVL(NVL(site.discount_grace_days, cust.discount_grace_days),0)
4585: INTO l_grace_days
4586: FROM
4587: hz_customer_profiles cust
4588: , hz_customer_profiles site
4589: , hz_cust_accounts cust_acct
4590: WHERE
4591: cust_acct.cust_account_id = l_customer_id
4592: AND cust.cust_account_id = cust_acct.cust_account_id