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_AUDITS_B

Line 2354: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_CUSTOMER_ID = temp.party_id

2350:
2351: or exists (select 'Y' from JTF_TASKS_B xx where xx.SOURCE_OBJECT_ID = temp.party_id
2352: and (SOURCE_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')))
2353:
2354: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_CUSTOMER_ID = temp.party_id
2355: )
2356:
2357: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID = temp.party_id
2358: )

Line 2357: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID = temp.party_id

2353:
2354: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_CUSTOMER_ID = temp.party_id
2355: )
2356:
2357: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID = temp.party_id
2358: )
2359:
2360: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID = temp.party_id
2361: and (NEW_SOURCE_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')))

Line 2360: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID = temp.party_id

2356:
2357: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID = temp.party_id
2358: )
2359:
2360: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID = temp.party_id
2361: and (NEW_SOURCE_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')))
2362:
2363: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_SOURCE_OBJECT_ID = temp.party_id
2364: and (OLD_SOURCE_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')))

Line 2363: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_SOURCE_OBJECT_ID = temp.party_id

2359:
2360: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID = temp.party_id
2361: and (NEW_SOURCE_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')))
2362:
2363: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_SOURCE_OBJECT_ID = temp.party_id
2364: and (OLD_SOURCE_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')))
2365:
2366: or exists (select 'Y' from JTF_TASK_CONTACTS xx where xx.CONTACT_ID = temp.party_id
2367: and (CONTACT_TYPE_CODE = 'CUST'))

Line 2392: (select 'Y' from JTF_TASK_AUDITS_B

2388: or exists (select 'Y' from HZ_PARTY_SITES
2389: xx where xx.PARTY_ID = temp.party_id
2390: and (nvl(STATUS, 'A') in ('A','I'))
2391: and exists
2392: (select 'Y' from JTF_TASK_AUDITS_B
2393: yy where yy.NEW_ADDRESS_ID=xx.PARTY_SITE_ID
2394: ))
2395:
2396: or exists (select 'Y' from HZ_PARTY_SITES

Line 2400: (select 'Y' from JTF_TASK_AUDITS_B

2396: or exists (select 'Y' from HZ_PARTY_SITES
2397: xx where xx.PARTY_ID = temp.party_id
2398: and (nvl(STATUS, 'A') in ('A','I'))
2399: and exists
2400: (select 'Y' from JTF_TASK_AUDITS_B
2401: yy where yy.OLD_ADDRESS_ID=xx.PARTY_SITE_ID
2402: ))
2403:
2404: or exists (select 'Y' from HZ_CONTACT_POINTS

Line 2548: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_CUSTOMER_ID = temp.party_id

2544:
2545: or exists (select 'Y' from JTF_TASKS_B xx where xx.SOURCE_OBJECT_ID = temp.party_id
2546: and (SOURCE_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')))
2547:
2548: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_CUSTOMER_ID = temp.party_id
2549: )
2550:
2551: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID = temp.party_id
2552: )

Line 2551: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID = temp.party_id

2547:
2548: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_CUSTOMER_ID = temp.party_id
2549: )
2550:
2551: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID = temp.party_id
2552: )
2553:
2554: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID = temp.party_id
2555: and (NEW_SOURCE_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')))

Line 2554: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID = temp.party_id

2550:
2551: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID = temp.party_id
2552: )
2553:
2554: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID = temp.party_id
2555: and (NEW_SOURCE_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')))
2556:
2557: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_SOURCE_OBJECT_ID = temp.party_id
2558: and (OLD_SOURCE_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')))

Line 2557: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_SOURCE_OBJECT_ID = temp.party_id

2553:
2554: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID = temp.party_id
2555: and (NEW_SOURCE_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')))
2556:
2557: or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_SOURCE_OBJECT_ID = temp.party_id
2558: and (OLD_SOURCE_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')))
2559:
2560: or exists (select 'Y' from JTF_TASK_CONTACTS xx where xx.CONTACT_ID = temp.party_id
2561: and (CONTACT_TYPE_CODE = 'CUST'))

Line 2586: (select 'Y' from JTF_TASK_AUDITS_B

2582: or exists (select 'Y' from HZ_PARTY_SITES
2583: xx where xx.PARTY_ID = temp.party_id
2584: and (nvl(STATUS, 'A') in ('A','I'))
2585: and exists
2586: (select 'Y' from JTF_TASK_AUDITS_B
2587: yy where yy.NEW_ADDRESS_ID=xx.PARTY_SITE_ID
2588: ))
2589:
2590: or exists (select 'Y' from HZ_PARTY_SITES

Line 2594: (select 'Y' from JTF_TASK_AUDITS_B

2590: or exists (select 'Y' from HZ_PARTY_SITES
2591: xx where xx.PARTY_ID = temp.party_id
2592: and (nvl(STATUS, 'A') in ('A','I'))
2593: and exists
2594: (select 'Y' from JTF_TASK_AUDITS_B
2595: yy where yy.OLD_ADDRESS_ID=xx.PARTY_SITE_ID
2596: ))
2597:
2598: or exists (select 'Y' from HZ_CONTACT_POINTS