VIEW: APPS.IEC_AO_CAMPAIGN_LIST_V

Source

View Text - Preformatted

SELECT DISTINCT campaigns_b.CAMPAIGN_ID CAMPAIGN_ID , schedules_b.SCHEDULE_ID SCHEDULE_ID , ao_lists.SCHEDULE_ID AO_SCHEDULE_ID , campaigns_tl.CAMPAIGN_NAME CAMPAIGN_NAME , schedules_tl.SCHEDULE_NAME SCHEDULE_NAME , campaigns_b.OWNER_USER_ID CAMPAIGN_OWNER_USER_ID , schedules_b.OWNER_USER_ID SCHEDULE_OWNER_USER_ID , iec_get_translated_fnd_lookup(list_rt.DIALING_METHOD, 'IEC_DIAL_TYPE', campaigns_tl.LANGUAGE) SCHEDULE_DIALING_METHOD , campaigns_b.SOURCE_CODE CAMPAIGN_SOURCE_CODE , schedules_b.SOURCE_CODE SCHEDULE_SOURCE_CODE , iec_get_translated_fnd_lookup(list_headers.LIST_SOURCE_TYPE, 'IEC_SOURCE_VIEW_MAP', campaigns_tl.LANGUAGE) SCHEDULE_SOURCE_TYPE , iec_get_translated_fnd_lookup(list_rt.CALL_CENTER_READY_FLAG, 'YES_NO', campaigns_tl.LANGUAGE) SCHED_INTERACTION_CENTER_READY , iec_get_translated_fnd_lookup(list_rt.PARAMS_INHERITED_FLAG, 'YES_NO', campaigns_tl.LANGUAGE) SCHEDULE_PARAMETERS_INHERITED , campaigns_b.STATUS_CODE CAMPAIGN_STATUS_CODE , status_tl1.NAME CAMPAIGN_STATUS , schedules_b.STATUS_CODE SCHEDULE_STATUS_CODE , status_tl2.NAME SCHEDULE_STATUS , campaigns_b.ACTUAL_EXEC_START_DATE CAMPAIGN_START_DATE , schedules_b.START_DATE_TIME SCHEDULE_START_DATE , campaigns_b.ACTUAL_EXEC_END_DATE CAMPAIGN_END_DATE , schedules_b.END_DATE_TIME SCHEDULE_END_DATE , campaigns_tl.LANGUAGE LANGUAGE FROM AMS_CAMPAIGNS_ALL_B campaigns_b , AMS_CAMPAIGNS_ALL_TL campaigns_tl , AMS_CAMPAIGN_SCHEDULES_B schedules_b , AMS_CAMPAIGN_SCHEDULES_TL schedules_tl , AMS_USER_STATUSES_TL status_tl1 , AMS_USER_STATUSES_TL status_tl2 , IEC_G_EXECUTING_LISTS_V exec_lists , AMS_LIST_HEADERS_ALL list_headers , IEC_G_LIST_RT_INFO list_rt , IEC_G_AO_LISTS_V ao_lists WHERE schedules_b.ACTIVITY_ID = '460' AND schedules_b.CAMPAIGN_ID(+) = campaigns_b.CAMPAIGN_ID AND schedules_b.SCHEDULE_ID = schedules_tl.SCHEDULE_ID AND schedules_b.SCHEDULE_ID = exec_lists.SCHEDULE_ID(+) AND schedules_b.SCHEDULE_ID = list_rt.CAMPAIGN_SCHEDULE_ID(+) AND schedules_b.SCHEDULE_ID = ao_lists.SCHEDULE_ID(+) AND ao_lists.LIST_HEADER_ID = list_headers.LIST_HEADER_ID(+) AND campaigns_b.CAMPAIGN_ID = campaigns_tl.CAMPAIGN_ID AND status_tl1.USER_STATUS_ID = campaigns_b.USER_STATUS_ID AND status_tl2.USER_STATUS_ID = schedules_b.USER_STATUS_ID AND schedules_tl.LANGUAGE = campaigns_tl.LANGUAGE AND schedules_tl.LANGUAGE = status_tl1.LANGUAGE AND schedules_tl.LANGUAGE = status_tl2.LANGUAGE

View Text - HTML Formatted

SELECT DISTINCT CAMPAIGNS_B.CAMPAIGN_ID CAMPAIGN_ID
, SCHEDULES_B.SCHEDULE_ID SCHEDULE_ID
, AO_LISTS.SCHEDULE_ID AO_SCHEDULE_ID
, CAMPAIGNS_TL.CAMPAIGN_NAME CAMPAIGN_NAME
, SCHEDULES_TL.SCHEDULE_NAME SCHEDULE_NAME
, CAMPAIGNS_B.OWNER_USER_ID CAMPAIGN_OWNER_USER_ID
, SCHEDULES_B.OWNER_USER_ID SCHEDULE_OWNER_USER_ID
, IEC_GET_TRANSLATED_FND_LOOKUP(LIST_RT.DIALING_METHOD
, 'IEC_DIAL_TYPE'
, CAMPAIGNS_TL.LANGUAGE) SCHEDULE_DIALING_METHOD
, CAMPAIGNS_B.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, SCHEDULES_B.SOURCE_CODE SCHEDULE_SOURCE_CODE
, IEC_GET_TRANSLATED_FND_LOOKUP(LIST_HEADERS.LIST_SOURCE_TYPE
, 'IEC_SOURCE_VIEW_MAP'
, CAMPAIGNS_TL.LANGUAGE) SCHEDULE_SOURCE_TYPE
, IEC_GET_TRANSLATED_FND_LOOKUP(LIST_RT.CALL_CENTER_READY_FLAG
, 'YES_NO'
, CAMPAIGNS_TL.LANGUAGE) SCHED_INTERACTION_CENTER_READY
, IEC_GET_TRANSLATED_FND_LOOKUP(LIST_RT.PARAMS_INHERITED_FLAG
, 'YES_NO'
, CAMPAIGNS_TL.LANGUAGE) SCHEDULE_PARAMETERS_INHERITED
, CAMPAIGNS_B.STATUS_CODE CAMPAIGN_STATUS_CODE
, STATUS_TL1.NAME CAMPAIGN_STATUS
, SCHEDULES_B.STATUS_CODE SCHEDULE_STATUS_CODE
, STATUS_TL2.NAME SCHEDULE_STATUS
, CAMPAIGNS_B.ACTUAL_EXEC_START_DATE CAMPAIGN_START_DATE
, SCHEDULES_B.START_DATE_TIME SCHEDULE_START_DATE
, CAMPAIGNS_B.ACTUAL_EXEC_END_DATE CAMPAIGN_END_DATE
, SCHEDULES_B.END_DATE_TIME SCHEDULE_END_DATE
, CAMPAIGNS_TL.LANGUAGE LANGUAGE
FROM AMS_CAMPAIGNS_ALL_B CAMPAIGNS_B
, AMS_CAMPAIGNS_ALL_TL CAMPAIGNS_TL
, AMS_CAMPAIGN_SCHEDULES_B SCHEDULES_B
, AMS_CAMPAIGN_SCHEDULES_TL SCHEDULES_TL
, AMS_USER_STATUSES_TL STATUS_TL1
, AMS_USER_STATUSES_TL STATUS_TL2
, IEC_G_EXECUTING_LISTS_V EXEC_LISTS
, AMS_LIST_HEADERS_ALL LIST_HEADERS
, IEC_G_LIST_RT_INFO LIST_RT
, IEC_G_AO_LISTS_V AO_LISTS
WHERE SCHEDULES_B.ACTIVITY_ID = '460'
AND SCHEDULES_B.CAMPAIGN_ID(+) = CAMPAIGNS_B.CAMPAIGN_ID
AND SCHEDULES_B.SCHEDULE_ID = SCHEDULES_TL.SCHEDULE_ID
AND SCHEDULES_B.SCHEDULE_ID = EXEC_LISTS.SCHEDULE_ID(+)
AND SCHEDULES_B.SCHEDULE_ID = LIST_RT.CAMPAIGN_SCHEDULE_ID(+)
AND SCHEDULES_B.SCHEDULE_ID = AO_LISTS.SCHEDULE_ID(+)
AND AO_LISTS.LIST_HEADER_ID = LIST_HEADERS.LIST_HEADER_ID(+)
AND CAMPAIGNS_B.CAMPAIGN_ID = CAMPAIGNS_TL.CAMPAIGN_ID
AND STATUS_TL1.USER_STATUS_ID = CAMPAIGNS_B.USER_STATUS_ID
AND STATUS_TL2.USER_STATUS_ID = SCHEDULES_B.USER_STATUS_ID
AND SCHEDULES_TL.LANGUAGE = CAMPAIGNS_TL.LANGUAGE
AND SCHEDULES_TL.LANGUAGE = STATUS_TL1.LANGUAGE
AND SCHEDULES_TL.LANGUAGE = STATUS_TL2.LANGUAGE