View: AST_MLIST1_ALL_UWQ_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_MLIST1_ALL_UWQ_V

View Text

SELECT '' IEU_OBJECT_FUNCTION
, '' IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, '' IEU_PARAM_PK_COL
, NULL IEU_PARAM_PK_VALUE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, CSCH.SCHEDULE_ID
, CSCH.SCHEDULE_NAME
, CSCH.STATUS_CODE
, CSCH.SOURCE_CODE
, CSCH.ACTIVITY_ID
, CSCH.ACTIVITY_TYPE_CODE
, CSCH.ARC_MARKETING_MEDIUM_FROM
, CSCH.CREATION_DATE
, CSCH.LAST_UPDATE_DATE
, CSCH.START_DATE_TIME
, CSCH.END_DATE_TIME
, 1 RESOURCE_ID
, ALH.LIST_SOURCE_TYPE
FROM AMS_CAMPAIGN_SCHEDULES_VL CSCH
, AMS_LIST_HEADERS_ALL ALH
, AMS_ACT_LISTS ACTS
WHERE CSCH.ACTIVE_FLAG = 'Y'
AND CSCH.ACTIVITY_ID = 460
AND CSCH.STATUS_CODE = 'ACTIVE'
AND TRUNC(SYSDATE) BETWEEN NVL(CSCH.START_DATE_TIME-1
, TRUNC(SYSDATE))
AND NVL(CSCH.END_DATE_TIME
, TRUNC(SYSDATE))
AND CSCH.SCHEDULE_ID = ACTS.LIST_USED_BY_ID
AND ACTS.LIST_USED_BY='CSCH'
AND ACTS.LIST_ACT_TYPE = 'TARGET'
AND ACTS.LIST_HEADER_ID = ALH.LIST_HEADER_ID

Columns