VIEW: APPS.BIM_DIMV_CAMPAIGNS

Source

View Text - Preformatted

SELECT TO_CHAR(AMC.SOURCE_CODE_ID) , SUBSTR(AMC.NAME,1,80) , AMC.SOURCE_CODE_ID , TO_NUMBER(NULL) , NULL , TO_DATE(NULL) , NULL , NULL , NULL , NULL , TO_NUMBER(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , AMC.NAME , NULL , NULL , NULL FROM AMS_SOURCE_CODES_DETAILS_V AMC WHERE SOURCE_TYPE NOT IN ('OFFR') UNION ALL SELECT TO_CHAR(AMC.SOURCE_CODE_ID) , SUBSTR(AV.CAMPAIGN_NAME,1,80) , AMC.SOURCE_CODE_ID , TO_NUMBER(NULL) , NULL , TO_DATE(NULL) , NULL , NULL , NULL , NULL , TO_NUMBER(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , AV.CAMPAIGN_NAME , NULL , NULL , NULL FROM BIM_I_SOURCE_CODES AMC, AMS_CAMPAIGNS_VL AV WHERE OBJECT_TYPE IN ('RCAM') AND AMC.OBJECT_ID = AV.CAMPAIGN_ID 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

View Text - HTML Formatted

SELECT TO_CHAR(AMC.SOURCE_CODE_ID)
, SUBSTR(AMC.NAME
, 1
, 80)
, AMC.SOURCE_CODE_ID
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, AMC.NAME
, NULL
, NULL
, NULL
FROM AMS_SOURCE_CODES_DETAILS_V AMC
WHERE SOURCE_TYPE NOT IN ('OFFR') UNION ALL SELECT TO_CHAR(AMC.SOURCE_CODE_ID)
, SUBSTR(AV.CAMPAIGN_NAME
, 1
, 80)
, AMC.SOURCE_CODE_ID
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, AV.CAMPAIGN_NAME
, NULL
, NULL
, NULL
FROM BIM_I_SOURCE_CODES AMC
, AMS_CAMPAIGNS_VL AV
WHERE OBJECT_TYPE IN ('RCAM')
AND AMC.OBJECT_ID = AV.CAMPAIGN_ID 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