VIEW: APPS.IEC_O_LISTS_TO_PURGE_V

Source

View Text - Preformatted

SELECT DISTINCT A.LIST_HEADER_ID , A.SCHEDULE_ID , A.CAMPAIGN_ID FROM IEC_G_AO_LISTS_V A WHERE A.STATUS_CODE IN ('PENDING_PURGE', 'PURGING') AND (A.API_INITIATED_FLAG IS NULL OR A.API_INITIATED_FLAG <> 'Y')

View Text - HTML Formatted

SELECT DISTINCT A.LIST_HEADER_ID
, A.SCHEDULE_ID
, A.CAMPAIGN_ID
FROM IEC_G_AO_LISTS_V A
WHERE A.STATUS_CODE IN ('PENDING_PURGE'
, 'PURGING')
AND (A.API_INITIATED_FLAG IS NULL OR A.API_INITIATED_FLAG <> 'Y')