VIEW: APPS.OTA_USER_GROUPS_VL

Source

View Text - Preformatted

SELECT UGB.USER_GROUP_ID , UGTL.USER_GROUP_NAME , UGTL.DESCRIPTION , UGB.BUSINESS_GROUP_ID , UGB.START_DATE_ACTIVE , UGB.END_DATE_ACTIVE , UGB.USER_GROUP_OPERATOR , UGB.OBJECT_VERSION_NUMBER, UGB.CREATED_BY , UGB.CREATION_DATE , UGB.LAST_UPDATE_DATE , UGB.LAST_UPDATED_BY , UGB.LAST_UPDATE_LOGIN , UGB.ATTRIBUTE_CATEGORY , UGB.ATTRIBUTE1 , UGB.ATTRIBUTE2 , UGB.ATTRIBUTE3 , UGB.ATTRIBUTE4 , UGB.ATTRIBUTE5 , UGB.ATTRIBUTE6 , UGB.ATTRIBUTE7 , UGB.ATTRIBUTE8 , UGB.ATTRIBUTE9 , UGB.ATTRIBUTE10 , UGB.ATTRIBUTE11 , UGB.ATTRIBUTE12 , UGB.ATTRIBUTE13 , UGB.ATTRIBUTE14 , UGB.ATTRIBUTE15 , UGB.ATTRIBUTE16 , UGB.ATTRIBUTE17 , UGB.ATTRIBUTE18 , UGB.ATTRIBUTE19 , UGB.ATTRIBUTE20, UGB.USER_GROUP_TYPE FROM OTA_USER_GROUPS_B UGB, OTA_USER_GROUPS_TL UGTL WHERE UGB.USER_GROUP_ID = UGTL.USER_GROUP_ID AND UGTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT UGB.USER_GROUP_ID
, UGTL.USER_GROUP_NAME
, UGTL.DESCRIPTION
, UGB.BUSINESS_GROUP_ID
, UGB.START_DATE_ACTIVE
, UGB.END_DATE_ACTIVE
, UGB.USER_GROUP_OPERATOR
, UGB.OBJECT_VERSION_NUMBER
, UGB.CREATED_BY
, UGB.CREATION_DATE
, UGB.LAST_UPDATE_DATE
, UGB.LAST_UPDATED_BY
, UGB.LAST_UPDATE_LOGIN
, UGB.ATTRIBUTE_CATEGORY
, UGB.ATTRIBUTE1
, UGB.ATTRIBUTE2
, UGB.ATTRIBUTE3
, UGB.ATTRIBUTE4
, UGB.ATTRIBUTE5
, UGB.ATTRIBUTE6
, UGB.ATTRIBUTE7
, UGB.ATTRIBUTE8
, UGB.ATTRIBUTE9
, UGB.ATTRIBUTE10
, UGB.ATTRIBUTE11
, UGB.ATTRIBUTE12
, UGB.ATTRIBUTE13
, UGB.ATTRIBUTE14
, UGB.ATTRIBUTE15
, UGB.ATTRIBUTE16
, UGB.ATTRIBUTE17
, UGB.ATTRIBUTE18
, UGB.ATTRIBUTE19
, UGB.ATTRIBUTE20
, UGB.USER_GROUP_TYPE
FROM OTA_USER_GROUPS_B UGB
, OTA_USER_GROUPS_TL UGTL
WHERE UGB.USER_GROUP_ID = UGTL.USER_GROUP_ID
AND UGTL.LANGUAGE = USERENV('LANG')