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 343: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id

339:
340: exists (select 'Y' from IBE_SH_SHP_LISTS_ALL xx where xx.PARTY_ID = temp.party_id
341: )
342:
343: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id
344: )
345:
346: or exists (select 'Y' from HZ_PARTY_SITES
347: xx where xx.PARTY_ID = temp.party_id

Line 350: (select 'Y' from IBE_ORD_ONECLICK_ALL

346: or exists (select 'Y' from HZ_PARTY_SITES
347: xx where xx.PARTY_ID = temp.party_id
348: and (nvl(STATUS, 'A') in ('A','I'))
349: and exists
350: (select 'Y' from IBE_ORD_ONECLICK_ALL
351: yy where yy.BILL_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
352: ))
353:
354: or exists (select 'Y' from HZ_PARTY_SITES

Line 358: (select 'Y' from IBE_ORD_ONECLICK_ALL

354: or exists (select 'Y' from HZ_PARTY_SITES
355: xx where xx.PARTY_ID = temp.party_id
356: and (nvl(STATUS, 'A') in ('A','I'))
357: and exists
358: (select 'Y' from IBE_ORD_ONECLICK_ALL
359: yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
360: ))
361:
362: or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID = temp.party_id

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

367:
368: exists (select 'Y' from IBE_SH_SHP_LISTS_ALL xx where xx.PARTY_ID = temp.party_id
369: )
370:
371: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id
372: )
373:
374: or exists (select 'Y' from HZ_PARTY_SITES
375: xx where xx.PARTY_ID = temp.party_id

Line 378: (select 'Y' from IBE_ORD_ONECLICK_ALL

374: or exists (select 'Y' from HZ_PARTY_SITES
375: xx where xx.PARTY_ID = temp.party_id
376: and (nvl(STATUS, 'A') in ('A','I'))
377: and exists
378: (select 'Y' from IBE_ORD_ONECLICK_ALL
379: yy where yy.BILL_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
380: ))
381:
382: or exists (select 'Y' from HZ_PARTY_SITES

Line 386: (select 'Y' from IBE_ORD_ONECLICK_ALL

382: or exists (select 'Y' from HZ_PARTY_SITES
383: xx where xx.PARTY_ID = temp.party_id
384: and (nvl(STATUS, 'A') in ('A','I'))
385: and exists
386: (select 'Y' from IBE_ORD_ONECLICK_ALL
387: yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
388: ))
389:
390: or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID = temp.party_id