VIEW: APPS.AMS_SOURCE_CODES_DETAILS_V

Source

View Text - Preformatted

SELECT SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE, SOC.SOURCE_CODE_FOR_ID OBJECT_ID, CAMP.CAMPAIGN_NAME NAME, CAMP.DESCRIPTION DESCRIPTION, CAMP.PRIVATE_FLAG PRIVATE_FLAG, CAMP.CUSTOM_SETUP_ID from AMS_SOURCE_CODES SOC, AMS_CAMPAIGNS_VL CAMP WHERE SOC.ARC_SOURCE_CODE_FOR = 'CAMP' and SOC.SOURCE_CODE_FOR_ID = CAMP.CAMPAIGN_ID and SOC.ACTIVE_FLAG = 'Y' UNION ALL select SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE, SOC.SOURCE_CODE_FOR_ID OBJECT_ID, EVEH.EVENT_HEADER_NAME, EVEH.DESCRIPTION DESCRIPTION, EVEH.PRIVATE_FLAG PRIVATE_FLAG, EVEH.SETUP_TYPE_ID from AMS_SOURCE_CODES SOC, AMS_EVENT_HEADERS_VL EVEH where SOC.ARC_SOURCE_CODE_FOR = 'EVEH' and SOC.SOURCE_CODE_FOR_ID = EVEH.EVENT_HEADER_ID and SOC.ACTIVE_FLAG = 'Y' UNION ALL select SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE, SOC.SOURCE_CODE_FOR_ID OBJECT_ID, EVEO.EVENT_OFFER_NAME, EVEO.DESCRIPTION DESCRIPTION, EVEO.PRIVATE_FLAG PRIVATE_FLAG, EVEO.SETUP_TYPE_ID from AMS_SOURCE_CODES SOC, AMS_EVENT_OFFERS_VL EVEO where SOC.ARC_SOURCE_CODE_FOR = 'EVEO' and SOC.SOURCE_CODE_FOR_ID = EVEO.EVENT_OFFER_ID and SOC.ACTIVE_FLAG = 'Y' UNION ALL select SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE, SOC.SOURCE_CODE_FOR_ID OBJECT_ID, CHLS.SCHEDULE_NAME, CHLS.DESCRIPTION DESCRIPTION,'N' PRIVATE_FLAG, CHLS.CUSTOM_SETUP_ID from AMS_SOURCE_CODES SOC, AMS_CAMPAIGN_SCHEDULES_VL CHLS where SOC.ARC_SOURCE_CODE_FOR = 'CSCH' and SOC.SOURCE_CODE_FOR_ID = CHLS.SCHEDULE_ID and SOC.ACTIVE_FLAG = 'Y' UNION ALL select SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE, SOC.SOURCE_CODE_FOR_ID OBJECT_ID, qlh.NAME, qlh.DESCRIPTION DESCRIPTION,OFFR.confidential_flag PRIVATE_FLAG ,OFFR.CUSTOM_SETUP_ID from AMS_SOURCE_CODES SOC, AMS_OFFERS OFFR, QP_LIST_HEADERS_VL qlh where SOC.ARC_SOURCE_CODE_FOR = 'OFFR' and SOC.SOURCE_CODE_FOR_ID = qlh.list_header_id and qlh.list_header_id = OFFR.qp_list_header_id and SOC.ACTIVE_FLAG = 'Y' UNION ALL select SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE, SOC.SOURCE_CODE_FOR_ID OBJECT_ID, EVEO.EVENT_OFFER_NAME, EVEO.DESCRIPTION DESCRIPTION, EVEO.PRIVATE_FLAG PRIVATE_FLAG, EVEO.SETUP_TYPE_ID from AMS_SOURCE_CODES SOC, AMS_EVENT_OFFERS_VL EVEO where SOC.ARC_SOURCE_CODE_FOR = 'EONE' and SOC.SOURCE_CODE_FOR_ID = EVEO.EVENT_OFFER_ID and SOC.ACTIVE_FLAG = 'Y' and EVEO.PARENT_TYPE IS NULL

View Text - HTML Formatted

SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, CAMP.CAMPAIGN_NAME NAME
, CAMP.DESCRIPTION DESCRIPTION
, CAMP.PRIVATE_FLAG PRIVATE_FLAG
, CAMP.CUSTOM_SETUP_ID
FROM AMS_SOURCE_CODES SOC
, AMS_CAMPAIGNS_VL CAMP
WHERE SOC.ARC_SOURCE_CODE_FOR = 'CAMP'
AND SOC.SOURCE_CODE_FOR_ID = CAMP.CAMPAIGN_ID
AND SOC.ACTIVE_FLAG = 'Y' UNION ALL SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, EVEH.EVENT_HEADER_NAME
, EVEH.DESCRIPTION DESCRIPTION
, EVEH.PRIVATE_FLAG PRIVATE_FLAG
, EVEH.SETUP_TYPE_ID
FROM AMS_SOURCE_CODES SOC
, AMS_EVENT_HEADERS_VL EVEH
WHERE SOC.ARC_SOURCE_CODE_FOR = 'EVEH'
AND SOC.SOURCE_CODE_FOR_ID = EVEH.EVENT_HEADER_ID
AND SOC.ACTIVE_FLAG = 'Y' UNION ALL SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, EVEO.EVENT_OFFER_NAME
, EVEO.DESCRIPTION DESCRIPTION
, EVEO.PRIVATE_FLAG PRIVATE_FLAG
, EVEO.SETUP_TYPE_ID
FROM AMS_SOURCE_CODES SOC
, AMS_EVENT_OFFERS_VL EVEO
WHERE SOC.ARC_SOURCE_CODE_FOR = 'EVEO'
AND SOC.SOURCE_CODE_FOR_ID = EVEO.EVENT_OFFER_ID
AND SOC.ACTIVE_FLAG = 'Y' UNION ALL SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, CHLS.SCHEDULE_NAME
, CHLS.DESCRIPTION DESCRIPTION
, 'N' PRIVATE_FLAG
, CHLS.CUSTOM_SETUP_ID
FROM AMS_SOURCE_CODES SOC
, AMS_CAMPAIGN_SCHEDULES_VL CHLS
WHERE SOC.ARC_SOURCE_CODE_FOR = 'CSCH'
AND SOC.SOURCE_CODE_FOR_ID = CHLS.SCHEDULE_ID
AND SOC.ACTIVE_FLAG = 'Y' UNION ALL SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, QLH.NAME
, QLH.DESCRIPTION DESCRIPTION
, OFFR.CONFIDENTIAL_FLAG PRIVATE_FLAG
, OFFR.CUSTOM_SETUP_ID
FROM AMS_SOURCE_CODES SOC
, AMS_OFFERS OFFR
, QP_LIST_HEADERS_VL QLH
WHERE SOC.ARC_SOURCE_CODE_FOR = 'OFFR'
AND SOC.SOURCE_CODE_FOR_ID = QLH.LIST_HEADER_ID
AND QLH.LIST_HEADER_ID = OFFR.QP_LIST_HEADER_ID
AND SOC.ACTIVE_FLAG = 'Y' UNION ALL SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, EVEO.EVENT_OFFER_NAME
, EVEO.DESCRIPTION DESCRIPTION
, EVEO.PRIVATE_FLAG PRIVATE_FLAG
, EVEO.SETUP_TYPE_ID
FROM AMS_SOURCE_CODES SOC
, AMS_EVENT_OFFERS_VL EVEO
WHERE SOC.ARC_SOURCE_CODE_FOR = 'EONE'
AND SOC.SOURCE_CODE_FOR_ID = EVEO.EVENT_OFFER_ID
AND SOC.ACTIVE_FLAG = 'Y'
AND EVEO.PARENT_TYPE IS NULL