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.HZ_PURGE_GEN dependencies on JTF_TASK_REFERENCES_B

Line 2373: (select 'Y' from JTF_TASK_REFERENCES_B

2369: or exists (select 'Y' from HZ_PARTY_SITES
2370: xx where xx.PARTY_ID = temp.party_id
2371: and (nvl(STATUS, 'A') in ('A','I'))
2372: and exists
2373: (select 'Y' from JTF_TASK_REFERENCES_B
2374: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2375: and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))
2376:
2377: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id

Line 2377: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id

2373: (select 'Y' from JTF_TASK_REFERENCES_B
2374: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2375: and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))
2376:
2377: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id
2378: and (OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))
2379:
2380: or exists (select 'Y' from HZ_PARTY_SITES
2381: xx where xx.PARTY_ID = temp.party_id

Line 2567: (select 'Y' from JTF_TASK_REFERENCES_B

2563: or exists (select 'Y' from HZ_PARTY_SITES
2564: xx where xx.PARTY_ID = temp.party_id
2565: and (nvl(STATUS, 'A') in ('A','I'))
2566: and exists
2567: (select 'Y' from JTF_TASK_REFERENCES_B
2568: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2569: and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))
2570:
2571: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id

Line 2571: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id

2567: (select 'Y' from JTF_TASK_REFERENCES_B
2568: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2569: and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))
2570:
2571: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id
2572: and (OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))
2573:
2574: or exists (select 'Y' from HZ_PARTY_SITES
2575: xx where xx.PARTY_ID = temp.party_id