VIEW: APPS.AMS_P_CAMPAIGN_SCHEDS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'