DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on PO_VENDOR_SITES_ALL

Line 4898: --PO_VENDOR_SITES_ALL;PARTY_SITE_ID

4894: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PO_VENDORS xx
4896: );
4897: end if;
4898: --PO_VENDOR_SITES_ALL;PARTY_SITE_ID
4899: appid:=200;
4900: if(regid_proc = true) then
4901: insert into hz_application_trans_gt(app_id,party_id) select 200, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 200 and appl.party_id=temp.party_id) and
4902:

Line 4907: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from PO_VENDOR_SITES_ALL

4903: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4904: xx
4905: where (nvl(STATUS, 'A') in ('A','I'))
4906: and xx.PARTY_SITE_ID
4907: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from PO_VENDOR_SITES_ALL
4908: yy
4909: ));
4910: else
4911: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4916: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from PO_VENDOR_SITES_ALL

4912: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4913: xx
4914: where (nvl(STATUS, 'A') in ('A','I'))
4915: and xx.PARTY_SITE_ID
4916: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from PO_VENDOR_SITES_ALL
4917: yy
4918: ));
4919: end if;
4920: --AMS_IBA_PL_SITES_B;SITE_CATEGORY_OBJECT_ID