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_RS_RESOURCE_EXTNS

Line 2352: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2348: (select 'Y' from HZ_ORG_CONTACTS
2349: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2350: and nvl(STATUS, 'A') in ('A','I')
2351: and exists
2352: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2353: or exists (select 'Y' from HZ_RELATIONSHIPS
2354: xx where xx.OBJECT_ID = temp.party_id
2355: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2356: AND directional_flag = 'F')

Line 2362: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2358: (select 'Y' from HZ_ORG_CONTACTS
2359: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2360: and nvl(STATUS, 'A') in ('A','I')
2361: and exists
2362: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2363: or exists (select 'Y' from HZ_RELATIONSHIPS
2364: xx where xx.PARTY_ID = temp.party_id
2365: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2366: AND directional_flag = 'F')

Line 2372: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2368: (select 'Y' from HZ_ORG_CONTACTS
2369: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2370: and nvl(STATUS, 'A') in ('A','I')
2371: and exists
2372: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2373: or exists (select 'Y' from HZ_RELATIONSHIPS
2374: xx where xx.SUBJECT_ID = temp.party_id
2375: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2376: AND directional_flag = 'F')

Line 2382: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2378: (select 'Y' from HZ_ORG_CONTACTS
2379: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2380: and nvl(STATUS, 'A') in ('A','I')
2381: and exists
2382: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2383:
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'))

Line 2409: or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID = temp.party_id

2405:
2406: or exists (select 'Y' from JTF_IH_INTERACTIONS xx where xx.PARTY_ID = temp.party_id
2407: )
2408:
2409: or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID = temp.party_id
2410: and (category IN ( 'PARTY' , 'PARTNER')))
2411:
2412: or exists (select 'Y' from HZ_PARTY_SITES
2413: xx where xx.PARTY_ID = temp.party_id

Line 2416: (select 'Y' from JTF_RS_RESOURCE_EXTNS

2412: or exists (select 'Y' from HZ_PARTY_SITES
2413: xx where xx.PARTY_ID = temp.party_id
2414: and (nvl(STATUS, 'A') in ('A','I'))
2415: and exists
2416: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2417: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2418: and category = 'PARTNER'))
2419:
2420: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id

Line 2447: (select 'Y' from JTF_RS_RESOURCE_EXTNS

2443: or exists (select 'Y' from HZ_PARTY_SITES
2444: xx where xx.PARTY_ID = temp.party_id
2445: and (nvl(STATUS, 'A') in ('A','I'))
2446: and exists
2447: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2448: yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
2449: ))
2450:
2451: or exists (select 'Y' from JTF_TTY_NAMED_ACCTS xx where xx.PARTY_ID = temp.party_id

Line 2538: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2534: (select 'Y' from HZ_ORG_CONTACTS
2535: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2536: and nvl(STATUS, 'A') in ('A','I')
2537: and exists
2538: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2539: or exists (select 'Y' from HZ_RELATIONSHIPS
2540: xx where xx.OBJECT_ID = temp.party_id
2541: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2542: AND directional_flag = 'F')

Line 2548: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2544: (select 'Y' from HZ_ORG_CONTACTS
2545: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2546: and nvl(STATUS, 'A') in ('A','I')
2547: and exists
2548: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2549: or exists (select 'Y' from HZ_RELATIONSHIPS
2550: xx where xx.PARTY_ID = temp.party_id
2551: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2552: AND directional_flag = 'F')

Line 2558: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2554: (select 'Y' from HZ_ORG_CONTACTS
2555: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2556: and nvl(STATUS, 'A') in ('A','I')
2557: and exists
2558: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2559: or exists (select 'Y' from HZ_RELATIONSHIPS
2560: xx where xx.SUBJECT_ID = temp.party_id
2561: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2562: AND directional_flag = 'F')

Line 2568: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2564: (select 'Y' from HZ_ORG_CONTACTS
2565: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2566: and nvl(STATUS, 'A') in ('A','I')
2567: and exists
2568: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2569:
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'))

Line 2595: or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID = temp.party_id

2591:
2592: or exists (select 'Y' from JTF_IH_INTERACTIONS xx where xx.PARTY_ID = temp.party_id
2593: )
2594:
2595: or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID = temp.party_id
2596: and (category IN ( 'PARTY' , 'PARTNER')))
2597:
2598: or exists (select 'Y' from HZ_PARTY_SITES
2599: xx where xx.PARTY_ID = temp.party_id

Line 2602: (select 'Y' from JTF_RS_RESOURCE_EXTNS

2598: or exists (select 'Y' from HZ_PARTY_SITES
2599: xx where xx.PARTY_ID = temp.party_id
2600: and (nvl(STATUS, 'A') in ('A','I'))
2601: and exists
2602: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2603: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2604: and category = 'PARTNER'))
2605:
2606: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id

Line 2633: (select 'Y' from JTF_RS_RESOURCE_EXTNS

2629: or exists (select 'Y' from HZ_PARTY_SITES
2630: xx where xx.PARTY_ID = temp.party_id
2631: and (nvl(STATUS, 'A') in ('A','I'))
2632: and exists
2633: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2634: yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
2635: ))
2636:
2637: or exists (select 'Y' from JTF_TTY_NAMED_ACCTS xx where xx.PARTY_ID = temp.party_id