APPS.HZ_PURGE_GEN dependencies on HZ_PARTY_SITE_USES

Line 746: (select 'Y' from HZ_PARTY_SITE_USES

742: or exists (select 'Y' from HZ_PARTY_SITES
743: xx where xx.PARTY_ID = temp.party_id
744: and (nvl(STATUS, 'A') in ('A','I'))
745: and exists
746: (select 'Y' from HZ_PARTY_SITE_USES
747: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
748: and nvl(STATUS, 'A') in ('A','I')
749: and exists
750: (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 756: (select 'Y' from HZ_PARTY_SITE_USES

752: or exists (select 'Y' from HZ_PARTY_SITES
753: xx where xx.PARTY_ID = temp.party_id
754: and (nvl(STATUS, 'A') in ('A','I'))
755: and exists
756: (select 'Y' from HZ_PARTY_SITE_USES
757: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
758: and nvl(STATUS, 'A') in ('A','I')
759: and exists
760: (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 766: (select 'Y' from HZ_PARTY_SITE_USES

762: or exists (select 'Y' from HZ_PARTY_SITES
763: xx where xx.PARTY_ID = temp.party_id
764: and (nvl(STATUS, 'A') in ('A','I'))
765: and exists
766: (select 'Y' from HZ_PARTY_SITE_USES
767: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_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'))))

Line 787: (select 'Y' from HZ_PARTY_SITE_USES

783: or exists (select 'Y' from HZ_PARTY_SITES
784: xx where xx.PARTY_ID = temp.party_id
785: and (nvl(STATUS, 'A') in ('A','I'))
786: and exists
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'))));

Line 839: (select 'Y' from HZ_PARTY_SITE_USES

835: or exists (select 'Y' from HZ_PARTY_SITES
836: xx where xx.PARTY_ID = temp.party_id
837: and (nvl(STATUS, 'A') in ('A','I'))
838: and exists
839: (select 'Y' from HZ_PARTY_SITE_USES
840: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
841: and nvl(STATUS, 'A') in ('A','I')
842: and exists
843: (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 849: (select 'Y' from HZ_PARTY_SITE_USES

845: or exists (select 'Y' from HZ_PARTY_SITES
846: xx where xx.PARTY_ID = temp.party_id
847: and (nvl(STATUS, 'A') in ('A','I'))
848: and exists
849: (select 'Y' from HZ_PARTY_SITE_USES
850: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
851: and nvl(STATUS, 'A') in ('A','I')
852: and exists
853: (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 859: (select 'Y' from HZ_PARTY_SITE_USES

855: or exists (select 'Y' from HZ_PARTY_SITES
856: xx where xx.PARTY_ID = temp.party_id
857: and (nvl(STATUS, 'A') in ('A','I'))
858: and exists
859: (select 'Y' from HZ_PARTY_SITE_USES
860: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_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'))))

Line 880: (select 'Y' from HZ_PARTY_SITE_USES

876: or exists (select 'Y' from HZ_PARTY_SITES
877: xx where xx.PARTY_ID = temp.party_id
878: and (nvl(STATUS, 'A') in ('A','I'))
879: and exists
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'))));

Line 1894: (select 'Y' from HZ_PARTY_SITE_USES

1890: exists (select 'Y' from HZ_PARTY_SITES
1891: xx where xx.PARTY_ID = temp.party_id
1892: and (nvl(STATUS, 'A') in ('A','I'))
1893: and exists
1894: (select 'Y' from HZ_PARTY_SITE_USES
1895: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1896: and nvl(STATUS, 'A') in ('A','I')
1897: and exists
1898: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

Line 1971: (select 'Y' from HZ_PARTY_SITE_USES

1967: exists (select 'Y' from HZ_PARTY_SITES
1968: xx where xx.PARTY_ID = temp.party_id
1969: and (nvl(STATUS, 'A') in ('A','I'))
1970: and exists
1971: (select 'Y' from HZ_PARTY_SITE_USES
1972: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1973: and nvl(STATUS, 'A') in ('A','I')
1974: and exists
1975: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))