VIEW: APPS.AMS_P_CAMPAIGN_PRODUCTS_V

Source

View Text - Preformatted

SELECT AAP.ACTIVITY_PRODUCT_ID , AAP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AAP.MASTER_OBJECT_ID CAMPAIGN_ID, CAM.CAMPAIGN_NAME , CAM.STATUS_CODE CAMPAIGN_STATUS_CODE, CAM.STATUS_DATE CAMPAIGN_STATUS_DATE, CAM.SOURCE_CODE CAMPAIGN_SOURCE_CODE, CAM.ACTUAL_EXEC_START_DATE ACTUAL_START_DATE, CAM.ACTUAL_EXEC_END_DATE ACTUAL_END_DATE, CAM.CAMPAIGN_TYPE, AAP.LEVEL_TYPE_CODE , AAP.LEVEL_TYPE , AAP.CATEGORY_ID , AAP.CATEGORY_NAME , AAP.CATEGORY_SET_ID , AAP.CATEGORY_SET_NAME , AAP.ORGANIZATION_ID , AAP.INVENTORY_ITEM_ID , AAP.INVENTORY_ITEM_NUMBER , AAP.INVENTORY_ITEM_DESCRIPTION, AAP.EXCLUDED_FLAG FROM AMS_CAMPAIGNS_VL CAM, AMS_ACT_PRODUCTS_V AAP WHERE CAM.CAMPAIGN_ID = AAP.MASTER_OBJECT_ID AND AAP.MASTER_OBJECT_TYPE = 'CAMP' AND CAM.STATUS_CODE = 'ACTIVE' AND CAM.ACTIVE_FLAG = 'Y' AND CAM.SHOW_CAMPAIGN_FLAG = 'Y'

View Text - HTML Formatted

SELECT AAP.ACTIVITY_PRODUCT_ID
, AAP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AAP.MASTER_OBJECT_ID CAMPAIGN_ID
, CAM.CAMPAIGN_NAME
, CAM.STATUS_CODE CAMPAIGN_STATUS_CODE
, CAM.STATUS_DATE CAMPAIGN_STATUS_DATE
, CAM.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, CAM.ACTUAL_EXEC_START_DATE ACTUAL_START_DATE
, CAM.ACTUAL_EXEC_END_DATE ACTUAL_END_DATE
, CAM.CAMPAIGN_TYPE
, AAP.LEVEL_TYPE_CODE
, AAP.LEVEL_TYPE
, AAP.CATEGORY_ID
, AAP.CATEGORY_NAME
, AAP.CATEGORY_SET_ID
, AAP.CATEGORY_SET_NAME
, AAP.ORGANIZATION_ID
, AAP.INVENTORY_ITEM_ID
, AAP.INVENTORY_ITEM_NUMBER
, AAP.INVENTORY_ITEM_DESCRIPTION
, AAP.EXCLUDED_FLAG
FROM AMS_CAMPAIGNS_VL CAM
, AMS_ACT_PRODUCTS_V AAP
WHERE CAM.CAMPAIGN_ID = AAP.MASTER_OBJECT_ID
AND AAP.MASTER_OBJECT_TYPE = 'CAMP'
AND CAM.STATUS_CODE = 'ACTIVE'
AND CAM.ACTIVE_FLAG = 'Y'
AND CAM.SHOW_CAMPAIGN_FLAG = 'Y'