View: OKC_ROLES_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_ROLES_V

View Text

SELECT RLEB.ROWID ROW_ID
, RLEB.CODE CODE
, RLEB.CONSTRAINED_RLE_CODE CONSTRAINED_CODE
, RLEB.CUSTOMER_VENDOR_FLAG CUSTOMER_VENDOR_FLAG
, RLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RLET.SFWT_FLAG SFWT_FLAG
, RLET.MEANING MEANING
, RLET.DESCRIPTION DESCRIPTION
, RLEB.START_DATE START_DATE
, RLEB.END_DATE END_DATE
, RLEB.CREATED_BY CREATED_BY
, RLEB.CREATION_DATE CREATION_DATE
, RLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, RLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_ROLES_B RLEB
, OKC_ROLES_TL RLET
WHERE RLEB.CODE = RLET.CODE
AND RLET.LANGUAGE = USERENV('LANG')

Columns