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

Line 486: FROM hz_cust_acct_relate cr

482: AND cust_acct.status = 'A'
483: AND cust_acct.cust_account_id IN
484: (
485: SELECT cr.cust_account_id
486: FROM hz_cust_acct_relate cr
487: WHERE cr.related_cust_account_id = gt.bill_to_customer_id
488: AND cr.status = 'A'
489: AND cr.bill_to_flag ='Y'
490: UNION

Line 2526: from hz_cust_acct_relate cr

2522: and trx.customer_trx_id = gt.related_customer_trx_id
2523: and trx.bill_to_customer_id IN
2524: (
2525: select distinct cr.cust_account_id
2526: from hz_cust_acct_relate cr
2527: where cr.related_cust_account_id = gt.bill_to_customer_id
2528: and cr.status = 'A'
2529: and cr.bill_to_flag ='Y'
2530: --union

Line 2712: from hz_cust_acct_relate cr

2708: and sl.lookup_type = 'QP_AGREEMENT_TYPE'
2709: and a.customer_id = cust_acct.cust_account_id(+)
2710: and cust_acct.party_id = party.party_id(+)
2711: and a.customer_id in ( select cr.cust_account_id
2712: from hz_cust_acct_relate cr
2713: where related_cust_account_id =
2714: gt.bill_to_customer_id
2715: and cr.status = 'A'
2716: and cr.bill_to_flag='Y'