FND Design Data [Home] [Help]

View: OTA_BOOKING_STATUS_TYPES_VL

Product: OTA - Learning Management
Description: View to list all information about a Booking Status Type. It is scheduled for a future release.
Implementation/DBA Data: ViewAPPS.OTA_BOOKING_STATUS_TYPES_VL
View Text

SELECT BST.ROWID
, BST.BOOKING_STATUS_TYPE_ID
, BST.BUSINESS_GROUP_ID
, BST.DEFAULT_FLAG
, BST.ACTIVE_FLAG
, BST.PLACE_USED_FLAG
, BSL.NAME
, BST.OBJECT_VERSION_NUMBER
, BST.TYPE
, BST.COMMENTS
, BSL.DESCRIPTION
, BST.LAST_UPDATE_DATE
, BST.LAST_UPDATED_BY
, BST.LAST_UPDATE_LOGIN
, BST.CREATED_BY
, BST.CREATION_DATE
, BST.BST_INFORMATION_CATEGORY
, BST.BST_INFORMATION1
, BST.BST_INFORMATION2
, BST.BST_INFORMATION3
, BST.BST_INFORMATION4
, BST.BST_INFORMATION5
, BST.BST_INFORMATION6
, BST.BST_INFORMATION7
, BST.BST_INFORMATION8
, BST.BST_INFORMATION9
, BST.BST_INFORMATION10
, BST.BST_INFORMATION11
, BST.BST_INFORMATION12
, BST.BST_INFORMATION13
, BST.BST_INFORMATION14
, BST.BST_INFORMATION15
, BST.BST_INFORMATION16
, BST.BST_INFORMATION17
, BST.BST_INFORMATION18
, BST.BST_INFORMATION19
, BST.BST_INFORMATION20
FROM OTA_BOOKING_STATUS_TYPES BST
, OTA_BOOKING_STATUS_TYPES_TL BSL
WHERE BST.BOOKING_STATUS_TYPE_ID= BSL.BOOKING_STATUS_TYPE_ID
AND BSL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
BOOKING_STATUS_TYPE_ID
BUSINESS_GROUP_ID
DEFAULT_FLAG
ACTIVE_FLAG
PLACE_USED_FLAG
NAME
OBJECT_VERSION_NUMBER
TYPE
COMMENTS
DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
BST_INFORMATION_CATEGORY
BST_INFORMATION1
BST_INFORMATION2
BST_INFORMATION3
BST_INFORMATION4
BST_INFORMATION5
BST_INFORMATION6
BST_INFORMATION7
BST_INFORMATION8
BST_INFORMATION9
BST_INFORMATION10
BST_INFORMATION11
BST_INFORMATION12
BST_INFORMATION13
BST_INFORMATION14
BST_INFORMATION15
BST_INFORMATION16
BST_INFORMATION17
BST_INFORMATION18
BST_INFORMATION19
BST_INFORMATION20