{"id":314,"date":"2015-01-27T16:57:49","date_gmt":"2015-01-27T08:57:49","guid":{"rendered":"http:\/\/www.llku.com\/?p=314"},"modified":"2015-01-27T17:30:13","modified_gmt":"2015-01-27T09:30:13","slug":"%e8%8e%b7%e5%8f%96%e5%be%85%e6%a0%b8%e9%94%80%e7%9a%84%e9%a2%84%e4%bb%98%e6%ac%be%e5%8f%91%e7%a5%a8%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=314","title":{"rendered":"\u83b7\u53d6\u5f85\u6838\u9500\u7684\u9884\u4ed8\u6b3e\u53d1\u7968\u4fe1\u606f"},"content":{"rendered":"<p>\n\tselect ai.invoice_id \u53d1\u7968ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;ai.invoice_num \u53d1\u7968\u7f16\u53f7,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;ail.line_number \u53d1\u7968\u884c\u53f7,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;ap_prepay_utils_pkg.get_line_prepay_amt_remaining(ail.invoice_id,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ail.line_number) \u5f85\u6838\u9500\u91d1\u989d,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;aps.vendor_name \u4f9b\u5e94\u5546\u540d\u79f0\n<\/p>\n<p>\n\t&nbsp; from ap_invoices_all &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ai,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;ap_invoice_lines_all &nbsp; &nbsp; &nbsp; &nbsp; ail,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;ap_invoice_distributions_all aid,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;gl_code_combinations &nbsp; &nbsp; &nbsp; &nbsp; gcc,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;ap_suppliers &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; aps<br \/>\n\t&nbsp;where 1 = 1<br \/>\n\t&nbsp; &nbsp;and ai.invoice_id = ail.invoice_id<br \/>\n\t&nbsp; &nbsp;and aps.vendor_id = ai.vendor_id<br \/>\n\t&nbsp; &nbsp;and ail.invoice_id = aid.invoice_id<br \/>\n\t&nbsp; &nbsp;and ail.line_number = aid.invoice_line_number<br \/>\n\t&nbsp; &nbsp;and aps.enabled_flag = &#39;Y&#39;<br \/>\n\t&nbsp; &nbsp;and (aps.end_date_active is null or aps.end_date_active &gt; sysdate)<br \/>\n\t&nbsp; &nbsp;and ai.invoice_type_lookup_code = &#39;PREPAYMENT&#39;<br \/>\n\t&nbsp; &nbsp; &nbsp; &#8211;\u83b7\u53d6\u4e3a\u53ef\u7528\u72b6\u6001\u7684\u9884\u4ed8\u6b3e\u53d1\u7968,\u5373\u5df2\u7ecf\u5bf9\u9884\u4ed8\u6b3e\u7cfb\u7edf\u5185\u4ed8\u6b3e\u5b8c\u6210<br \/>\n\t&nbsp; &nbsp;and ap_invoices_utility_pkg.get_approval_status(ai.invoice_id,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ai.invoice_amount,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ai.payment_status_flag,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ai.invoice_type_lookup_code) =<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;&#39;AVAILABLE&#39;<br \/>\n\t&nbsp; &nbsp;and decode(ai.invoice_type_lookup_code,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#39;PREPAYMENT&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; decode(ai.earliest_settlement_date,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&#39;&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&#39;PERMANENT&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&#39;TEMPORARY&#39;)) = &#39;TEMPORARY&#39;<br \/>\n\t&nbsp; &nbsp;and ai.accts_pay_code_combination_id = gcc.code_combination_id;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>select ai.invoice_id \u53d1\u7968ID, &nbsp; &nbsp; &nbsp; &nbsp;a &hellip; <a href=\"https:\/\/www.llku.com\/?p=314\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u83b7\u53d6\u5f85\u6838\u9500\u7684\u9884\u4ed8\u6b3e\u53d1\u7968\u4fe1\u606f<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[62],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/314"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=314"}],"version-history":[{"count":3,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/314\/revisions"}],"predecessor-version":[{"id":318,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/314\/revisions\/318"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}