VIEW: APPS.IEC_G_AO_LISTS_V

Source

View Text - Preformatted

SELECT A.list_name , A.list_header_id , A.list_source_type , A.status_code , D.schedule_name , B.schedule_id , B.status_code , (CASE WHEN A.status_code IN ('LOCKED', 'EXECUTING') THEN NVL(F.status_code, 'INACTIVE') ELSE A.status_code END) , F.api_initiated_flag , D.language , E.campaign_id , E.campaign_name , F.dialing_method , F.release_control_alg_id , F.release_strategy , F.calling_calendar_id , F.recycling_alg_id , F.quota , F.quota_reset , F.call_center_ready_flag , F.preview_time , F.execution_start_time , F.distribution_priority , F.distribution_weight , F.reset_time , F.predictive_timeout , F.abandon_limit , F.agent_line_ratio , B.start_date_time , B.end_date_time , F.DIALING_COMPLIANCE_RULE , F.ENABLE_WITHDRAW_FLAG , F.ENABLE_ABANDON_FLAG from ams_list_headers_vl A , ams_campaign_schedules_b B , ams_act_lists C , ams_campaign_schedules_tl D , ams_campaigns_all_tl E , iec_g_list_rt_info F WHERE B.activity_id = 460 and B.schedule_id = D.schedule_id and B.campaign_id = E.campaign_id and A.list_header_id = F.list_header_id(+) and B.schedule_id = C.list_used_by_id(+) and C.list_used_by='CSCH' and C.list_act_type = 'TARGET' and C.list_header_id =A.list_header_id(+) and D.language = E.language

View Text - HTML Formatted

SELECT A.LIST_NAME
, A.LIST_HEADER_ID
, A.LIST_SOURCE_TYPE
, A.STATUS_CODE
, D.SCHEDULE_NAME
, B.SCHEDULE_ID
, B.STATUS_CODE
, (CASE WHEN A.STATUS_CODE IN ('LOCKED'
, 'EXECUTING') THEN NVL(F.STATUS_CODE
, 'INACTIVE') ELSE A.STATUS_CODE END)
, F.API_INITIATED_FLAG
, D.LANGUAGE
, E.CAMPAIGN_ID
, E.CAMPAIGN_NAME
, F.DIALING_METHOD
, F.RELEASE_CONTROL_ALG_ID
, F.RELEASE_STRATEGY
, F.CALLING_CALENDAR_ID
, F.RECYCLING_ALG_ID
, F.QUOTA
, F.QUOTA_RESET
, F.CALL_CENTER_READY_FLAG
, F.PREVIEW_TIME
, F.EXECUTION_START_TIME
, F.DISTRIBUTION_PRIORITY
, F.DISTRIBUTION_WEIGHT
, F.RESET_TIME
, F.PREDICTIVE_TIMEOUT
, F.ABANDON_LIMIT
, F.AGENT_LINE_RATIO
, B.START_DATE_TIME
, B.END_DATE_TIME
, F.DIALING_COMPLIANCE_RULE
, F.ENABLE_WITHDRAW_FLAG
, F.ENABLE_ABANDON_FLAG
FROM AMS_LIST_HEADERS_VL A
, AMS_CAMPAIGN_SCHEDULES_B B
, AMS_ACT_LISTS C
, AMS_CAMPAIGN_SCHEDULES_TL D
, AMS_CAMPAIGNS_ALL_TL E
, IEC_G_LIST_RT_INFO F
WHERE B.ACTIVITY_ID = 460
AND B.SCHEDULE_ID = D.SCHEDULE_ID
AND B.CAMPAIGN_ID = E.CAMPAIGN_ID
AND A.LIST_HEADER_ID = F.LIST_HEADER_ID(+)
AND B.SCHEDULE_ID = C.LIST_USED_BY_ID(+)
AND C.LIST_USED_BY='CSCH'
AND C.LIST_ACT_TYPE = 'TARGET'
AND C.LIST_HEADER_ID =A.LIST_HEADER_ID(+)
AND D.LANGUAGE = E.LANGUAGE