Product: | AMS - Marketing |
---|---|
Description: | Holds the information for an agenda |
Implementation/DBA Data: | APPS.AMS_AGENDAS_V |
SELECT B.ROWID
, B.AGENDA_ID
, T.AGENDA_NAME
, B.AGENDA_TYPE
, B.SETUP_TYPE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.APPLICATION_ID
, B.ACTIVE_FLAG
, B.DEFAULT_TRACK_FLAG
, B.ROOM_ID
, V.VENUE_NAME
, B.PARENT_ID
, B.PARENT_TYPE
, B.START_DATE_TIME
, B.END_DATE_TIME
, B.TIMEZONE_ID
, HTZ.NAME
, B.COORDINATOR_ID
, HZ.PARTY_NAME
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, T.DESCRIPTION
FROM AMS_AGENDAS_B B
, AMS_AGENDAS_TL T
, HZ_PARTIES HZ
, HZ_TIMEZONES_VL HTZ
, AMS_VENUES_VL V
WHERE B.AGENDA_ID = T.AGENDA_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.COORDINATOR_ID = HZ.PARTY_ID(+)
AND B.TIMEZONE_ID = HTZ.TIMEZONE_ID(+)
AND B.ROOM_ID = V.VENUE_ID(+)