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 OKL_K_HEADERS

Line 4553: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));

4549: where (nvl(STATUS, 'A') in ('A','I'))
4550: and to_char(xx.PARTY_SITE_ID)
4551: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_K_PARTY_ROLES_B
4552: yy
4553: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4554: else
4555: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4556: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4557: xx

Line 4562: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));

4558: where (nvl(STATUS, 'A') in ('A','I'))
4559: and to_char(xx.PARTY_SITE_ID)
4560: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_K_PARTY_ROLES_B
4561: yy
4562: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4563: end if;
4564: --OKC_K_PARTY_ROLES_B;OBJECT1_ID1
4565: appid:=540;
4566: if(regid_proc = true) then

Line 4570: where (JTOT_OBJECT1_CODE = 'OKX_PARTY' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));

4566: if(regid_proc = true) then
4567: 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
4568:
4569: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.OBJECT1_ID1 from OKC_K_PARTY_ROLES_B xx
4570: where (JTOT_OBJECT1_CODE = 'OKX_PARTY' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4571: else
4572: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4573: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.OBJECT1_ID1 from OKC_K_PARTY_ROLES_B xx
4574: where (JTOT_OBJECT1_CODE = 'OKX_PARTY' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));

Line 4574: where (JTOT_OBJECT1_CODE = 'OKX_PARTY' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));

4570: where (JTOT_OBJECT1_CODE = 'OKX_PARTY' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4571: else
4572: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4573: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.OBJECT1_ID1 from OKC_K_PARTY_ROLES_B xx
4574: where (JTOT_OBJECT1_CODE = 'OKX_PARTY' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4575: end if;
4576: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID1_OLD
4577: appid:=540;
4578: if(regid_proc = true) then

Line 4815: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));

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
4818: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4819: xx

Line 4824: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));

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
4827: appid:=540;
4828: if(regid_proc = true) then