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 2296: (select 'Y' from JTF_TASK_REFERENCES_B

2292: or exists (select 'Y' from HZ_PARTY_SITES
2293: xx where xx.PARTY_ID = temp.party_id
2294: and (nvl(STATUS, 'A') in ('A','I'))
2295: and exists
2296: (select 'Y' from JTF_TASK_REFERENCES_B
2297: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2298: 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')))
2299:
2300: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id

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

2296: (select 'Y' from JTF_TASK_REFERENCES_B
2297: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2298: 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')))
2299:
2300: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id
2301: 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')))
2302:
2303: or exists (select 'Y' from HZ_PARTY_SITES
2304: xx where xx.PARTY_ID = temp.party_id

Line 2482: (select 'Y' from JTF_TASK_REFERENCES_B

2478: or exists (select 'Y' from HZ_PARTY_SITES
2479: xx where xx.PARTY_ID = temp.party_id
2480: and (nvl(STATUS, 'A') in ('A','I'))
2481: and exists
2482: (select 'Y' from JTF_TASK_REFERENCES_B
2483: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2484: 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')))
2485:
2486: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id

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

2482: (select 'Y' from JTF_TASK_REFERENCES_B
2483: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2484: 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')))
2485:
2486: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id
2487: 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')))
2488:
2489: or exists (select 'Y' from HZ_PARTY_SITES
2490: xx where xx.PARTY_ID = temp.party_id