[Home] [Help]
View: AST_CAMPAIGN_LOV_V
View Text
SELECT SC.SOURCE_CODE_ID
, SC.SOURCE_CODE
, SC.NAME
, SC.OBJECT_ID
, SC.STATUS
, SC.SOURCE_TYPE
FROM AMS_P_SOURCE_CODES_V SC
WHERE SC.STATUS IN ('ACTIVE'
, 'ONHOLD'
, 'COMPLETED')
AND SC.SOURCE_TYPE IN ('EVEH'
, 'EVEO'
, 'CAMP'
, 'CSCH'
, 'OFFR'
, 'EONE')
Columns
Name |
SOURCE_CODE_ID |
SOURCE_CODE |
NAME |
OBJECT_ID |
STATUS |
SOURCE_TYPE |