APPS.HZ_PURGE_GEN dependencies on OKC_K_ITEMS

Line 772: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)

768: and nvl(STATUS, 'A') in ('A','I')
769: and exists
770: (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'))))
771:
772: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
773: 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')))
774:
775: or exists (select 'Y' from HZ_PARTY_SITES
776: xx where xx.PARTY_ID = temp.party_id

Line 779: (select 'Y' from OKC_K_ITEMS

775: or exists (select 'Y' from HZ_PARTY_SITES
776: xx where xx.PARTY_ID = temp.party_id
777: and (nvl(STATUS, 'A') in ('A','I'))
778: and exists
779: (select 'Y' from OKC_K_ITEMS
780: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
781: 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')))
782:
783: or exists (select 'Y' from HZ_PARTY_SITES

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

787: (select 'Y' from HZ_PARTY_SITE_USES
788: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
789: and nvl(STATUS, 'A') in ('A','I')
790: and exists
791: (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'))));
792: else
793: delete from hz_purge_gt temp where
794:
795:

Line 865: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)

861: and nvl(STATUS, 'A') in ('A','I')
862: and exists
863: (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'))))
864:
865: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
866: 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')))
867:
868: or exists (select 'Y' from HZ_PARTY_SITES
869: xx where xx.PARTY_ID = temp.party_id

Line 872: (select 'Y' from OKC_K_ITEMS

868: or exists (select 'Y' from HZ_PARTY_SITES
869: xx where xx.PARTY_ID = temp.party_id
870: and (nvl(STATUS, 'A') in ('A','I'))
871: and exists
872: (select 'Y' from OKC_K_ITEMS
873: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
874: 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')))
875:
876: or exists (select 'Y' from HZ_PARTY_SITES

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

880: (select 'Y' from HZ_PARTY_SITE_USES
881: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
882: and nvl(STATUS, 'A') in ('A','I')
883: and exists
884: (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'))));
885: end if;
886:
887:
888: --delete and insert records into hz_purge_gt for an application