GL_ENCUMBRANCE_TYPES_VL

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
ROW_ID ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_CODE ENABLED_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ENCUMBRANCE_TYPE DESCRIPTION LANGUAGE SOURCE_LANG

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, B.ENCUMBRANCE_TYPE_CODE ENCUMBRANCE_TYPE_CODE, B.ENABLED_FLAG ENABLED_FLAG, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, B.ATTRIBUTE1 ATTRIBUTE1, B.ATTRIBUTE2 ATTRIBUTE2, B.ATTRIBUTE3 ATTRIBUTE3, B.ATTRIBUTE4 ATTRIBUTE4, B.ATTRIBUTE5 ATTRIBUTE5, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TL.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE, TL.DESCRIPTION DESCRIPTION, TL.LANGUAGE LANGUAGE, TL.SOURCE_LANG SOURCE_LANG FROM GL_ENCUMBRANCE_TYPES_B B, GL_ENCUMBRANCE_TYPES_TL TL WHERE B.ENCUMBRANCE_TYPE_ID = TL.ENCUMBRANCE_TYPE_ID AND LANGUAGE = USERENV('LANG')