View: AST_SOURCE_ONLY_V

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

View Text

SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, CAMP.CAMPAIGN_NAME NAME
, CAMP.STATUS_CODE STATUS
, CAMP.ACTUAL_EXEC_START_DATE START_DATE
, CAMP.ACTUAL_EXEC_END_DATE END_DATE
, CAMP.INBOUND_URL
, CAMP.INBOUND_EMAIL_ID
, CAMP.INBOUND_PHONE_NO
, SOC.RELATED_SOURCE_CODE
, SOC.RELATED_SOURCE_OBJECT
, SOC.RELATED_SOURCE_ID
FROM AMS_SOURCE_CODES SOC
, AMS_CAMPAIGNS_VL CAMP
WHERE SOC.ARC_SOURCE_CODE_FOR = 'CAMP'
AND SOC.ACTIVE_FLAG = 'Y'
AND SOC.SOURCE_CODE_FOR_ID = CAMP.CAMPAIGN_ID UNION ALL SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, EVEH.EVENT_HEADER_NAME
, EVEH.SYSTEM_STATUS_CODE
, EVEH.ACTIVE_FROM_DATE
, EVEH.ACTIVE_TO_DATE
, EVEH.URL
, EVEH.EMAIL
, EVEH.PHONE
, SOC.RELATED_SOURCE_CODE
, SOC.RELATED_SOURCE_OBJECT
, SOC.RELATED_SOURCE_ID
FROM AMS_SOURCE_CODES SOC
, AMS_EVENT_HEADERS_VL EVEH
WHERE SOC.ARC_SOURCE_CODE_FOR = 'EVEH'
AND SOC.ACTIVE_FLAG = 'Y'
AND SOC.SOURCE_CODE_FOR_ID = EVEH.EVENT_HEADER_ID UNION ALL SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, EVEO.EVENT_OFFER_NAME
, EVEO.SYSTEM_STATUS_CODE
, EVEO.EVENT_START_DATE
, EVEO.EVENT_END_DATE
, EVEO.URL
, EVEO.EMAIL
, EVEO.PHONE
, SOC.RELATED_SOURCE_CODE
, SOC.RELATED_SOURCE_OBJECT
, SOC.RELATED_SOURCE_ID
FROM AMS_SOURCE_CODES SOC
, AMS_EVENT_OFFERS_VL EVEO
WHERE SOC.ARC_SOURCE_CODE_FOR = 'EVEO'
AND SOC.ACTIVE_FLAG = 'Y'
AND SOC.SOURCE_CODE_FOR_ID = EVEO.EVENT_OFFER_ID UNION ALL SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, CHLS.SCHEDULE_NAME
, CHLS.STATUS_CODE
, CHLS.START_DATE_TIME
, CHLS.END_DATE_TIME
, NULL
, NULL
, NULL
, SOC.RELATED_SOURCE_CODE
, SOC.RELATED_SOURCE_OBJECT
, SOC.RELATED_SOURCE_ID
FROM AMS_SOURCE_CODES SOC
, AMS_CAMPAIGN_SCHEDULES_VL CHLS
, AMS_CAMPAIGNS_VL CAMP
WHERE SOC.ARC_SOURCE_CODE_FOR = 'CSCH'
AND SOC.ACTIVE_FLAG = 'Y'
AND SOC.SOURCE_CODE_FOR_ID = CHLS.SCHEDULE_ID
AND CHLS.CAMPAIGN_ID = CAMP.CAMPAIGN_ID

Columns