[Home] [Help]
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
Name |
CAMPAIGN_ID |
CAMPAIGN_NAME |
DESCRIPTION |
CAMPAIGN_PURPOSE |
ROLLUP_TYPE |
STATUS_CODE |
STATUS_DATE |
SOURCE_CODE |
OWNER_USER_ID |
CASCADE_SOURCE_CODE_FLAG |
PARTNER_FLAG |
PARENT_CAMPAIGN_ID |
PRIORITY |
INBOUND_SCRIPT_NAME |
FUND_SOURCE_TYPE |
FUND_SOURCE_ID |
ACTUAL_EXEC_START_DATE |
ACTUAL_EXEC_END_DATE |
MEDIA_ID |
MEDIA_NAME |
MEDIA_TYPE_CODE |
MEDIA_TYPE_NAME |
CHANNEL_SOURCE |
CHANNEL_ID |
CHANNEL_NAME |
CHANNEL_TYPE |
CHANNEL_OUTBOUND_FLAG |
CHANNEL_INBOUND_FLAG |
INBOUND_URL |
INBOUND_EMAIL_ID |
INBOUND_PHONE_NO |
FF_PRIORITY |
FF_OVERRIDE_COVER_LETTER |
FF_SHIPPING_METHOD |
CONTENT_SOURCE |
CC_CALL_STRATEGY |
CC_MANAGER_USER_ID |