Rem
Rem $Header: onevdfnu.sql 26-apr-2000.16:23:32 dthompso Exp $
Rem
Rem onevdfnu.sql
Rem
Rem  Copyright (c) Oracle Corporation 2000. All Rights Reserved.
Rem
Rem    NAME
Rem      onevdfnu.sql - dba$olap_function_usages
Rem
Rem    DESCRIPTION
Rem      Use of a function as an aggregation method
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    dthompso    04/26/00 - Initial Version
Rem    dthompso    01/00/00 - Created
Rem

CREATE OR REPLACE VIEW dba$olap_function_usages AS SELECT 
  u.irid function_usage_id
, f.name function_name
FROM
  cwm$function f
, cwm$functionuse u
WHERE f.irid = u.function_irid
WITH READ ONLY
/