Product: | OKC - Contracts Core |
---|---|
Description: | Org striped Folders View. |
Implementation/DBA Data: | APPS.OKC_FOLDERS_VL |
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')