VIEW: APPS.OTA_BOOKING_STATUS_TYPES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')