DBA Data[Home] [Help]

OLAPSYS.OLAPDIMVIEW dependencies on ALL_OLAP_JOIN_KEY_COLUMN_USES

Line 184: FROM ALL_OLAP_JOIN_KEY_COLUMN_USES

180: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
181: AND DIMENSION_NAME= eDimName;
182:
183: CURSOR curParentName IS SELECT TABLE_NAME || '.' || COLUMN_NAME, TABLE_NAME
184: FROM ALL_OLAP_JOIN_KEY_COLUMN_USES
185: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
186: AND HIERARCHY_NAME= eHierName
187: AND CHILD_LEVEL_NAME= eLevelName
188: AND POSITION = ePosition;

Line 1881: FROM ALL_OLAP_JOIN_KEY_COLUMN_USES

1877: WHERE OWNER= eOwnerName AND LEVEL_NAME= eLevelName
1878: AND DIMENSION_NAME= eDimName;
1879:
1880: CURSOR curParentName IS SELECT TABLE_NAME || '.' || COLUMN_NAME, TABLE_NAME
1881: FROM ALL_OLAP_JOIN_KEY_COLUMN_USES
1882: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1883: AND HIERARCHY_NAME= eHierName
1884: AND CHILD_LEVEL_NAME= eLevelName
1885: AND POSITION = ePosition;