DBA Data[Home] [Help]

VIEW: APPS.OKC_ART_SET_NAMES_V

Source

View Text - Preformatted

SELECT TO_CHAR(FOLD.FOLDER_ID) SAT_CODE, FOLDER_NAME NAME, DESCRIPTION DESCRIPTION FROM OKC_FOLDERS_B FOLD, OKC_FOLDERS_ALL_TL FOLDT WHERE FOLD.FOLDER_ID = FOLDT.FOLDER_ID AND FOLDT.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT TO_CHAR(FOLD.FOLDER_ID) SAT_CODE
, FOLDER_NAME NAME
, DESCRIPTION DESCRIPTION
FROM OKC_FOLDERS_B FOLD
, OKC_FOLDERS_ALL_TL FOLDT
WHERE FOLD.FOLDER_ID = FOLDT.FOLDER_ID
AND FOLDT.LANGUAGE = USERENV('LANG')