OLAPSYS.OLAPFACTVIEW dependencies on ALL_OLAP_DIM_LEVELS

Line 137: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;

133:
134: TYPE dimList_t IS TABLE OF dimType;
135: -- TYPE dimList IS TABLE OF ALL_OLAP_FACT_LEVEL_USES.DIMENSION_NAME%TYPE
136:
137: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;
138:
139: TYPE hierarchyList_t IS TABLE OF ALL_OLAP_DIM_HIERARCHIES.DIMENSION_NAME%TYPE;
140:
141: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;

Line 172: FROM ALL_OLAP_DIM_LEVELS

168: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
169: AND DIMENSION_NAME= eDimName ;
170:
171: CURSOR curTabName IS SELECT LEVEL_TABLE_NAME
172: FROM ALL_OLAP_DIM_LEVELS
173: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
174: AND DIMENSION_NAME= eDimName;
175:
176: CURSOR curParentName IS SELECT TABLE_NAME || '.' || COLUMN_NAME, TABLE_NAME

Line 1895: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;

1891:
1892: TYPE dimList_t IS TABLE OF dimType;
1893: -- TYPE dimList IS TABLE OF ALL_OLAP_FACT_LEVEL_USES.DIMENSION_NAME%TYPE
1894:
1895: TYPE levList_t IS TABLE OF ALL_OLAP_DIM_LEVELS.LEVEL_NAME%TYPE;
1896:
1897: TYPE hierarchyList_t IS TABLE OF ALL_OLAP_DIM_HIERARCHIES.DIMENSION_NAME%TYPE;
1898:
1899: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;

Line 1930: FROM ALL_OLAP_DIM_LEVELS

1926: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
1927: AND DIMENSION_NAME= eDimName ;
1928:
1929: CURSOR curTabName IS SELECT LEVEL_TABLE_NAME
1930: FROM ALL_OLAP_DIM_LEVELS
1931: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
1932: AND DIMENSION_NAME= eDimName;
1933:
1934: CURSOR curParentName IS SELECT TABLE_NAME || '.' || COLUMN_NAME, TABLE_NAME