eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

OLAPSYS.OLAPFACTVIEW dependencies on ALL_OLAP_FOREIGN_KEYS

Line 185: FROM ALL_OLAP_KEY_COLUMN_USES a, ALL_OLAP_FOREIGN_KEYS b,

181: AND POSITION = ePosition;
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

Line 1943: FROM ALL_OLAP_KEY_COLUMN_USES a, ALL_OLAP_FOREIGN_KEYS b,

1939: AND POSITION = ePosition;
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