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.ARPT_SQL_FUNC_UTIL dependencies on HZ_CUST_ACCT_RELATE

Line 1719: from hz_cust_acct_relate cr

1715: AND trx.complete_flag = 'Y'
1716: AND trx.bill_to_customer_id
1717: in (
1718: select distinct cr.cust_account_id
1719: from hz_cust_acct_relate cr
1720: where cr.related_cust_account_id = p_bill_to_customer_id
1721: AND status = 'A'
1722: union
1723: select to_number(p_bill_to_customer_id)

Line 1813: FROM hz_cust_acct_relate cr

1809: FROM so_agreements a
1810: WHERE a.customer_id IN
1811: (
1812: SELECT cr.cust_account_id
1813: FROM hz_cust_acct_relate cr
1814: WHERE cr.related_cust_account_id = p_bill_to_customer_id
1815: AND cr.status = 'A'
1816: UNION ALL
1817: SELECT to_number(p_bill_to_customer_id)