VIEW: APPS.OKC_SCS_LSE_RULE_GROUPS_V

Source

View Text - Preformatted

SELECT lrg.row_id, lrg.lse_id, lrg.srd_id, lrg.object_version_number, srd.rgd_code, srd.scs_code, lrg.created_by, lrg.creation_date, lrg.last_updated_by, lrg.last_update_date, lrg.last_update_login, nvl( LRG.ACCESS_LEVEL,SRD.ACCESS_LEVEL) ACCESS_LEVEL from okc_lse_rule_groups_v lrg, okc_subclass_rg_defs_v srd WHERE lrg.srd_id = srd.id union all select row_id, To_Number(Null), id, object_version_number, rgd_code, scs_code, created_by, creation_date, last_updated_by, last_update_date, last_update_login, access_level from okc_subclass_rg_defs_v

View Text - HTML Formatted

SELECT LRG.ROW_ID
, LRG.LSE_ID
, LRG.SRD_ID
, LRG.OBJECT_VERSION_NUMBER
, SRD.RGD_CODE
, SRD.SCS_CODE
, LRG.CREATED_BY
, LRG.CREATION_DATE
, LRG.LAST_UPDATED_BY
, LRG.LAST_UPDATE_DATE
, LRG.LAST_UPDATE_LOGIN
, NVL( LRG.ACCESS_LEVEL
, SRD.ACCESS_LEVEL) ACCESS_LEVEL
FROM OKC_LSE_RULE_GROUPS_V LRG
, OKC_SUBCLASS_RG_DEFS_V SRD
WHERE LRG.SRD_ID = SRD.ID UNION ALL SELECT ROW_ID
, TO_NUMBER(NULL)
, ID
, OBJECT_VERSION_NUMBER
, RGD_CODE
, SCS_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACCESS_LEVEL
FROM OKC_SUBCLASS_RG_DEFS_V