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_DATA_POINTS_PKG dependencies on HZ_HIERARCHY_NODES

Line 272: from hz_hierarchy_nodes

268: select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
269: FROM hz_cust_accounts
270: WHERE party_id in
271: ( SELECT child_id
272: from hz_hierarchy_nodes
273: where parent_object_type = 'ORGANIZATION'
274: and parent_table_name = 'HZ_PARTIES'
275: and child_object_type = 'ORGANIZATION'
276: and parent_id = p_party_id

Line 494: from hz_hierarchy_nodes

490: select to_number(cust_account_id)
491: FROM hz_cust_accounts
492: WHERE party_id in
493: ( SELECT child_id
494: from hz_hierarchy_nodes
495: where parent_object_type = ''ORGANIZATION''
496: and parent_table_name = ''HZ_PARTIES''
497: and child_object_type = ''ORGANIZATION''
498: and parent_id = :3

Line 576: from hz_hierarchy_nodes

572: select to_number(cust_account_id)
573: FROM hz_cust_accounts
574: WHERE party_id in
575: ( SELECT child_id
576: from hz_hierarchy_nodes
577: where parent_object_type = ''ORGANIZATION''
578: and parent_table_name = ''HZ_PARTIES''
579: and child_object_type = ''ORGANIZATION''
580: and parent_id = :3

Line 765: FROM hz_hierarchy_nodes

761: SELECT TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
762: FROM hz_cust_accounts
763: WHERE party_id in
764: ( SELECT child_id
765: FROM hz_hierarchy_nodes
766: WHERE parent_object_type = 'ORGANIZATION'
767: AND parent_table_name = 'HZ_PARTIES'
768: AND child_object_type = 'ORGANIZATION'
769: AND parent_id = p_party_id

Line 889: from hz_hierarchy_nodes

885: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
886: FROM hz_cust_accounts
887: WHERE party_id in
888: ( SELECT child_id
889: from hz_hierarchy_nodes
890: where parent_object_type = 'ORGANIZATION'
891: and parent_table_name = 'HZ_PARTIES'
892: and child_object_type = 'ORGANIZATION'
893: and parent_id = p_party_id

Line 922: from hz_hierarchy_nodes

918: (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
919: FROM hz_cust_accounts
920: WHERE party_id in
921: ( SELECT child_id
922: from hz_hierarchy_nodes
923: where parent_object_type = 'ORGANIZATION'
924: and parent_table_name = 'HZ_PARTIES'
925: and child_object_type = 'ORGANIZATION'
926: and parent_id = p_party_id

Line 1140: from hz_hierarchy_nodes

1136: select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
1137: FROM hz_cust_accounts
1138: WHERE party_id in
1139: ( SELECT child_id
1140: from hz_hierarchy_nodes
1141: where parent_object_type = 'ORGANIZATION'
1142: and parent_table_name = 'HZ_PARTIES'
1143: and child_object_type = 'ORGANIZATION'
1144: and parent_id = p_party_id

Line 4872: from hz_hierarchy_nodes

4868: WHERE CUST_ACCOUNT_ID in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
4869: FROM hz_cust_accounts
4870: WHERE party_id in
4871: ( SELECT child_id
4872: from hz_hierarchy_nodes
4873: where parent_object_type = 'ORGANIZATION'
4874: and parent_table_name = 'HZ_PARTIES'
4875: and child_object_type = 'ORGANIZATION'
4876: and parent_id = p_party_id

Line 5244: from hz_hierarchy_nodes

5240: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
5241: FROM hz_cust_accounts
5242: WHERE party_id in
5243: ( SELECT child_id
5244: from hz_hierarchy_nodes
5245: where parent_object_type = 'ORGANIZATION'
5246: and parent_table_name = 'HZ_PARTIES'
5247: and child_object_type = 'ORGANIZATION'
5248: and parent_id = p_party_id

Line 5498: from hz_hierarchy_nodes

5494: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
5495: FROM hz_cust_accounts
5496: WHERE party_id in
5497: ( SELECT child_id
5498: from hz_hierarchy_nodes
5499: where parent_object_type = 'ORGANIZATION'
5500: and parent_table_name = 'HZ_PARTIES'
5501: and child_object_type = 'ORGANIZATION'
5502: and parent_id = p_party_id

Line 5602: from hz_hierarchy_nodes

5598: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
5599: FROM hz_cust_accounts
5600: WHERE party_id in
5601: ( SELECT child_id
5602: from hz_hierarchy_nodes
5603: where parent_object_type = 'ORGANIZATION'
5604: and parent_table_name = 'HZ_PARTIES'
5605: and child_object_type = 'ORGANIZATION'
5606: and parent_id = p_party_id

Line 6286: from hz_hierarchy_nodes

6282: WHERE CUST_ACCOUNT_ID in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
6283: FROM hz_cust_accounts
6284: WHERE party_id in
6285: ( SELECT child_id
6286: from hz_hierarchy_nodes
6287: where parent_object_type = 'ORGANIZATION'
6288: and parent_table_name = 'HZ_PARTIES'
6289: and child_object_type = 'ORGANIZATION'
6290: and parent_id = p_party_id