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_NOTES_B

Line 2388: (select 'Y' from JTF_NOTES_B

2384: or exists (select 'Y' from HZ_PARTY_SITES
2385: xx where xx.PARTY_ID = temp.party_id
2386: and (nvl(STATUS, 'A') in ('A','I'))
2387: and exists
2388: (select 'Y' from JTF_NOTES_B
2389: yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
2390: and source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2391:
2392: or exists (select 'Y' from HZ_PARTY_SITES

Line 2400: or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID = temp.party_id

2396: (select 'Y' from JTF_NOTE_CONTEXTS
2397: yy where yy.NOTE_CONTEXT_TYPE_ID=xx.PARTY_SITE_ID
2398: and NOTE_CONTEXT_TYPE IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2399:
2400: or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID = temp.party_id
2401: and (source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES' )))
2402:
2403: or exists (select 'Y' from JTF_NOTE_CONTEXTS xx where xx.NOTE_CONTEXT_TYPE_ID = temp.party_id
2404: and (NOTE_CONTEXT_TYPE IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES')))

Line 2574: (select 'Y' from JTF_NOTES_B

2570: or exists (select 'Y' from HZ_PARTY_SITES
2571: xx where xx.PARTY_ID = temp.party_id
2572: and (nvl(STATUS, 'A') in ('A','I'))
2573: and exists
2574: (select 'Y' from JTF_NOTES_B
2575: yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
2576: and source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2577:
2578: or exists (select 'Y' from HZ_PARTY_SITES

Line 2586: or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID = temp.party_id

2582: (select 'Y' from JTF_NOTE_CONTEXTS
2583: yy where yy.NOTE_CONTEXT_TYPE_ID=xx.PARTY_SITE_ID
2584: and NOTE_CONTEXT_TYPE IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2585:
2586: or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID = temp.party_id
2587: and (source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES' )))
2588:
2589: or exists (select 'Y' from JTF_NOTE_CONTEXTS xx where xx.NOTE_CONTEXT_TYPE_ID = temp.party_id
2590: and (NOTE_CONTEXT_TYPE IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES')))