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_CMGT_AGING dependencies on HZ_CUST_ACCOUNTS

Line 216: FROM hz_cust_accounts

212: AND nvl(sign(ps.cons_inv_id),0) = decode(p_source,'CONS_BILL',1,0) --apandit BFB changes
213: AND trx_date <= l_as_of_date
214: AND actual_date_closed > l_as_of_date
215: and ps.customer_id in (select cust_account_id
216: FROM hz_cust_accounts
217: WHERE party_id in
218: ( SELECT child_id
219: from hz_hierarchy_nodes
220: where parent_object_type = 'ORGANIZATION'

Line 359: FROM hz_cust_accounts

355: AND ps.trx_date <= l_as_of_date
356: AND ps.actual_date_closed > l_as_of_date
357: AND NVL(ra.confirmed_flag,'Y') = 'Y'
358: and ps.customer_id in (select cust_account_id
359: FROM hz_cust_accounts
360: WHERE party_id in
361: ( SELECT child_id
362: from hz_hierarchy_nodes
363: where parent_object_type = 'ORGANIZATION'

Line 483: FROM hz_cust_accounts

479: AND ps.trx_date <= l_as_of_date
480: AND ps.actual_date_closed > l_as_of_date
481: AND adj.status = 'A'
482: and ps.customer_id in (select cust_account_id
483: FROM hz_cust_accounts
484: WHERE party_id in
485: ( SELECT child_id
486: from hz_hierarchy_nodes
487: where parent_object_type = 'ORGANIZATION'

Line 626: FROM hz_cust_accounts

622: AND ps.trx_date <= l_as_of_date
623: AND ps.actual_date_closed > l_as_of_date
624: AND NVL(ra.confirmed_flag,'Y') = 'Y'
625: and ps.customer_id in (select cust_account_id
626: FROM hz_cust_accounts
627: WHERE party_id in
628: ( SELECT child_id
629: from hz_hierarchy_nodes
630: where parent_object_type = 'ORGANIZATION'