VIEW: APPS.OKC_SCS_LINE_STYLE_ROLES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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