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 HZ_PARTY_SITE_USES

Line 905: (select 'Y' from HZ_PARTY_SITE_USES

901: or exists (select 'Y' from HZ_PARTY_SITES
902: xx where xx.PARTY_ID = temp.party_id
903: and (nvl(STATUS, 'A') in ('A','I'))
904: and exists
905: (select 'Y' from HZ_PARTY_SITE_USES
906: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
907: and nvl(STATUS, 'A') in ('A','I')
908: and exists
909: (select 'Y' from OKC_RULES_B zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_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 = 'OKX_P_SITE_USE'))))

Line 915: (select 'Y' from HZ_PARTY_SITE_USES

911: or exists (select 'Y' from HZ_PARTY_SITES
912: xx where xx.PARTY_ID = temp.party_id
913: and (nvl(STATUS, 'A') in ('A','I'))
914: and exists
915: (select 'Y' from HZ_PARTY_SITE_USES
916: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
917: and nvl(STATUS, 'A') in ('A','I')
918: and exists
919: (select 'Y' from OKC_RULES_B zz where zz.OBJECT2_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object2_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 = 'OKX_P_SITE_USE'))))

Line 925: (select 'Y' from HZ_PARTY_SITE_USES

921: or exists (select 'Y' from HZ_PARTY_SITES
922: xx where xx.PARTY_ID = temp.party_id
923: and (nvl(STATUS, 'A') in ('A','I'))
924: and exists
925: (select 'Y' from HZ_PARTY_SITE_USES
926: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
927: and nvl(STATUS, 'A') in ('A','I')
928: and exists
929: (select 'Y' from OKC_RULES_B zz where zz.OBJECT3_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object3_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 = 'OKX_P_SITE_USE'))))

Line 946: (select 'Y' from HZ_PARTY_SITE_USES

942: or exists (select 'Y' from HZ_PARTY_SITES
943: xx where xx.PARTY_ID = temp.party_id
944: and (nvl(STATUS, 'A') in ('A','I'))
945: and exists
946: (select 'Y' from HZ_PARTY_SITE_USES
947: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
948: and nvl(STATUS, 'A') in ('A','I')
949: and exists
950: (select 'Y' from OKC_K_ITEMS zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_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 = 'OKX_P_SITE_USE'))));

Line 998: (select 'Y' from HZ_PARTY_SITE_USES

994: or exists (select 'Y' from HZ_PARTY_SITES
995: xx where xx.PARTY_ID = temp.party_id
996: and (nvl(STATUS, 'A') in ('A','I'))
997: and exists
998: (select 'Y' from HZ_PARTY_SITE_USES
999: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1000: and nvl(STATUS, 'A') in ('A','I')
1001: and exists
1002: (select 'Y' from OKC_RULES_B zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_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 = 'OKX_P_SITE_USE'))))

Line 1008: (select 'Y' from HZ_PARTY_SITE_USES

1004: or exists (select 'Y' from HZ_PARTY_SITES
1005: xx where xx.PARTY_ID = temp.party_id
1006: and (nvl(STATUS, 'A') in ('A','I'))
1007: and exists
1008: (select 'Y' from HZ_PARTY_SITE_USES
1009: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1010: and nvl(STATUS, 'A') in ('A','I')
1011: and exists
1012: (select 'Y' from OKC_RULES_B zz where zz.OBJECT2_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object2_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 = 'OKX_P_SITE_USE'))))

Line 1018: (select 'Y' from HZ_PARTY_SITE_USES

1014: or exists (select 'Y' from HZ_PARTY_SITES
1015: xx where xx.PARTY_ID = temp.party_id
1016: and (nvl(STATUS, 'A') in ('A','I'))
1017: and exists
1018: (select 'Y' from HZ_PARTY_SITE_USES
1019: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1020: and nvl(STATUS, 'A') in ('A','I')
1021: and exists
1022: (select 'Y' from OKC_RULES_B zz where zz.OBJECT3_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object3_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 = 'OKX_P_SITE_USE'))))

Line 1039: (select 'Y' from HZ_PARTY_SITE_USES

1035: or exists (select 'Y' from HZ_PARTY_SITES
1036: xx where xx.PARTY_ID = temp.party_id
1037: and (nvl(STATUS, 'A') in ('A','I'))
1038: and exists
1039: (select 'Y' from HZ_PARTY_SITE_USES
1040: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1041: and nvl(STATUS, 'A') in ('A','I')
1042: and exists
1043: (select 'Y' from OKC_K_ITEMS zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_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 = 'OKX_P_SITE_USE'))));

Line 1985: (select 'Y' from HZ_PARTY_SITE_USES

1981: exists (select 'Y' from HZ_PARTY_SITES
1982: xx where xx.PARTY_ID = temp.party_id
1983: and (nvl(STATUS, 'A') in ('A','I'))
1984: and exists
1985: (select 'Y' from HZ_PARTY_SITE_USES
1986: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1987: and nvl(STATUS, 'A') in ('A','I')
1988: and exists
1989: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

Line 1995: (select 'Y' from HZ_PARTY_SITE_USES

1991: or exists (select 'Y' from HZ_PARTY_SITES
1992: xx where xx.PARTY_ID = temp.party_id
1993: and (nvl(STATUS, 'A') in ('A','I'))
1994: and exists
1995: (select 'Y' from HZ_PARTY_SITE_USES
1996: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1997: and nvl(STATUS, 'A') in ('A','I')
1998: and exists
1999: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

Line 2034: (select 'Y' from HZ_PARTY_SITE_USES

2030: exists (select 'Y' from HZ_PARTY_SITES
2031: xx where xx.PARTY_ID = temp.party_id
2032: and (nvl(STATUS, 'A') in ('A','I'))
2033: and exists
2034: (select 'Y' from HZ_PARTY_SITE_USES
2035: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2036: and nvl(STATUS, 'A') in ('A','I')
2037: and exists
2038: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

Line 2044: (select 'Y' from HZ_PARTY_SITE_USES

2040: or exists (select 'Y' from HZ_PARTY_SITES
2041: xx where xx.PARTY_ID = temp.party_id
2042: and (nvl(STATUS, 'A') in ('A','I'))
2043: and exists
2044: (select 'Y' from HZ_PARTY_SITE_USES
2045: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2046: and nvl(STATUS, 'A') in ('A','I')
2047: and exists
2048: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))