VIEW: APPS.IEC_O_LISTS_TO_VALIDATE_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_O_VALIDATION_STATUS B WHERE A.LIST_HEADER_ID = B.LIST_HEADER_ID AND A.STATUS_CODE IN ('PENDING_VALIDATION', 'VALIDATING') AND A.CALL_CENTER_READY_FLAG = 'Y' AND (B.SCHEDULED_EXECUTION_TIME IS NULL OR B.SCHEDULED_EXECUTION_TIME <= SYSDATE)

View Text - HTML Formatted

SELECT DISTINCT A.LIST_HEADER_ID
, A.SCHEDULE_ID
, A.CAMPAIGN_ID
FROM IEC_G_AO_LISTS_V A
, IEC_O_VALIDATION_STATUS B
WHERE A.LIST_HEADER_ID = B.LIST_HEADER_ID
AND A.STATUS_CODE IN ('PENDING_VALIDATION'
, 'VALIDATING')
AND A.CALL_CENTER_READY_FLAG = 'Y'
AND (B.SCHEDULED_EXECUTION_TIME IS NULL OR B.SCHEDULED_EXECUTION_TIME <= SYSDATE)