VIEW: APPS.IEC_G_EXECUTING_LISTS_V

Source

View Text - Preformatted

SELECT A.LIST_HEADER_ID , A.SCHEDULE_ID , A.CAMPAIGN_ID , A.RELEASE_CONTROL_ALG_ID , A.DIALING_METHOD , A.RELEASE_STRATEGY , A.CALLING_CALENDAR_ID , A.SOURCE_TYPE_CODE , A.QUOTA , A.quota_reset , A.RECYCLING_ALG_ID , A.preview_time , A.distribution_priority , A.distribution_weight , A.reset_time , A.predictive_timeout , A.abandon_limit , A.agent_line_ratio , A.DIALING_COMPLIANCE_RULE , A.ENABLE_WITHDRAW_FLAG , A.ENABLE_ABANDON_FLAG FROM IEC_G_AO_LISTS_V A , IEC_G_CAMPAIGNS_V B WHERE B.STATUS_CODE = 'ACTIVE' AND B.ACTIVE_FLAG = 'Y' AND A.CAMPAIGN_ID = B.CAMPAIGN_ID AND A.SCHEDULE_STATUS = 'ACTIVE' AND A.STATUS_CODE = 'ACTIVE' AND A.LANGUAGE = B.LANGUAGE AND A.LANGUAGE = 'US'

View Text - HTML Formatted

SELECT A.LIST_HEADER_ID
, A.SCHEDULE_ID
, A.CAMPAIGN_ID
, A.RELEASE_CONTROL_ALG_ID
, A.DIALING_METHOD
, A.RELEASE_STRATEGY
, A.CALLING_CALENDAR_ID
, A.SOURCE_TYPE_CODE
, A.QUOTA
, A.QUOTA_RESET
, A.RECYCLING_ALG_ID
, A.PREVIEW_TIME
, A.DISTRIBUTION_PRIORITY
, A.DISTRIBUTION_WEIGHT
, A.RESET_TIME
, A.PREDICTIVE_TIMEOUT
, A.ABANDON_LIMIT
, A.AGENT_LINE_RATIO
, A.DIALING_COMPLIANCE_RULE
, A.ENABLE_WITHDRAW_FLAG
, A.ENABLE_ABANDON_FLAG
FROM IEC_G_AO_LISTS_V A
, IEC_G_CAMPAIGNS_V B
WHERE B.STATUS_CODE = 'ACTIVE'
AND B.ACTIVE_FLAG = 'Y'
AND A.CAMPAIGN_ID = B.CAMPAIGN_ID
AND A.SCHEDULE_STATUS = 'ACTIVE'
AND A.STATUS_CODE = 'ACTIVE'
AND A.LANGUAGE = B.LANGUAGE
AND A.LANGUAGE = 'US'