View: OTA_BOOKING_STATUS_HISTORIES_V

Product:	OTA - Learning Management
Description:	View to list all information about a Students Booking Status History.
Implementation/DBA Data:	APPS.OTA_BOOKING_STATUS_HISTORIES_V

View Text

SELECT BSH.ROWID
, BSH.BOOKING_ID
, BSH.BOOKING_STATUS_TYPE_ID
, BSL.NAME
, BST.TYPE
, BSH.OBJECT_VERSION_NUMBER
, BSH.START_DATE
, BSH.CHANGED_BY
, BSH.COMMENTS
FROM OTA_BOOKING_STATUS_HISTORIES BSH
, OTA_BOOKING_STATUS_TYPES BST
, OTA_BOOKING_STATUS_TYPES_TL BSL
WHERE BST.BOOKING_STATUS_TYPE_ID = BSH.BOOKING_STATUS_TYPE_ID
AND BSL.BOOKING_STATUS_TYPE_ID = BST.BOOKING_STATUS_TYPE_ID
AND BSL.LANGUAGE= USERENV('LANG')

Columns