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 479: FROM hz_cust_acct_relate cr

475: AND cust_acct.status = 'A'
476: AND cust_acct.cust_account_id IN
477: (
478: SELECT cr.cust_account_id
479: FROM hz_cust_acct_relate cr
480: WHERE cr.related_cust_account_id = gt.bill_to_customer_id
481: AND cr.status = 'A'
482: AND cr.bill_to_flag ='Y'
483: UNION

Line 2449: from hz_cust_acct_relate cr

2445: and trx.customer_trx_id = gt.related_customer_trx_id
2446: and trx.bill_to_customer_id IN
2447: (
2448: select distinct cr.cust_account_id
2449: from hz_cust_acct_relate cr
2450: where cr.related_cust_account_id = gt.bill_to_customer_id
2451: and cr.status = 'A'
2452: and cr.bill_to_flag ='Y'
2453: --union

Line 2635: from hz_cust_acct_relate cr

2631: and sl.lookup_type = 'QP_AGREEMENT_TYPE'
2632: and a.customer_id = cust_acct.cust_account_id(+)
2633: and cust_acct.party_id = party.party_id(+)
2634: and a.customer_id in ( select cr.cust_account_id
2635: from hz_cust_acct_relate cr
2636: where related_cust_account_id =
2637: gt.bill_to_customer_id
2638: and cr.status = 'A'
2639: and cr.bill_to_flag='Y'