View: OKC_SCS_LINE_STYLE_ROLES_V

Product:	OKC - Contracts Core
Description:	View for roles assigned to linestyles and categories
Implementation/DBA Data:	APPS.OKC_SCS_LINE_STYLE_ROLES_V

View Text

SELECT LSR.ROW_ID
, LSR.LSE_ID
, LSR.SRE_ID
, LSR.OBJECT_VERSION_NUMBER
, SRE.RLE_CODE
, SRE.SCS_CODE
, LSR.CREATED_BY
, LSR.CREATION_DATE
, LSR.LAST_UPDATED_BY
, LSR.LAST_UPDATE_DATE
, LSR.LAST_UPDATE_LOGIN
, NVL( LSR.ACCESS_LEVEL
, SRE.ACCESS_LEVEL) ACCESS_LEVEL
FROM OKC_LINE_STYLE_ROLES_V LSR
, OKC_SUBCLASS_ROLES_V SRE
WHERE LSR.SRE_ID = SRE.ID UNION ALL SELECT ROW_ID
, TO_NUMBER(NULL)
, ID
, OBJECT_VERSION_NUMBER
, RLE_CODE
, SCS_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACCESS_LEVEL
FROM OKC_SUBCLASS_ROLES_V

Columns