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 OKC_K_ITEMS

Line 931: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_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'))))
930:
931: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
932: 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_PARTY')))
933:
934: or exists (select 'Y' from HZ_PARTY_SITES
935: xx where xx.PARTY_ID = temp.party_id

Line 938: (select 'Y' from OKC_K_ITEMS

934: or exists (select 'Y' from HZ_PARTY_SITES
935: xx where xx.PARTY_ID = temp.party_id
936: and (nvl(STATUS, 'A') in ('A','I'))
937: and exists
938: (select 'Y' from OKC_K_ITEMS
939: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
940: 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')))
941:
942: or exists (select 'Y' from HZ_PARTY_SITES

Line 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'))));

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'))));
951: else
952: delete from hz_purge_gt temp where
953:
954:

Line 1024: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_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'))))
1023:
1024: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
1025: 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_PARTY')))
1026:
1027: or exists (select 'Y' from HZ_PARTY_SITES
1028: xx where xx.PARTY_ID = temp.party_id

Line 1031: (select 'Y' from OKC_K_ITEMS

1027: or exists (select 'Y' from HZ_PARTY_SITES
1028: xx where xx.PARTY_ID = temp.party_id
1029: and (nvl(STATUS, 'A') in ('A','I'))
1030: and exists
1031: (select 'Y' from OKC_K_ITEMS
1032: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
1033: 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')))
1034:
1035: or exists (select 'Y' from HZ_PARTY_SITES

Line 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'))));

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'))));
1044: end if;
1045:
1046:
1047: --delete and insert records into hz_purge_gt for an application