VIEW: APPS.AST_CAMPAIGNS_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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