VIEW: APPS.OKC_FOLDERS_VL

Source

View Text - Preformatted

SELECT FOLD.FOLDER_ID, FOLD.OBJECT_VERSION_NUMBER, FOLD.ORG_ID, FOLD.SAT_CODE, FOLD.CREATED_BY, FOLD.CREATION_DATE, FOLD.LAST_UPDATE_DATE, FOLD.LAST_UPDATED_BY, FOLD.LAST_UPDATE_LOGIN, FOLD.ATTRIBUTE_CATEGORY, FOLD.ATTRIBUTE1, FOLD.ATTRIBUTE2, FOLD.ATTRIBUTE3, FOLD.ATTRIBUTE4, FOLD.ATTRIBUTE5, FOLD.ATTRIBUTE6, FOLD.ATTRIBUTE7, FOLD.ATTRIBUTE8, FOLD.ATTRIBUTE9, FOLD.ATTRIBUTE10, FOLD.ATTRIBUTE11, FOLD.ATTRIBUTE12, FOLD.ATTRIBUTE13, FOLD.ATTRIBUTE14, FOLD.ATTRIBUTE15, FOLDT.LANGUAGE, FOLDT.SOURCE_LANG, FOLDT.FOLDER_NAME, FOLDT.DESCRIPTION FROM OKC_FOLDERS_B FOLD, OKC_FOLDERS_TL FOLDT WHERE FOLD.FOLDER_ID = FOLDT.FOLDER_ID AND FOLDT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT FOLD.FOLDER_ID
, FOLD.OBJECT_VERSION_NUMBER
, FOLD.ORG_ID
, FOLD.SAT_CODE
, FOLD.CREATED_BY
, FOLD.CREATION_DATE
, FOLD.LAST_UPDATE_DATE
, FOLD.LAST_UPDATED_BY
, FOLD.LAST_UPDATE_LOGIN
, FOLD.ATTRIBUTE_CATEGORY
, FOLD.ATTRIBUTE1
, FOLD.ATTRIBUTE2
, FOLD.ATTRIBUTE3
, FOLD.ATTRIBUTE4
, FOLD.ATTRIBUTE5
, FOLD.ATTRIBUTE6
, FOLD.ATTRIBUTE7
, FOLD.ATTRIBUTE8
, FOLD.ATTRIBUTE9
, FOLD.ATTRIBUTE10
, FOLD.ATTRIBUTE11
, FOLD.ATTRIBUTE12
, FOLD.ATTRIBUTE13
, FOLD.ATTRIBUTE14
, FOLD.ATTRIBUTE15
, FOLDT.LANGUAGE
, FOLDT.SOURCE_LANG
, FOLDT.FOLDER_NAME
, FOLDT.DESCRIPTION
FROM OKC_FOLDERS_B FOLD
, OKC_FOLDERS_TL FOLDT
WHERE FOLD.FOLDER_ID = FOLDT.FOLDER_ID
AND FOLDT.LANGUAGE = USERENV('LANG')