eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BIM_DIMV_EVENT_OFFERS

Source

View Text - Preformatted


SELECT 'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) ID ,SUBSTR(EVTO.EVENT_OFFER_NAME,1,80) VALUE ,'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) EVENT_OFFER_ID ,EVTO.EVENT_OFFER_NAME EVENT_OFFER_NAME ,EVTO.DESCRIPTION EVENT_OFFER_DESCRIPTION ,'EVEH' || TO_CHAR(EVTO.EVENT_HEADER_ID) EVENT_HEADER_ID ,decode(EVTO.PARENT_EVENT_OFFER_ID , null , null , 'EVEO' || TO_CHAR(EVTO.PARENT_EVENT_OFFER_ID) ) PARENT_EVENT_OFFER_ID ,EVTO.SOURCE_CODE EVENT_OFFER_SOURCE_CODE ,EVTO.SYSTEM_STATUS_CODE EVENT_OFFER_STATUS_CODE ,EVTO.LAST_STATUS_DATE EVENT_OFFER_STATUS_DATE ,EVTO.ACTIVE_FLAG EVENT_OFFER_ACTIVE_FLAG ,EVTO.REG_REQUIRED_FLAG REG_REQUIRED_FLAG ,EVTO.EVENT_LANGUAGE_CODE EVENT_LANGUAGE_CODE ,UPPER(hzl.country||'>>'||hzl.state||'>>'||hzl.city||'>>'||hzl.postal_code) EVENT_LOCATION_CODE ,EVTO.EVENT_STANDALONE_FLAG EVENT_STAND_ALONE_FLAG ,decode(EVTO.PARENT_EVENT_OFFER_ID , null , null , 'EVEO' || TO_CHAR(EVTO.PARENT_EVENT_OFFER_ID)) MAIN_EVENT_OFFER_ID ,EVTO.EVENT_DURATION EVENT_OFFER_DURATION ,EVTO.EVENT_START_DATE EVENT_OFFER_START_DATE ,EVTO.EVENT_END_DATE EVENT_OFFER_END_DATE ,EVTO.REG_START_DATE REG_START_DATE ,EVTO.REG_END_DATE REG_END_DATE ,EVTO.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,NULL ORG_ID FROM AMS_EVENT_OFFERS_VL EVTO, HZ_LOCATIONS HZL WHERE EVTO.EVENT_LEVEL = 'MAIN' AND EVTO.EVENT_LOCATION_ID = HZL.LOCATION_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT 'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) ID
, SUBSTR(EVTO.EVENT_OFFER_NAME
, 1
, 80) VALUE
, 'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) EVENT_OFFER_ID
, EVTO.EVENT_OFFER_NAME EVENT_OFFER_NAME
, EVTO.DESCRIPTION EVENT_OFFER_DESCRIPTION
, 'EVEH' || TO_CHAR(EVTO.EVENT_HEADER_ID) EVENT_HEADER_ID
, DECODE(EVTO.PARENT_EVENT_OFFER_ID
, NULL
, NULL
, 'EVEO' || TO_CHAR(EVTO.PARENT_EVENT_OFFER_ID) ) PARENT_EVENT_OFFER_ID
, EVTO.SOURCE_CODE EVENT_OFFER_SOURCE_CODE
, EVTO.SYSTEM_STATUS_CODE EVENT_OFFER_STATUS_CODE
, EVTO.LAST_STATUS_DATE EVENT_OFFER_STATUS_DATE
, EVTO.ACTIVE_FLAG EVENT_OFFER_ACTIVE_FLAG
, EVTO.REG_REQUIRED_FLAG REG_REQUIRED_FLAG
, EVTO.EVENT_LANGUAGE_CODE EVENT_LANGUAGE_CODE
, UPPER(HZL.COUNTRY||'>>'||HZL.STATE||'>>'||HZL.CITY||'>>'||HZL.POSTAL_CODE) EVENT_LOCATION_CODE
, EVTO.EVENT_STANDALONE_FLAG EVENT_STAND_ALONE_FLAG
, DECODE(EVTO.PARENT_EVENT_OFFER_ID
, NULL
, NULL
, 'EVEO' || TO_CHAR(EVTO.PARENT_EVENT_OFFER_ID)) MAIN_EVENT_OFFER_ID
, EVTO.EVENT_DURATION EVENT_OFFER_DURATION
, EVTO.EVENT_START_DATE EVENT_OFFER_START_DATE
, EVTO.EVENT_END_DATE EVENT_OFFER_END_DATE
, EVTO.REG_START_DATE REG_START_DATE
, EVTO.REG_END_DATE REG_END_DATE
, EVTO.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, NULL ORG_ID
FROM AMS_EVENT_OFFERS_VL EVTO
, HZ_LOCATIONS HZL
WHERE EVTO.EVENT_LEVEL = 'MAIN'
AND EVTO.EVENT_LOCATION_ID = HZL.LOCATION_ID (+) WITH READ ONLY