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 2465: (select 'Y' from JTF_NOTES_B

2461: or exists (select 'Y' from HZ_PARTY_SITES
2462: xx where xx.PARTY_ID = temp.party_id
2463: and (nvl(STATUS, 'A') in ('A','I'))
2464: and exists
2465: (select 'Y' from JTF_NOTES_B
2466: yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
2467: 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')))
2468:
2469: or exists (select 'Y' from HZ_PARTY_SITES

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

2473: (select 'Y' from JTF_NOTE_CONTEXTS
2474: yy where yy.NOTE_CONTEXT_TYPE_ID=xx.PARTY_SITE_ID
2475: 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')))
2476:
2477: or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID = temp.party_id
2478: 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' )))
2479:
2480: or exists (select 'Y' from JTF_NOTE_CONTEXTS xx where xx.NOTE_CONTEXT_TYPE_ID = temp.party_id
2481: 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 2659: (select 'Y' from JTF_NOTES_B

2655: or exists (select 'Y' from HZ_PARTY_SITES
2656: xx where xx.PARTY_ID = temp.party_id
2657: and (nvl(STATUS, 'A') in ('A','I'))
2658: and exists
2659: (select 'Y' from JTF_NOTES_B
2660: yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
2661: 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')))
2662:
2663: or exists (select 'Y' from HZ_PARTY_SITES

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

2667: (select 'Y' from JTF_NOTE_CONTEXTS
2668: yy where yy.NOTE_CONTEXT_TYPE_ID=xx.PARTY_SITE_ID
2669: 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')))
2670:
2671: or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID = temp.party_id
2672: 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' )))
2673:
2674: or exists (select 'Y' from JTF_NOTE_CONTEXTS xx where xx.NOTE_CONTEXT_TYPE_ID = temp.party_id
2675: 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')))