View: OKC_SCS_LSE_RULE_GROUPS_V

Product:	OKC - Contracts Core
Description:	View for rule groups assigned to linestyles and categorie
Implementation/DBA Data:	APPS.OKC_SCS_LSE_RULE_GROUPS_V

View Text

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

Columns