PJO_RBS_DENORM_V
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: VIEW
Columns
| Name |
|---|
|
RBS_VERSION_ID SUB_EMT_ID SUP_EMT_ID SUB_LEVEL SUP_LEVEL |
Query
| SQL_Statement |
|---|
|
SELECT elem.RBS_VERSION_ID RBS_VERSION_ID, CONNECT_BY_ROOT elem.RBS_ELEMENT_ID SUB_EMT_ID, elem.PARENT_ELEMENT_ID SUP_EMT_ID, (elem.RBS_LEVEL-1) + level SUB_LEVEL, elem.RBS_LEVEL-1 SUP_LEVEL FROM PJF_RBS_ELEMENTS elem WHERE elem.PARENT_ELEMENT_ID IS NOT NULL CONNECT BY PRIOR elem.PARENT_ELEMENT_ID = elem.RBS_ELEMENT_ID |