VIEW: APPS.ASO_I_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT AC.CAMPAIGN_ID , AC.CAMPAIGN_NAME , AC.DESCRIPTION , AC.CAMPAIGN_PURPOSE , AC.ROLLUP_TYPE , AC.STATUS_CODE , AC.STATUS_DATE , AC.SOURCE_CODE , AC.OWNER_USER_ID , AC.CASCADE_SOURCE_CODE_FLAG , AC.PARTNER_FLAG , AC.PARENT_CAMPAIGN_ID , AC.PRIORITY , AC.INBOUND_SCRIPT_NAME , AC.FUND_SOURCE_TYPE , AC.FUND_SOURCE_ID , AC.ACTUAL_EXEC_START_DATE , AC.ACTUAL_EXEC_END_DATE , AC.MEDIA_ID , AC.MEDIA_NAME , AC.MEDIA_TYPE_CODE , AC.MEDIA_TYPE_NAME , AC.CHANNEL_SOURCE , AC.CHANNEL_ID , AC.CHANNEL_NAME , AC.CHANNEL_TYPE , AC.CHANNEL_OUTBOUND_FLAG , AC.CHANNEL_INBOUND_FLAG , AC.INBOUND_URL , AC.INBOUND_EMAIL_ID , AC.INBOUND_PHONE_NO , AC.FF_PRIORITY , AC.FF_OVERRIDE_COVER_LETTER , AC.FF_SHIPPING_METHOD , AC.CONTENT_SOURCE , AC.CC_CALL_STRATEGY , AC.CC_MANAGER_USER_ID from AMS_P_CAMPAIGNS_V AC

View Text - HTML Formatted

SELECT AC.CAMPAIGN_ID
, AC.CAMPAIGN_NAME
, AC.DESCRIPTION
, AC.CAMPAIGN_PURPOSE
, AC.ROLLUP_TYPE
, AC.STATUS_CODE
, AC.STATUS_DATE
, AC.SOURCE_CODE
, AC.OWNER_USER_ID
, AC.CASCADE_SOURCE_CODE_FLAG
, AC.PARTNER_FLAG
, AC.PARENT_CAMPAIGN_ID
, AC.PRIORITY
, AC.INBOUND_SCRIPT_NAME
, AC.FUND_SOURCE_TYPE
, AC.FUND_SOURCE_ID
, AC.ACTUAL_EXEC_START_DATE
, AC.ACTUAL_EXEC_END_DATE
, AC.MEDIA_ID
, AC.MEDIA_NAME
, AC.MEDIA_TYPE_CODE
, AC.MEDIA_TYPE_NAME
, AC.CHANNEL_SOURCE
, AC.CHANNEL_ID
, AC.CHANNEL_NAME
, AC.CHANNEL_TYPE
, AC.CHANNEL_OUTBOUND_FLAG
, AC.CHANNEL_INBOUND_FLAG
, AC.INBOUND_URL
, AC.INBOUND_EMAIL_ID
, AC.INBOUND_PHONE_NO
, AC.FF_PRIORITY
, AC.FF_OVERRIDE_COVER_LETTER
, AC.FF_SHIPPING_METHOD
, AC.CONTENT_SOURCE
, AC.CC_CALL_STRATEGY
, AC.CC_MANAGER_USER_ID
FROM AMS_P_CAMPAIGNS_V AC