View: BIM_DIMV_CAMPAIGNS

Product:	BIM - Marketing Intelligence
Description:	Shows all campaigns.
Implementation/DBA Data:	APPS.BIM_DIMV_CAMPAIGNS

View Text

SELECT TO_CHAR(AMC.CAMPAIGN_ID)
, SUBSTR(AMC.CAMPAIGN_NAME
, 1
, 80)
, AMC.CAMPAIGN_ID
, AMC.USER_STATUS_ID
, AMC.STATUS_CODE
, AMC.STATUS_DATE
, AMC.ROLLUP_TYPE
, AMC.SOURCE_CODE
, NVL( AMC.CAMPAIGN_TYPE
, '-999')
, AMC.CAMPAIGN_TYPE
, AMC.PARENT_CAMPAIGN_ID
, AMC.FORECASTED_EXEC_START_DATE
, AMC.FORECASTED_EXEC_END_DATE
, AMC.ACTUAL_EXEC_START_DATE
, AMC.ACTUAL_EXEC_END_DATE
, AMC.CAMPAIGN_NAME
, AMC.DESCRIPTION
, AUS.NAME
, AUS.DESCRIPTION
FROM AMS_CAMPAIGNS_VL AMC
, AMS_USER_STATUSES_VL AUSWHERE AMC.USER_STATUS_ID = AUS.USER_STATUS_ID
AND SHOW_CAMPAIGN_FLAG = 'Y' UNION ALL SELECT '-999'
, MEANING
, -999
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, '-999'
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, MEANING
, NULL
, NULL
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY

Columns