Rem
Rem $Header: onevafnp.sql 27-feb-01.16:35:09 dthompso Exp $
Rem
Rem onevafnp.sql
Rem
Rem  Copyright (c) Oracle Corporation 2000, 2001. All Rights Reserved.
Rem
Rem    NAME
Rem      onevafnp.sql - all$olap_function_parameters
Rem
Rem    DESCRIPTION
Rem      Parameters of aggregation functions.
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    dthompso    02/27/01 - change security implementation
Rem    dthompso    04/26/00 - Initial Version
Rem    dthompso    01/00/00 - Created
Rem

CREATE OR REPLACE VIEW all$olap_function_parameters AS SELECT 
  f.name function_name
, p.name parameter_name
, d.name data_type
, p.shortdescription parameter_type
, p.length length
, p.precision precision
, p.scale scale
, p.input_fk_seq position
FROM
  cwm$function f
, cwm$parameter p
, cwm$domain d
WHERE f.irid = p.operation_irid
AND p.type_irid = d.irid (+)
WITH READ ONLY
/