[Home] [Help]
View: 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
Name |
ROW_ID |
LSE_ID |
SRE_ID |
OBJECT_VERSION_NUMBER |
RLE_CODE |
SCS_CODE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
ACCESS_LEVEL |