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

Line 1627: hz_customer_profiles cp1,

1623: FROM ra_terms t_su,
1624: ra_terms t_cp1,
1625: ra_terms t_cp2,
1626: ra_terms_lines tl,
1627: hz_customer_profiles cp1,
1628: hz_customer_profiles cp2,
1629: hz_cust_site_uses su
1630: WHERE p_customer_id = cp1.cust_account_id(+)
1631: AND su.site_use_id = p_site_use_id

Line 1628: hz_customer_profiles cp2,

1624: ra_terms t_cp1,
1625: ra_terms t_cp2,
1626: ra_terms_lines tl,
1627: hz_customer_profiles cp1,
1628: hz_customer_profiles cp2,
1629: hz_cust_site_uses su
1630: WHERE p_customer_id = cp1.cust_account_id(+)
1631: AND su.site_use_id = p_site_use_id
1632: AND cp2.cust_account_id = p_customer_id

Line 1813: l_override_terms hz_customer_profiles.override_terms%type;

1809: p_commitments_exist_flag OUT NOCOPY varchar2,
1810: p_agreements_exist_flag OUT NOCOPY varchar2)
1811: IS
1812:
1813: l_override_terms hz_customer_profiles.override_terms%type;
1814: l_commitments_exist_flag varchar2(1);
1815: l_agreements_exist_flag varchar2(1);
1816:
1817: BEGIN