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.

[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on PON_AUCTION_HEADERS_ALL

Line 1907: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id

1903:
1904: or exists (select 'Y' from PON_BID_ITEM_PRICES xx where xx.BID_TRADING_PARTNER_ID = temp.party_id
1905: )
1906:
1907: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1908: )
1909:
1910: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID = temp.party_id
1911: )

Line 1910: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID = temp.party_id

1906:
1907: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1908: )
1909:
1910: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID = temp.party_id
1911: )
1912:
1913: or exists (select 'Y' from PON_AUCTION_EVENTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1914: )

Line 1946: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id

1942:
1943: or exists (select 'Y' from PON_BID_ITEM_PRICES xx where xx.BID_TRADING_PARTNER_ID = temp.party_id
1944: )
1945:
1946: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1947: )
1948:
1949: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID = temp.party_id
1950: )

Line 1949: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID = temp.party_id

1945:
1946: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID = temp.party_id
1947: )
1948:
1949: or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID = temp.party_id
1950: )
1951:
1952: or exists (select 'Y' from PON_AUCTION_EVENTS xx where xx.TRADING_PARTNER_ID = temp.party_id
1953: )

Line 4432: --PON_AUCTION_HEADERS_ALL;DRAFT_LOCKED_BY_CONTACT_ID

4428: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4429: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx
4430: );
4431: end if;
4432: --PON_AUCTION_HEADERS_ALL;DRAFT_LOCKED_BY_CONTACT_ID
4433: appid:=396;
4434: if(regid_proc = true) then
4435: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4436:

Line 4437: temp.party_id in (select /+ parallel(xx)/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

4433: appid:=396;
4434: if(regid_proc = true) then
4435: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4436:
4437: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4438: );
4439: else
4440: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4441: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

Line 4441: temp.party_id in (select /+ parallel(xx)/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

4437: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4438: );
4439: else
4440: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4441: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4442: );
4443: end if;
4444: --PON_AUCTION_HEADERS_ALL;DRAFT_UNLOCKED_BY_CONTACT_ID
4445: appid:=396;

Line 4444: --PON_AUCTION_HEADERS_ALL;DRAFT_UNLOCKED_BY_CONTACT_ID

4440: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4441: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4442: );
4443: end if;
4444: --PON_AUCTION_HEADERS_ALL;DRAFT_UNLOCKED_BY_CONTACT_ID
4445: appid:=396;
4446: if(regid_proc = true) then
4447: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4448:

Line 4449: temp.party_id in (select /+ parallel(xx)/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

4445: appid:=396;
4446: if(regid_proc = true) then
4447: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4448:
4449: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4450: );
4451: else
4452: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4453: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

Line 4453: temp.party_id in (select /+ parallel(xx)/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

4449: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4450: );
4451: else
4452: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4453: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4454: );
4455: end if;
4456: --PON_AUCTION_HEADERS_ALL;SCORING_LOCK_TP_CONTACT_ID
4457: appid:=396;

Line 4456: --PON_AUCTION_HEADERS_ALL;SCORING_LOCK_TP_CONTACT_ID

4452: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4453: temp.party_id in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4454: );
4455: end if;
4456: --PON_AUCTION_HEADERS_ALL;SCORING_LOCK_TP_CONTACT_ID
4457: appid:=396;
4458: if(regid_proc = true) then
4459: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4460:

Line 4461: temp.party_id in (select /+ parallel(xx)/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

4457: appid:=396;
4458: if(regid_proc = true) then
4459: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4460:
4461: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4462: );
4463: else
4464: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4465: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

Line 4465: temp.party_id in (select /+ parallel(xx)/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx

4461: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4462: );
4463: else
4464: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4465: temp.party_id in (select /*+ parallel(xx)*/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx
4466: );
4467: end if;
4468: --PON_AUCTION_EVENTS;TRADING_PARTNER_CONTACT_ID
4469: appid:=396;