APPS.HZ_PURGE_GEN dependencies on OKL_TAX_SOURCES_T

Line 4712: --OKL_TAX_SOURCES_T;BILL_TO_PARTY_ID

4708: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES
4709: yy
4710: ));
4711: end if;
4712: --OKL_TAX_SOURCES_T;BILL_TO_PARTY_ID
4713: appid:=540;
4714: if(regid_proc = true) then
4715: 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
4716:

Line 4717: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES_T xx

4713: appid:=540;
4714: if(regid_proc = true) then
4715: 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
4716:
4717: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES_T xx
4718: );
4719: else
4720: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4721: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES_T xx

Line 4721: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES_T xx

4717: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES_T xx
4718: );
4719: else
4720: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4721: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES_T xx
4722: );
4723: end if;
4724: --OKL_TAX_SOURCES_T;BILL_TO_PARTY_SITE_ID
4725: appid:=540;

Line 4724: --OKL_TAX_SOURCES_T;BILL_TO_PARTY_SITE_ID

4720: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4721: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES_T xx
4722: );
4723: end if;
4724: --OKL_TAX_SOURCES_T;BILL_TO_PARTY_SITE_ID
4725: appid:=540;
4726: if(regid_proc = true) then
4727: 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
4728:

Line 4733: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T

4729: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4730: xx
4731: where (nvl(STATUS, 'A') in ('A','I'))
4732: and xx.PARTY_SITE_ID
4733: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T
4734: yy
4735: ));
4736: else
4737: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4742: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T

4738: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4739: xx
4740: where (nvl(STATUS, 'A') in ('A','I'))
4741: and xx.PARTY_SITE_ID
4742: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T
4743: yy
4744: ));
4745: end if;
4746: --OKL_TAX_SOURCES_T;SHIP_TO_PARTY_ID

Line 4746: --OKL_TAX_SOURCES_T;SHIP_TO_PARTY_ID

4742: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T
4743: yy
4744: ));
4745: end if;
4746: --OKL_TAX_SOURCES_T;SHIP_TO_PARTY_ID
4747: appid:=540;
4748: if(regid_proc = true) then
4749: 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
4750:

Line 4751: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES_T xx

4747: appid:=540;
4748: if(regid_proc = true) then
4749: 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
4750:
4751: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES_T xx
4752: );
4753: else
4754: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4755: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES_T xx

Line 4755: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES_T xx

4751: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES_T xx
4752: );
4753: else
4754: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4755: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES_T xx
4756: );
4757: end if;
4758: --OKL_TAX_SOURCES_T;SHIP_TO_PARTY_SITE_ID
4759: appid:=540;

Line 4758: --OKL_TAX_SOURCES_T;SHIP_TO_PARTY_SITE_ID

4754: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4755: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES_T xx
4756: );
4757: end if;
4758: --OKL_TAX_SOURCES_T;SHIP_TO_PARTY_SITE_ID
4759: appid:=540;
4760: if(regid_proc = true) then
4761: 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
4762:

Line 4767: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T

4763: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4764: xx
4765: where (nvl(STATUS, 'A') in ('A','I'))
4766: and xx.PARTY_SITE_ID
4767: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T
4768: yy
4769: ));
4770: else
4771: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4776: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T

4772: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4773: xx
4774: where (nvl(STATUS, 'A') in ('A','I'))
4775: and xx.PARTY_SITE_ID
4776: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T
4777: yy
4778: ));
4779: end if;
4780: --OKL_TERMNT_INTF_PTY;PARTY_OBJECT_ID1