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_NOTE_CONTEXTS

Line 2473: (select 'Y' from JTF_NOTE_CONTEXTS

2469: or exists (select 'Y' from HZ_PARTY_SITES
2470: xx where xx.PARTY_ID = temp.party_id
2471: and (nvl(STATUS, 'A') in ('A','I'))
2472: and exists
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

Line 2480: or exists (select 'Y' from JTF_NOTE_CONTEXTS xx where xx.NOTE_CONTEXT_TYPE_ID = temp.party_id

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')))
2482:
2483: or exists (select 'Y' from JTF_IH_INTERACTIONS xx where xx.PARTY_ID = temp.party_id
2484: )

Line 2667: (select 'Y' from JTF_NOTE_CONTEXTS

2663: or exists (select 'Y' from HZ_PARTY_SITES
2664: xx where xx.PARTY_ID = temp.party_id
2665: and (nvl(STATUS, 'A') in ('A','I'))
2666: and exists
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

Line 2674: or exists (select 'Y' from JTF_NOTE_CONTEXTS xx where xx.NOTE_CONTEXT_TYPE_ID = temp.party_id

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')))
2676:
2677: or exists (select 'Y' from JTF_IH_INTERACTIONS xx where xx.PARTY_ID = temp.party_id
2678: )