View: AST_CAMPAIGNS_LOV_V

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

View Text

SELECT C.SOURCE_CODE
, C.CAMPAIGN_NAME
, C.DESCRIPTION
, C.CAMPAIGN_ID
, S.SOURCE_CODE_ID
, C.DSCRIPT_NAME
FROM AMS_CAMPAIGNS_VL C
, AMS_SOURCE_CODES S
WHERE C.SOURCE_CODE = S.SOURCE_CODE
AND C.STATUS_CODE = 'ACTIVE'
AND C.ROLLUP_TYPE = 'ECAM'
AND C.ACTIVE_FLAG = 'Y'
AND C.PRIVATE_FLAG = 'N'
AND C.SHOW_CAMPAIGN_FLAG = 'Y'
AND C.TEMPLATE_FLAG = 'N'
AND S.SOURCE_CODE_FOR_ID = C.CAMPAIGN_ID
AND SYSDATE BETWEEN NVL(C.ACTUAL_EXEC_START_DATE
, SYSDATE) AND NVL(C.ACTUAL_EXEC_END_DATE
, SYSDATE) ORDER BY C.SOURCE_CODE

Columns