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')