VIEW: APPS.AMS_AGENDAS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)