AP未结应付发票一览

--未结应付发票
select hou.name as "业务实体",
       aia.cust_registration_number as "客户纳税人标识",
       cux_bq_common.get_lookup_meaning('INVOICE TYPE',
                                        aia.invoice_type_lookup_code) as "类型",
       pha.segment1 as "PO编号",
       pv.vendor_name as "贸易伙伴",
       pv.segment1 as "供应商编号",
       pvs.vendor_site_code as "供应商地点名称",
       aia.invoice_date as "发票日期",
       aia.invoice_num as "发票编号",
       aia.invoice_currency_code as "发票币种",
       aia.invoice_amount as "发票额",
       aia.total_tax_amount as "税额",
       aia.control_amount as "税收控制金额",
       ap_invoices_pkg.get_amount_withheld(aia.invoice_id) as "预扣额",
       ap_prepay_utils_pkg.get_prepaid_amount(aia.invoice_id) as "预付额",
       aia.gl_date as "GL日期",
       aia.payment_currency_code as "付款币种",
       aia.payment_cross_rate_date as "付款汇率日期",
       aia.payment_cross_rate_type as "付款汇率类型",
       aia.payment_cross_rate as "付款汇率",
       dset.distribution_set_name as "分配集",
       aia.description as "摘要",
       aia.quick_credit as "快速贷项",
       decode(aia.credited_invoice_id,
              null,