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_RULES_B

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

705:
706: or exists (select 'Y' from OKC_CONTACTS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
707: 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_CONTACTS')))
708:
709: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
710: 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')))
711:
712: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
713: 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_PARTY')))

Line 712: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)

708:
709: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
710: 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')))
711:
712: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
713: 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_PARTY')))
714:
715: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
716: 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_PARTY')))

Line 715: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)

711:
712: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
713: 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_PARTY')))
714:
715: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
716: 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_PARTY')))
717:
718: or exists (select 'Y' from HZ_PARTY_SITES
719: xx where xx.PARTY_ID = temp.party_id

Line 722: (select 'Y' from OKC_RULES_B

718: or exists (select 'Y' from HZ_PARTY_SITES
719: xx where xx.PARTY_ID = temp.party_id
720: and (nvl(STATUS, 'A') in ('A','I'))
721: and exists
722: (select 'Y' from OKC_RULES_B
723: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
724: 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')))
725:
726: or exists (select 'Y' from HZ_PARTY_SITES

Line 730: (select 'Y' from OKC_RULES_B

726: or exists (select 'Y' from HZ_PARTY_SITES
727: xx where xx.PARTY_ID = temp.party_id
728: and (nvl(STATUS, 'A') in ('A','I'))
729: and exists
730: (select 'Y' from OKC_RULES_B
731: yy where yy.OBJECT2_ID1=to_char(xx.PARTY_SITE_ID)
732: 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')))
733:
734: or exists (select 'Y' from HZ_PARTY_SITES

Line 738: (select 'Y' from OKC_RULES_B

734: or exists (select 'Y' from HZ_PARTY_SITES
735: xx where xx.PARTY_ID = temp.party_id
736: and (nvl(STATUS, 'A') in ('A','I'))
737: and exists
738: (select 'Y' from OKC_RULES_B
739: yy where yy.OBJECT3_ID1=to_char(xx.PARTY_SITE_ID)
740: 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')))
741:
742: or exists (select 'Y' from HZ_PARTY_SITES

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

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'))))
751:
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'))

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

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'))))
761:
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'))

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

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'))))
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:

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

798:
799: or exists (select 'Y' from OKC_CONTACTS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
800: 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_CONTACTS')))
801:
802: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
803: 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')))
804:
805: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
806: 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_PARTY')))

Line 805: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)

801:
802: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
803: 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')))
804:
805: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
806: 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_PARTY')))
807:
808: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
809: 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_PARTY')))

Line 808: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)

804:
805: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
806: 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_PARTY')))
807:
808: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
809: 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_PARTY')))
810:
811: or exists (select 'Y' from HZ_PARTY_SITES
812: xx where xx.PARTY_ID = temp.party_id

Line 815: (select 'Y' from OKC_RULES_B

811: or exists (select 'Y' from HZ_PARTY_SITES
812: xx where xx.PARTY_ID = temp.party_id
813: and (nvl(STATUS, 'A') in ('A','I'))
814: and exists
815: (select 'Y' from OKC_RULES_B
816: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
817: 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')))
818:
819: or exists (select 'Y' from HZ_PARTY_SITES

Line 823: (select 'Y' from OKC_RULES_B

819: or exists (select 'Y' from HZ_PARTY_SITES
820: xx where xx.PARTY_ID = temp.party_id
821: and (nvl(STATUS, 'A') in ('A','I'))
822: and exists
823: (select 'Y' from OKC_RULES_B
824: yy where yy.OBJECT2_ID1=to_char(xx.PARTY_SITE_ID)
825: 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')))
826:
827: or exists (select 'Y' from HZ_PARTY_SITES

Line 831: (select 'Y' from OKC_RULES_B

827: or exists (select 'Y' from HZ_PARTY_SITES
828: xx where xx.PARTY_ID = temp.party_id
829: and (nvl(STATUS, 'A') in ('A','I'))
830: and exists
831: (select 'Y' from OKC_RULES_B
832: yy where yy.OBJECT3_ID1=to_char(xx.PARTY_SITE_ID)
833: 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')))
834:
835: or exists (select 'Y' from HZ_PARTY_SITES

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

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'))))
844:
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'))

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

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'))))
854:
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'))

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

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'))))
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:

Line 4804: --OKC_RULES_B;OBJECT1_ID1

4800: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4801: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_NEW from OKL_TRX_CONTRACTS_ALL xx
4802: );
4803: end if;
4804: --OKC_RULES_B;OBJECT1_ID1
4805: appid:=540;
4806: if(regid_proc = true) then
4807: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4808:

Line 4813: in (select /+ parallel(yy)/ yy.OBJECT1_ID1 from OKC_RULES_B

4809: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4810: xx
4811: where (nvl(STATUS, 'A') in ('A','I'))
4812: and to_char(xx.PARTY_SITE_ID)
4813: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_RULES_B
4814: yy
4815: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4816: else
4817: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4822: in (select /+ parallel(yy)/ yy.OBJECT1_ID1 from OKC_RULES_B

4818: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4819: xx
4820: where (nvl(STATUS, 'A') in ('A','I'))
4821: and to_char(xx.PARTY_SITE_ID)
4822: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_RULES_B
4823: yy
4824: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4825: end if;
4826: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID1_NEW