VIEW: APPS.GL_JE_CATEGORIES_VL

Source

View Text - Preformatted

SELECT rowid ROW_ID, je_category_name JE_CATEGORY_NAME, language LANGUAGE, source_lang SOURCE_LANG, user_je_category_name USER_JE_CATEGORY_NAME, je_category_key JE_CATEGORY_KEY, last_update_date LAST_UPDATE_DATE, last_updated_by LAST_UPDATED_BY, creation_date CREATION_DATE, created_by CREATED_BY, last_update_login LAST_UPDATE_LOGIN, description DESCRIPTION, attribute1 ATTRIBUTE1, attribute2 ATTRIBUTE2, attribute3 ATTRIBUTE3, attribute4 ATTRIBUTE4, attribute5 ATTRIBUTE5, context CONTEXT, consolidation_flag CONSOLIDATION_FLAG FROM gl_je_categories_tl WHERE language = userenv ( 'LANG')

View Text - HTML Formatted

SELECT ROWID ROW_ID
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, LANGUAGE LANGUAGE
, SOURCE_LANG SOURCE_LANG
, USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, JE_CATEGORY_KEY JE_CATEGORY_KEY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, CONTEXT CONTEXT
, CONSOLIDATION_FLAG CONSOLIDATION_FLAG
FROM GL_JE_CATEGORIES_TL
WHERE LANGUAGE = USERENV ( 'LANG')