[Home] [Help]
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
Name |
ROW_ID |
LSE_ID |
SRD_ID |
OBJECT_VERSION_NUMBER |
RGD_CODE |
SCS_CODE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
ACCESS_LEVEL |