AP
文章平均质量分 78
QQ51567242
这个作者很懒,什么都没留下…
展开
-
AP发票批量付款程序(WEB ADI)
CREATE OR REPLACE PACKAGE MEW_AP_BATCH_PAYMENTS_PKG IS PROCEDURE MAIN(P_BATCH_ID NUMBER ,P_ORG_ID NUMBER ,P_BANK_ACCOUNT_NAME VARCHAR2原创 2012-01-31 17:04:15 · 4779 阅读 · 1 评论 -
AP发票导入程序(WEB ADI)
CREATE OR REPLACE PACKAGE MEW_BATCH_IMPINVOICES_PKG IS PROCEDURE MAIN(P_BATCH_ID NUMBER, P_ORG_ID NUMBER, P_INVOICE_TYPE原创 2012-01-31 17:05:09 · 2315 阅读 · 0 评论 -
应付发票余额
CREATE OR REPLACE FUNCTION MEW_GET_APINVOICE_BALANCE_F(P_INVOICE_ID NUMBER) RETURN NUMBER IS V_INVOICE_AMOUNT NUMBER; V_PAYMENT_AMOUNT NUMBER; V_PREPAID_AMOUNT转载 2012-06-05 14:40:59 · 1167 阅读 · 0 评论 -
ORACLE EBS AP发票到付款的数据流
--1.发票创建时生成数据如下表 --发票主表 SELECT * FROM AP_INVOICES_ALL A WHERE A.INVOICE_NUM = '20111213001'; --发票分配表 SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL B WHERE B.INVOICE_ID = 697444; --发票付款计划表 SELECT *转载 2011-11-10 13:58:35 · 2799 阅读 · 0 评论