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 1629: from hz_cust_acct_relate cr

1625: AND trx.complete_flag = 'Y'
1626: AND trx.bill_to_customer_id
1627: in (
1628: select distinct cr.cust_account_id
1629: from hz_cust_acct_relate cr
1630: where cr.related_cust_account_id = p_bill_to_customer_id
1631: AND status = 'A'
1632: union
1633: select to_number(p_bill_to_customer_id)

Line 1723: FROM hz_cust_acct_relate cr

1719: FROM so_agreements a
1720: WHERE a.customer_id IN
1721: (
1722: SELECT cr.cust_account_id
1723: FROM hz_cust_acct_relate cr
1724: WHERE cr.related_cust_account_id = p_bill_to_customer_id
1725: AND cr.status = 'A'
1726: UNION ALL
1727: SELECT to_number(p_bill_to_customer_id)