VIEW: APPS.AMS_P_CAMPAIGN_GEO_AREAS_V

Source

View Text - Preformatted

SELECT AGEO.ACT_GEO_AREA_USER_ID, CAMP.STATUS_CODE, CAMP.STATUS_DATE, CAMP.SOURCE_CODE, CAMP.ACTUAL_EXEC_START_DATE , CAMP.ACTUAL_EXEC_END_DATE, AGEO.GEO_TYPE_CODE, AGEO.GEO_TYPE_NAME, AGEO.GEO_HIERARCHY_ID, AGEO.GEO_AREA_NAME, CAMP.CAMPAIGN_NAME, CAMP.MEDIA_ID, CAMP.CHANNEL_ID from AMS_ACT_GEO_AREAS_V AGEO, AMS_CAMPAIGNS_VL CAMP WHERE AGEO.ACT_GEO_AREA_USER_ID = CAMP.CAMPAIGN_ID AND AGEO.ACT_GEO_AREA_USER = 'CAMP' AND CAMP.STATUS_CODE = 'ACTIVE' AND CAMP.ACTIVE_FLAG = 'Y' AND CAMP.SHOW_CAMPAIGN_FLAG = 'Y'

View Text - HTML Formatted

SELECT AGEO.ACT_GEO_AREA_USER_ID
, CAMP.STATUS_CODE
, CAMP.STATUS_DATE
, CAMP.SOURCE_CODE
, CAMP.ACTUAL_EXEC_START_DATE
, CAMP.ACTUAL_EXEC_END_DATE
, AGEO.GEO_TYPE_CODE
, AGEO.GEO_TYPE_NAME
, AGEO.GEO_HIERARCHY_ID
, AGEO.GEO_AREA_NAME
, CAMP.CAMPAIGN_NAME
, CAMP.MEDIA_ID
, CAMP.CHANNEL_ID
FROM AMS_ACT_GEO_AREAS_V AGEO
, AMS_CAMPAIGNS_VL CAMP
WHERE AGEO.ACT_GEO_AREA_USER_ID = CAMP.CAMPAIGN_ID
AND AGEO.ACT_GEO_AREA_USER = 'CAMP'
AND CAMP.STATUS_CODE = 'ACTIVE'
AND CAMP.ACTIVE_FLAG = 'Y'
AND CAMP.SHOW_CAMPAIGN_FLAG = 'Y'