CREATE OR REPLACE
FUNCTION "GET_INNER_OUTPUT_VALUE" (V_PK_ORG IN VARCHAR2, V_PK_MONTH IN VARCHAR2)
RETURN NUMBER
Authid Current_User
AS V_OUTPUT_VALUE NUMBER(28,8);
BEGIN
-- routine body goes here, e.g.
-- DBMS_OUTPUT.PUT_LINE('Navicat for Oracle');
SELECT nvl(sum(OUTPUT_VALUE),0) INTO V_OUTPUT_VALUE FROM FACT_SERVICE_OUTPUT WHERE PK_ORG = V_PK_ORG AND PK_MONTH = V_PK_MONTH AND SOURCE = '本单位内部' ;
RETURN V_OUTPUT_VALUE;
END;