View: AMS_P_CAMPAIGN_SCHEDS_V

Product:	AMS - Marketing
Description:	This public view returns the campaign schedule information..
Implementation/DBA Data:	APPS.AMS_P_CAMPAIGN_SCHEDS_V

View Text

SELECT B.SCHEDULE_ID
, B.CAMPAIGN_ID
, CAM.CAMPAIGN_NAME
, CAM.CAMPAIGN_TYPE
, CAM.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, LKP.MEANING SCHEDULE_STATUS
, B.STATUS_CODE
, B.STATUS_DATE
, B.USE_PARENT_CODE_FLAG
, B.SOURCE_CODE SCHEDULE_SOURCE_CODE
, B.ACTIVITY_TYPE_CODE
, LKP1.MEANING
, B.ACTIVITY_ID
, M.MEDIA_NAME
, B.ARC_MARKETING_MEDIUM_FROM
, B.MARKETING_MEDIUM_ID
, CH.CHANNEL_NAME
, NULL
, NULL
, B.START_PERIOD_NAME
, B.END_PERIOD_NAME
, B.START_DATE_TIME
, B.END_DATE_TIME
, B.TIMEZONE_ID
, HZ.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, B.COVER_LETTER_ID
, B.REPLY_TO_MAIL
, B.MAIL_SENDER_NAME
, B.MAIL_SUBJECT
, B.FROM_FAX_NO
, B.CUSTOM_SETUP_ID
, B.TRIGGERABLE_FLAG
, B.TRIGGER_ID
, B.NOTIFY_USER_ID
, B.APPROVER_USER_ID
, B.OWNER_USER_ID
, B.PRIORITY
, B.TRANSACTION_CURRENCY_CODE
, B.FUNCTIONAL_CURRENCY_CODE
, B.BUDGET_AMOUNT_TC
, B.BUDGET_AMOUNT_FC
, B.LANGUAGE_CODE
, B.TASK_ID
, B.RELATED_EVENT_FROM
, B.RELATED_EVENT_ID
, NULL
, B.COUNTRY_ID
, B.DESCRIPTION
FROM AMS_CAMPAIGN_SCHEDULES_VL B
, AMS_LOOKUPS LKP
, AMS_CAMPAIGNS_VL CAM
, HZ_TIMEZONES_TL HZ
, AMS_LOOKUPS LKP1
, AMS_MEDIA_TL M
, AMS_CHANNELS_TL CH
WHERE B.ACTIVE_FLAG = 'Y'
AND LKP.LOOKUP_TYPE = 'AMS_CAMPAIGN_SCHEDULE_STATUS'
AND LKP.LOOKUP_CODE = B.STATUS_CODE
AND LKP1.LOOKUP_TYPE = 'AMS_MEDIA_TYPE'
AND LKP1.LOOKUP_CODE = B.ACTIVITY_TYPE_CODE
AND B.CAMPAIGN_ID = CAM.CAMPAIGN_ID
AND CAM.SHOW_CAMPAIGN_FLAG = 'Y'
AND CAM.ACTIVE_FLAG = 'Y'
AND HZ.TIMEZONE_ID = B.TIMEZONE_ID
AND HZ.LANGUAGE = USERENV('LANG')
AND B.ACTIVITY_ID = M.MEDIA_ID
AND M.LANGUAGE = USERENV('LANG')
AND B.ACTIVITY_TYPE_CODE <> 'EVENTS'
AND B.MARKETING_MEDIUM_ID = CH.CHANNEL_ID(+)
AND CH.LANGUAGE(+) = USERENV('LANG') UNION SELECT B.SCHEDULE_ID
, B.CAMPAIGN_ID
, CAM.CAMPAIGN_NAME
, CAM.CAMPAIGN_TYPE
, CAM.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, LKP.MEANING SCHEDULE_STATUS
, B.STATUS_CODE
, B.STATUS_DATE
, B.USE_PARENT_CODE_FLAG
, B.SOURCE_CODE SCHEDULE_SOURCE_CODE
, B.ACTIVITY_TYPE_CODE
, LKP1.MEANING
, B.ACTIVITY_ID
, NULL
, B.ARC_MARKETING_MEDIUM_FROM
, B.MARKETING_MEDIUM_ID
, NULL
, NULL
, NULL
, B.START_PERIOD_NAME
, B.END_PERIOD_NAME
, B.START_DATE_TIME
, B.END_DATE_TIME
, B.TIMEZONE_ID
, HZ.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, B.COVER_LETTER_ID
, B.REPLY_TO_MAIL
, B.MAIL_SENDER_NAME
, B.MAIL_SUBJECT
, B.FROM_FAX_NO
, B.CUSTOM_SETUP_ID
, B.TRIGGERABLE_FLAG
, B.TRIGGER_ID
, B.NOTIFY_USER_ID
, B.APPROVER_USER_ID
, B.OWNER_USER_ID
, B.PRIORITY
, B.TRANSACTION_CURRENCY_CODE
, B.FUNCTIONAL_CURRENCY_CODE
, B.BUDGET_AMOUNT_TC
, B.BUDGET_AMOUNT_FC
, B.LANGUAGE_CODE
, B.TASK_ID
, B.RELATED_EVENT_FROM
, B.RELATED_EVENT_ID
, EV.EVENT_OFFER_NAME
, B.COUNTRY_ID
, B.DESCRIPTION
FROM AMS_CAMPAIGN_SCHEDULES_VL B
, AMS_LOOKUPS LKP
, AMS_CAMPAIGNS_VL CAM
, HZ_TIMEZONES_TL HZ
, AMS_LOOKUPS LKP1
, AMS_EVENT_OFFERS_VL EV
WHERE B.ACTIVE_FLAG = 'Y'
AND LKP.LOOKUP_TYPE = 'AMS_CAMPAIGN_SCHEDULE_STATUS'
AND LKP.LOOKUP_CODE = B.STATUS_CODE
AND LKP1.LOOKUP_TYPE = 'AMS_MEDIA_TYPE'
AND LKP1.LOOKUP_CODE = B.ACTIVITY_TYPE_CODE
AND B.CAMPAIGN_ID = CAM.CAMPAIGN_ID
AND CAM.SHOW_CAMPAIGN_FLAG = 'Y'
AND CAM.ACTIVE_FLAG = 'Y'
AND HZ.TIMEZONE_ID = B.TIMEZONE_ID
AND HZ.LANGUAGE = USERENV('LANG')
AND B.ACTIVITY_TYPE_CODE = 'EVENTS'
AND EV.EVENT_OFFER_ID = B.RELATED_EVENT_ID
AND EV.EVENT_OBJECT_TYPE = 'EONE'
AND B.RELATED_EVENT_FROM = 'EONE'

Columns