Product: | OKC - Contracts Core |
---|---|
Description: | Numbering scheme view |
Implementation/DBA Data: | APPS.OKC_NUMBER_SCHEMES_V |
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.LANGUAGE LANGUAGE
, NSTL.SOURCE_LANG SOURCE_LANG
, NSTL.SCHEME_NAME SCHEME_NAME
, NSB.NUM_SCHEME_PREVIEW NUM_SCHEME_PREVIEW
, 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')