VIEW: APPS.IEC_O_LISTS_TO_STOP_V

Source

View Text - Preformatted

SELECT DISTINCT A.LIST_HEADER_ID , A.SCHEDULE_ID , A.CAMPAIGN_ID FROM IEC_G_AO_LISTS_V A, IEC_G_CAMPAIGNS_V B WHERE A.CAMPAIGN_ID = B.CAMPAIGN_ID AND (A.STATUS_CODE = 'STOPPING' OR (A.STATUS_CODE = 'EXECUTING' AND (A.SCHEDULE_STATUS <> 'ACTIVE' OR B.STATUS_CODE <> 'ACTIVE'))) 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
, IEC_G_CAMPAIGNS_V B
WHERE A.CAMPAIGN_ID = B.CAMPAIGN_ID
AND (A.STATUS_CODE = 'STOPPING' OR (A.STATUS_CODE = 'EXECUTING'
AND (A.SCHEDULE_STATUS <> 'ACTIVE' OR B.STATUS_CODE <> 'ACTIVE')))
AND (A.API_INITIATED_FLAG IS NULL OR A.API_INITIATED_FLAG <> 'Y')