GL_JE_CATEGORIES

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name

ROW_ID JE_CATEGORY_NAME LANGUAGE SOURCE_LANG USER_JE_CATEGORY_NAME JE_CATEGORY_KEY LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DESCRIPTION ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_CATEGORY CONSOLIDATION_FLAG OBJECT_VERSION_NUMBER DISALLOW_MJE_FLAG

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.JE_CATEGORY_NAME JE_CATEGORY_NAME, TL.LANGUAGE LANGUAGE, TL.SOURCE_LANG SOURCE_LANG, TL.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME, B.JE_CATEGORY_KEY JE_CATEGORY_KEY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TL.DESCRIPTION DESCRIPTION, B.ATTRIBUTE1 ATTRIBUTE1, B.ATTRIBUTE2 ATTRIBUTE2, B.ATTRIBUTE3 ATTRIBUTE3, B.ATTRIBUTE4 ATTRIBUTE4, B.ATTRIBUTE5 ATTRIBUTE5, B.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, B.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, B.CONSOLIDATION_FLAG CONSOLIDATION_FLAG, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.DISALLOW_MJE_FLAG DISALLOW_MJE_FLAG FROM GL_JE_CATEGORIES_B B, GL_JE_CATEGORIES_TL TL WHERE B.JE_CATEGORY_NAME = TL.JE_CATEGORY_NAME AND TL.LANGUAGE = USERENV('LANG')