AP 发票状态的获取

最新推荐文章于 2022-05-30 19:04:41 发布

OO好久不见OO

最新推荐文章于 2022-05-30 19:04:41 发布

阅读量2k

点赞数 1

分类专栏： AP 文章标签： AP发票状态

本文链接：https://blog.csdn.net/longtimetoc/article/details/77181142

版权

DECLARE
  l_invoice_id         NUMBER := 443828;

  l_nls_approved             VARCHAR2(240);
  l_nls_needs_reapproval     VARCHAR2(240);
  l_nls_never_approved       VARCHAR2(240);
  l_nls_cancelled            VARCHAR2(240);
  l_nls_available            VARCHAR2(240);
  l_nls_full                 VARCHAR2(240);
  l_nls_unapproved           VARCHAR2(240);
  l_nls_unpaid               VARCHAR2(240);
  l_nls_permanent            VARCHAR2(240);
  l_nls_not_required         VARCHAR2(240);
  l_nls_required             VARCHAR2(240);
  l_nls_initiated            VARCHAR2(240);
  l_nls_wfapproved           VARCHAR2(240);
  l_nls_rejected             VARCHAR2(240);
  l_nls_manually_approved    VARCHAR2(240);
  l_nls_selected_for_payment VARCHAR2(240);
  l_inv_sel_count            NUMBER;
  l_status_lookup_code VARCHAR2(80);
  l_status_display           VARCHAR2(240);
BEGIN

  SELECT ap_invoices_pkg.get_approval_status(ap.invoice_id
                                            ,ap.invoice_amount
                                            ,ap.payment_status_flag