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