DBA Data[Home] [Help]

OLAPSYS.OLAPFACTVIEW dependencies on ALL_OLAP_JOIN_KEY_COLUMN_USES

Line 177: FROM ALL_OLAP_JOIN_KEY_COLUMN_USES

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
177: FROM ALL_OLAP_JOIN_KEY_COLUMN_USES
178: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
179: AND HIERARCHY_NAME= eHierName
180: AND CHILD_LEVEL_NAME= eLevelName
181: AND POSITION = ePosition;

Line 1935: FROM ALL_OLAP_JOIN_KEY_COLUMN_USES

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
1935: FROM ALL_OLAP_JOIN_KEY_COLUMN_USES
1936: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1937: AND HIERARCHY_NAME= eHierName
1938: AND CHILD_LEVEL_NAME= eLevelName
1939: AND POSITION = ePosition;