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_HIERARCHY_NODES

Line 219: from hz_hierarchy_nodes

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'
221: and parent_table_name = 'HZ_PARTIES'
222: and child_object_type = 'ORGANIZATION'
223: and parent_id = p_party_id

Line 362: from hz_hierarchy_nodes

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'
364: and parent_table_name = 'HZ_PARTIES'
365: and child_object_type = 'ORGANIZATION'
366: and parent_id = p_party_id

Line 486: from hz_hierarchy_nodes

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'
488: and parent_table_name = 'HZ_PARTIES'
489: and child_object_type = 'ORGANIZATION'
490: and parent_id = p_party_id

Line 629: from hz_hierarchy_nodes

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'
631: and parent_table_name = 'HZ_PARTIES'
632: and child_object_type = 'ORGANIZATION'
633: and parent_id = p_party_id