VIEW: APPS.AMS_EVENT_OFFERS_OV_V

Source

View Text - Preformatted

SELECT EVO.ROW_ID , EVO.EVENT_TYPE_CODE , LKUP4.MEANING EVENT_TYPE , EVO.OWNER_USER_ID , EVO.EVENT_OFFER_ID , EVO.LAST_UPDATE_DATE , EVO.LAST_UPDATED_BY , EVO.CREATION_DATE , EVO.CREATED_BY , EVO.LAST_UPDATE_LOGIN , EVO.OBJECT_VERSION_NUMBER , EVO.APPLICATION_ID , EVO.EVENT_HEADER_ID , EVH.EVENT_HEADER_NAME , EVO.PRIVATE_FLAG , EVO.ACTIVE_FLAG , EVO.EVENT_LEVEL , EVO.USER_STATUS_ID , AUS.NAME , EVO.LAST_STATUS_DATE , EVO.SYSTEM_STATUS_CODE , EVO.EVENT_LANGUAGE_CODE , LANG.NLS_LANGUAGE , EVO.EVENT_LOCATION_ID , HZL.CITY||', '||HZL.STATE||', '||HZL.COUNTRY , HZL.CITY , HZL.STATE , HZL.PROVINCE , HZL.COUNTRY , EVO.EVENT_START_DATE , EVO.EVENT_START_DATE_TIME , EVO.EVENT_END_DATE , EVO.EVENT_END_DATE_TIME , EVO.EVENT_OFFER_NAME , EVO.DESCRIPTION , EVO.COUNTRY_CODE , EVO.BUSINESS_UNIT_ID from AMS_EVENT_OFFERS_VL EVO, AMS_EVENT_HEADERS_VL EVH, AMS_USER_STATUSES_VL AUS, FND_LANGUAGES_VL LANG, HZ_LOCATIONS HZL, AMS_LOOKUPS LKUP4 WHERE EVO.EVENT_LEVEL='MAIN' AND EVO.EVENT_HEADER_ID=EVH.EVENT_HEADER_ID AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID AND EVO.EVENT_LANGUAGE_CODE=LANG.LANGUAGE_CODE(+) AND LKUP4.LOOKUP_TYPE(+)='AMS_EVENT_TYPE' AND LKUP4.LOOKUP_CODE(+)=EVO.EVENT_TYPE_CODE AND EVO.EVENT_LOCATION_ID=HZL.LOCATION_ID(+)

View Text - HTML Formatted

SELECT EVO.ROW_ID
, EVO.EVENT_TYPE_CODE
, LKUP4.MEANING EVENT_TYPE
, EVO.OWNER_USER_ID
, EVO.EVENT_OFFER_ID
, EVO.LAST_UPDATE_DATE
, EVO.LAST_UPDATED_BY
, EVO.CREATION_DATE
, EVO.CREATED_BY
, EVO.LAST_UPDATE_LOGIN
, EVO.OBJECT_VERSION_NUMBER
, EVO.APPLICATION_ID
, EVO.EVENT_HEADER_ID
, EVH.EVENT_HEADER_NAME
, EVO.PRIVATE_FLAG
, EVO.ACTIVE_FLAG
, EVO.EVENT_LEVEL
, EVO.USER_STATUS_ID
, AUS.NAME
, EVO.LAST_STATUS_DATE
, EVO.SYSTEM_STATUS_CODE
, EVO.EVENT_LANGUAGE_CODE
, LANG.NLS_LANGUAGE
, EVO.EVENT_LOCATION_ID
, HZL.CITY||'
, '||HZL.STATE||'
, '||HZL.COUNTRY
, HZL.CITY
, HZL.STATE
, HZL.PROVINCE
, HZL.COUNTRY
, EVO.EVENT_START_DATE
, EVO.EVENT_START_DATE_TIME
, EVO.EVENT_END_DATE
, EVO.EVENT_END_DATE_TIME
, EVO.EVENT_OFFER_NAME
, EVO.DESCRIPTION
, EVO.COUNTRY_CODE
, EVO.BUSINESS_UNIT_ID
FROM AMS_EVENT_OFFERS_VL EVO
, AMS_EVENT_HEADERS_VL EVH
, AMS_USER_STATUSES_VL AUS
, FND_LANGUAGES_VL LANG
, HZ_LOCATIONS HZL
, AMS_LOOKUPS LKUP4
WHERE EVO.EVENT_LEVEL='MAIN'
AND EVO.EVENT_HEADER_ID=EVH.EVENT_HEADER_ID
AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID
AND EVO.EVENT_LANGUAGE_CODE=LANG.LANGUAGE_CODE(+)
AND LKUP4.LOOKUP_TYPE(+)='AMS_EVENT_TYPE'
AND LKUP4.LOOKUP_CODE(+)=EVO.EVENT_TYPE_CODE
AND EVO.EVENT_LOCATION_ID=HZL.LOCATION_ID(+)