OLAPSYS.OLAPDIMVIEW dependencies on ALL_OLAP_DIM_HIER_LEVEL_USES

Line 158: FROM ALL_OLAP_DIM_HIER_LEVEL_USES

154: OWNER= eOwnerName;
155:
156: CURSOR curLevelName IS SELECT V.L
157: FROM ( SELECT CHILD_LEVEL_NAME L, POSITION P
158: FROM ALL_OLAP_DIM_HIER_LEVEL_USES
159: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
160: AND HIERARCHY_NAME= eHierName
161: UNION
162: SELECT PARENT_LEVEL_NAME L, POSITION+1

Line 163: FROM ALL_OLAP_DIM_HIER_LEVEL_USES

159: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
160: AND HIERARCHY_NAME= eHierName
161: UNION
162: SELECT PARENT_LEVEL_NAME L, POSITION+1
163: FROM ALL_OLAP_DIM_HIER_LEVEL_USES
164: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
165: AND HIERARCHY_NAME= eHierName) V
166: ORDER BY V.P DESC;
167:

Line 1855: FROM ALL_OLAP_DIM_HIER_LEVEL_USES

1851: OWNER= eOwnerName;
1852:
1853: CURSOR curLevelName IS SELECT V.L
1854: FROM ( SELECT CHILD_LEVEL_NAME L, POSITION P
1855: FROM ALL_OLAP_DIM_HIER_LEVEL_USES
1856: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1857: AND HIERARCHY_NAME= eHierName
1858: UNION
1859: SELECT PARENT_LEVEL_NAME L, POSITION+1

Line 1860: FROM ALL_OLAP_DIM_HIER_LEVEL_USES

1856: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1857: AND HIERARCHY_NAME= eHierName
1858: UNION
1859: SELECT PARENT_LEVEL_NAME L, POSITION+1
1860: FROM ALL_OLAP_DIM_HIER_LEVEL_USES
1861: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1862: AND HIERARCHY_NAME= eHierName) V
1863: ORDER BY V.P DESC;
1864: