APPS.HZ_PURGE_GEN dependencies on OKL_TAX_SOURCES

Line 4644: --OKL_TAX_SOURCES;BILL_TO_PARTY_ID

4640: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_OPPS_ALL_B
4641: yy
4642: ));
4643: end if;
4644: --OKL_TAX_SOURCES;BILL_TO_PARTY_ID
4645: appid:=540;
4646: if(regid_proc = true) then
4647: 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
4648:

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

4645: appid:=540;
4646: if(regid_proc = true) then
4647: 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
4648:
4649: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES xx
4650: );
4651: else
4652: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4653: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES xx

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

4649: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES xx
4650: );
4651: else
4652: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4653: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES xx
4654: );
4655: end if;
4656: --OKL_TAX_SOURCES;BILL_TO_PARTY_SITE_ID
4657: appid:=540;

Line 4656: --OKL_TAX_SOURCES;BILL_TO_PARTY_SITE_ID

4652: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4653: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OKL_TAX_SOURCES xx
4654: );
4655: end if;
4656: --OKL_TAX_SOURCES;BILL_TO_PARTY_SITE_ID
4657: appid:=540;
4658: if(regid_proc = true) then
4659: 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
4660:

Line 4665: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES

4661: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4662: xx
4663: where (nvl(STATUS, 'A') in ('A','I'))
4664: and xx.PARTY_SITE_ID
4665: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES
4666: yy
4667: ));
4668: else
4669: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4674: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES

4670: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4671: xx
4672: where (nvl(STATUS, 'A') in ('A','I'))
4673: and xx.PARTY_SITE_ID
4674: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES
4675: yy
4676: ));
4677: end if;
4678: --OKL_TAX_SOURCES;SHIP_TO_PARTY_ID

Line 4678: --OKL_TAX_SOURCES;SHIP_TO_PARTY_ID

4674: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES
4675: yy
4676: ));
4677: end if;
4678: --OKL_TAX_SOURCES;SHIP_TO_PARTY_ID
4679: appid:=540;
4680: if(regid_proc = true) then
4681: 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
4682:

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

4679: appid:=540;
4680: if(regid_proc = true) then
4681: 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
4682:
4683: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES xx
4684: );
4685: else
4686: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4687: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES xx

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

4683: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES xx
4684: );
4685: else
4686: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4687: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES xx
4688: );
4689: end if;
4690: --OKL_TAX_SOURCES;SHIP_TO_PARTY_SITE_ID
4691: appid:=540;

Line 4690: --OKL_TAX_SOURCES;SHIP_TO_PARTY_SITE_ID

4686: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4687: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OKL_TAX_SOURCES xx
4688: );
4689: end if;
4690: --OKL_TAX_SOURCES;SHIP_TO_PARTY_SITE_ID
4691: appid:=540;
4692: if(regid_proc = true) then
4693: 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
4694:

Line 4699: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES

4695: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4696: xx
4697: where (nvl(STATUS, 'A') in ('A','I'))
4698: and xx.PARTY_SITE_ID
4699: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES
4700: yy
4701: ));
4702: else
4703: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4708: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES

4704: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4705: xx
4706: where (nvl(STATUS, 'A') in ('A','I'))
4707: and xx.PARTY_SITE_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

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