View: ASO_I_CAMPAIGNS_V

Product:	ASO - Order Capture
Description:	View based on Campaigns
Implementation/DBA Data:	APPS.ASO_I_CAMPAIGNS_V

View Text

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

Columns