OKC_NUMBER_SCHEMES_VL

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name
ROW_ID NUM_SCHEME_ID NUMBER_ARTICLE_YN OBJECT_VERSION_NUMBER SCHEME_NAME DESCRIPTION SEEDED_FLAG_YN CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NUM_SCHEME_PREVIEW NUM_SCHEME_CODE SCHEME_LEVEL_INDENT SUP_SECTION_INDENT SUP_CLAUSE_INDENT

Query

SQL_Statement

SELECT NSB.ROWID ROW_ID, NSB.NUM_SCHEME_ID NUM_SCHEME_ID, NSB.NUMBER_ARTICLE_YN NUMBER_ARTICLE_YN, NSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, NSTL.SCHEME_NAME SCHEME_NAME, NSTL.DESCRIPTION DESCRIPTION, NSB.SEEDED_FLAG_YN SEEDED_FLAG_YN, NSB.CREATED_BY CREATED_BY, NSB.CREATION_DATE CREATION_DATE, NSB.LAST_UPDATED_BY LAST_UPDATED_BY, NSB.LAST_UPDATE_DATE LAST_UPDATE_DATE, NSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NSB.NUM_SCHEME_PREVIEW NUM_SCHEME_PREVIEW, NSB.NUM_SCHEME_CODE NUM_SCHEME_CODE, NSB.SCHEME_LEVEL_INDENT SCHEME_LEVEL_INDENT, NSB.SUP_SECTION_INDENT SUP_SECTION_INDENT, NSB.SUP_CLAUSE_INDENT SUP_CLAUSE_INDENT FROM OKC_NUMBER_SCHEMES_B NSB, OKC_NUMBER_SCHEMES_TL NSTL WHERE NSB.NUM_SCHEME_ID = NSTL.NUM_SCHEME_ID AND NSTL.LANGUAGE = USERENV('LANG')