存储过程1

jar_java

于 2011-02-20 18:42:20 发布

阅读量104

点赞数

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/jar_java/article/details/83842413

版权

数据库专栏收录该内容

13 篇文章

订阅专栏

CREATE OR REPLACE PROCEDURE ERP.INT_ERP_PO_CREATE IS
V_SOURCE_TYPE_CODE            INT_ERP_PO_INFO.SOURCE_TYPE_CODE%TYPE;
V_PO_TYPE                     INT_ERP_PO_INFO.PO_TYPE%TYPE;
V_GROUP_CODE                  INT_ERP_PO_INFO.GROUP_CODE%TYPE;
V_HEADER_DESCRIPTION          INT_ERP_PO_INFO.HEADER_DESCRIPTION%TYPE;
V_NOTE_TO_BUYER               INT_ERP_PO_INFO.NOTE_TO_BUYER%TYPE;
V_NOTE_TO_RECEIVER            INT_ERP_PO_INFO.NOTE_TO_RECEIVER%TYPE;
V_REFERENCE_NUM               INT_ERP_PO_INFO.REFERENCE_NUM%TYPE;
V_SOURCE_ORGANIZATION_ID      INT_ERP_PO_INFO.SOURCE_ORGANIZATION_ID%TYPE;
V_DESTINATION_ORGANIZATION_ID INT_ERP_PO_INFO.DESTINATION_ORGANIZATION_ID%TYPE;
V_STORE_CODE                  INT_ERP_PO_INFO.STORE_CODE%TYPE;