[Home] [Help]
View: AMS_DLG_EVENT_INFO_VL
Product: | AMS - Marketing |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT E.EVENT_OFFER_ID
, E.EVENT_OFFER_NAME
, E.SOURCE_CODE
, E.DESCRIPTION
, TO_CHAR(E.EVENT_START_DATE_TIME
, 'MM/DD/YY DAY HH:MI:SS PM')
, TO_CHAR(E.EVENT_END_DATE_TIME
, 'MM/DD/YY DAY HH:MI:SS PM')
, V.VENUE_NAME
, V.ADDRESS1
, V.ADDRESS2
, V.ADDRESS3
, V.CITY
, V.STATE
, V.COUNTRY
, V.POSTAL_CODE
FROM AMS_EVENT_OFFERS_VL E
, AMS_VENUES_V V
WHERE E.EVENT_VENUE_ID = V.VENUE_ID (+)
Columns
Name |
EVENT_OFFER_ID |
EVENT_OFFER_NAME |
SOURCE_CODE |
DESCRIPTION |
START_TIME |
END_TIME |
VENUE |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
CITY |
STATE |
COUNTRY |
ZIPCODE |