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 2429: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

2425: (select 'Y' from HZ_ORG_CONTACTS
2426: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2427: and nvl(STATUS, 'A') in ('A','I')
2428: and exists
2429: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2430: or exists (select 'Y' from HZ_RELATIONSHIPS
2431: xx where xx.OBJECT_ID = temp.party_id
2432: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2433: AND directional_flag = 'F')

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

2435: (select 'Y' from HZ_ORG_CONTACTS
2436: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2437: and nvl(STATUS, 'A') in ('A','I')
2438: and exists
2439: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2440: or exists (select 'Y' from HZ_RELATIONSHIPS
2441: xx where xx.PARTY_ID = temp.party_id
2442: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2443: AND directional_flag = 'F')

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

2445: (select 'Y' from HZ_ORG_CONTACTS
2446: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2447: and nvl(STATUS, 'A') in ('A','I')
2448: and exists
2449: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2450: or exists (select 'Y' from HZ_RELATIONSHIPS
2451: xx where xx.SUBJECT_ID = temp.party_id
2452: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2453: AND directional_flag = 'F')

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

2455: (select 'Y' from HZ_ORG_CONTACTS
2456: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2457: and nvl(STATUS, 'A') in ('A','I')
2458: and exists
2459: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2460:
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'))

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

2482:
2483: or exists (select 'Y' from JTF_IH_INTERACTIONS xx where xx.PARTY_ID = temp.party_id
2484: )
2485:
2486: or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID = temp.party_id
2487: and (category IN ( 'PARTY' , 'PARTNER')))
2488:
2489: or exists (select 'Y' from HZ_PARTY_SITES
2490: xx where xx.PARTY_ID = temp.party_id

Line 2493: (select 'Y' from JTF_RS_RESOURCE_EXTNS

2489: or exists (select 'Y' from HZ_PARTY_SITES
2490: xx where xx.PARTY_ID = temp.party_id
2491: and (nvl(STATUS, 'A') in ('A','I'))
2492: and exists
2493: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2494: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2495: and category = 'PARTNER'))
2496:
2497: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id

Line 2524: (select 'Y' from JTF_RS_RESOURCE_EXTNS

2520: or exists (select 'Y' from HZ_PARTY_SITES
2521: xx where xx.PARTY_ID = temp.party_id
2522: and (nvl(STATUS, 'A') in ('A','I'))
2523: and exists
2524: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2525: yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
2526: ))
2527:
2528: or exists (select 'Y' from HZ_PARTY_SITES

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

2619: (select 'Y' from HZ_ORG_CONTACTS
2620: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2621: and nvl(STATUS, 'A') in ('A','I')
2622: and exists
2623: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2624: or exists (select 'Y' from HZ_RELATIONSHIPS
2625: xx where xx.OBJECT_ID = temp.party_id
2626: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2627: AND directional_flag = 'F')

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

2629: (select 'Y' from HZ_ORG_CONTACTS
2630: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2631: and nvl(STATUS, 'A') in ('A','I')
2632: and exists
2633: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2634: or exists (select 'Y' from HZ_RELATIONSHIPS
2635: xx where xx.PARTY_ID = temp.party_id
2636: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2637: AND directional_flag = 'F')

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

2639: (select 'Y' from HZ_ORG_CONTACTS
2640: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2641: and nvl(STATUS, 'A') in ('A','I')
2642: and exists
2643: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2644: or exists (select 'Y' from HZ_RELATIONSHIPS
2645: xx where xx.SUBJECT_ID = temp.party_id
2646: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2647: AND directional_flag = 'F')

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

2649: (select 'Y' from HZ_ORG_CONTACTS
2650: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2651: and nvl(STATUS, 'A') in ('A','I')
2652: and exists
2653: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2654:
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'))

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

2676:
2677: or exists (select 'Y' from JTF_IH_INTERACTIONS xx where xx.PARTY_ID = temp.party_id
2678: )
2679:
2680: or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID = temp.party_id
2681: and (category IN ( 'PARTY' , 'PARTNER')))
2682:
2683: or exists (select 'Y' from HZ_PARTY_SITES
2684: xx where xx.PARTY_ID = temp.party_id

Line 2687: (select 'Y' from JTF_RS_RESOURCE_EXTNS

2683: or exists (select 'Y' from HZ_PARTY_SITES
2684: xx where xx.PARTY_ID = temp.party_id
2685: and (nvl(STATUS, 'A') in ('A','I'))
2686: and exists
2687: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2688: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2689: and category = 'PARTNER'))
2690:
2691: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id

Line 2718: (select 'Y' from JTF_RS_RESOURCE_EXTNS

2714: or exists (select 'Y' from HZ_PARTY_SITES
2715: xx where xx.PARTY_ID = temp.party_id
2716: and (nvl(STATUS, 'A') in ('A','I'))
2717: and exists
2718: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2719: yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
2720: ))
2721:
2722: or exists (select 'Y' from HZ_PARTY_SITES