OKC_LINE_TYPES_VL
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: VIEW
Columns
Name |
---|
LINE_TYPE_ID PARENT_LINE_TYPE_ID SOURCE_CODE SOURCE_CODE_CLASS RECURSIVE_YN NAME DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LINE_TYPE_CODE CLE_TYPE |
Query
SQL_Statement |
---|
SELECT LSEB.LINE_TYPE_ID LINE_TYPE_ID, LSEB.PARENT_LINE_TYPE_ID PARENT_LINE_TYPE_ID, LSEB.SOURCE_CODE SOURCE_CODE, LSEB.SOURCE_CODE_CLASS SOURCE_CODE_CLASS, LSEB.RECURSIVE_YN RECURSIVE_YN, LSET.NAME NAME, LSET.DESCRIPTION DESCRIPTION, LSEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LSEB.CREATED_BY CREATED_BY, LSEB.CREATION_DATE CREATION_DATE, LSEB.LAST_UPDATED_BY LAST_UPDATED_BY, LSEB.LAST_UPDATE_DATE LAST_UPDATE_DATE, LSEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LSEB.line_type_code line_type_code, LSEB.CLE_TYPE CLE_TYPE FROM OKC_LINE_TYPES_B LSEB, OKC_LINE_TYPES_TL LSET WHERE LSEB.line_type_id = LSET.line_type_id AND LSET.language = userenv('LANG') |