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 IBE_ORD_ONECLICK_ALL

Line 360: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id

356:
357: exists (select 'Y' from IBE_SH_SHP_LISTS_ALL xx where xx.PARTY_ID = temp.party_id
358: )
359:
360: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id
361: )
362:
363: or exists (select 'Y' from HZ_PARTY_SITES
364: xx where xx.PARTY_ID = temp.party_id

Line 367: (select 'Y' from IBE_ORD_ONECLICK_ALL

363: or exists (select 'Y' from HZ_PARTY_SITES
364: xx where xx.PARTY_ID = temp.party_id
365: and (nvl(STATUS, 'A') in ('A','I'))
366: and exists
367: (select 'Y' from IBE_ORD_ONECLICK_ALL
368: yy where yy.BILL_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
369: ))
370:
371: or exists (select 'Y' from HZ_PARTY_SITES

Line 375: (select 'Y' from IBE_ORD_ONECLICK_ALL

371: or exists (select 'Y' from HZ_PARTY_SITES
372: xx where xx.PARTY_ID = temp.party_id
373: and (nvl(STATUS, 'A') in ('A','I'))
374: and exists
375: (select 'Y' from IBE_ORD_ONECLICK_ALL
376: yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
377: ))
378:
379: or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID = temp.party_id

Line 388: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id

384:
385: exists (select 'Y' from IBE_SH_SHP_LISTS_ALL xx where xx.PARTY_ID = temp.party_id
386: )
387:
388: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id
389: )
390:
391: or exists (select 'Y' from HZ_PARTY_SITES
392: xx where xx.PARTY_ID = temp.party_id

Line 395: (select 'Y' from IBE_ORD_ONECLICK_ALL

391: or exists (select 'Y' from HZ_PARTY_SITES
392: xx where xx.PARTY_ID = temp.party_id
393: and (nvl(STATUS, 'A') in ('A','I'))
394: and exists
395: (select 'Y' from IBE_ORD_ONECLICK_ALL
396: yy where yy.BILL_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
397: ))
398:
399: or exists (select 'Y' from HZ_PARTY_SITES

Line 403: (select 'Y' from IBE_ORD_ONECLICK_ALL

399: or exists (select 'Y' from HZ_PARTY_SITES
400: xx where xx.PARTY_ID = temp.party_id
401: and (nvl(STATUS, 'A') in ('A','I'))
402: and exists
403: (select 'Y' from IBE_ORD_ONECLICK_ALL
404: yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
405: ))
406:
407: or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID = temp.party_id