OLAPSYS.OLAPFACTVIEW dependencies on ALL_OLAP_FACT_LEVEL_USES

Line 135: -- TYPE dimList IS TABLE OF ALL_OLAP_FACT_LEVEL_USES.DIMENSION_NAME%TYPE

131:
132: TYPE mvtype_t IS TABLE of mv_dimHier;
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;

Line 146: FROM ALL_OLAP_FACT_LEVEL_USES WHERE FACT_TABLE_NAME= eFactName AND

142:
143:
144:
145: CURSOR curDimName IS SELECT DIMENSION_NAME
146: FROM ALL_OLAP_FACT_LEVEL_USES WHERE FACT_TABLE_NAME= eFactName AND
147: OWNER= eOwnerName AND CUBE_NAME= eCubeName;
148:
149: CURSOR curLevelName IS SELECT V.L
150: FROM ( SELECT CHILD_LEVEL_NAME L, POSITION P

Line 186: ALL_OLAP_FACT_LEVEL_USES c

182:
183:
184: CURSOR curLeavName IS SELECT distinct a.column_name
185: FROM ALL_OLAP_KEY_COLUMN_USES a, ALL_OLAP_FOREIGN_KEYS b,
186: ALL_OLAP_FACT_LEVEL_USES c
187: where a.table_name = b.table_name
188: and a.position = ePosition
189: and a.key_name = b.foreign_key_name
190: and b.table_name = c.fact_table_name

Line 1893: -- TYPE dimList IS TABLE OF ALL_OLAP_FACT_LEVEL_USES.DIMENSION_NAME%TYPE

1889:
1890: TYPE mvtype_t IS TABLE of mv_dimHier;
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;

Line 1904: FROM ALL_OLAP_FACT_LEVEL_USES WHERE FACT_TABLE_NAME= eFactName AND

1900:
1901:
1902:
1903: CURSOR curDimName IS SELECT DIMENSION_NAME
1904: FROM ALL_OLAP_FACT_LEVEL_USES WHERE FACT_TABLE_NAME= eFactName AND
1905: OWNER= eOwnerName AND CUBE_NAME= eCubeName;
1906:
1907: CURSOR curLevelName IS SELECT V.L
1908: FROM ( SELECT CHILD_LEVEL_NAME L, POSITION P

Line 1944: ALL_OLAP_FACT_LEVEL_USES c

1940:
1941:
1942: CURSOR curLeavName IS SELECT distinct a.column_name
1943: FROM ALL_OLAP_KEY_COLUMN_USES a, ALL_OLAP_FOREIGN_KEYS b,
1944: ALL_OLAP_FACT_LEVEL_USES c
1945: where a.table_name = b.table_name
1946: and a.position = ePosition
1947: and a.key_name = b.foreign_key_name
1948: and b.table_name = c.fact_table_name