c_paymentterm_note.sql

Java写的ERP系统

CREATE OR REPLACE FUNCTION C_PaymentTerm_Note
(
    PaymentTerm_ID  IN NUMBER,
    TermDate        IN DATE
)
RETURN NVARCHAR2
/*************************************************************************
 * The contents of this file are subject to the Compiere License.  You may
 * obtain a copy of the License at    http://www.compiere.org/license.html
 * Software is on an  "AS IS" basis,  WITHOUT WARRANTY OF ANY KIND, either
 * express or implied. See the License for details. Code: Compiere ERP+CRM
 * Copyright (C) 1999-2002 Jorg Janke, ComPiere, Inc. All Rights Reserved.
 *************************************************************************
 * $Id: C_PaymentTerm_Note.sql,v 1.2 2002/06/04 21:02:23 jjanke Exp $
 ***
 * Title:	Translate Payment term to fully qualified Term
 * Description:
 *			ToDo: Translation with AD_Message
 ************************************************************************/
AS
	v_DocNote		C_PaymentTerm.Description%TYPE;
BEGIN
    SELECT  Description
      INTO 	v_DocNote
    FROM    C_PaymentTerm
    WHERE   C_PaymentTerm_ID=PaymentTerm_ID;

    RETURN v_DocNote;
END C_PaymentTerm_Note;
/