[Home] [Help]
View: OKC_NUMBER_SCHEMES_VL
Product: | OKC - Contracts Core |
Description: | View name for the numbering scheme VO |
Implementation/DBA Data: |
APPS.OKC_NUMBER_SCHEMES_VL
|
View Text
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.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
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')
Columns
Name |
ROW_ID |
NUM_SCHEME_ID |
NUMBER_ARTICLE_YN |
OBJECT_VERSION_NUMBER |
SCHEME_NAME |
DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |