AP 应付发票凭证代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】 AP 应付发票凭证

作者:专注Oracle EBS / 发布于2012/11/29/ 1470

select aia.invoice_num,
       aia.invoice_date,
       aia.creation_date,
       aia.vendor_id,
       aia.invoice_currency_code,
       ail.amount,
       ail.base_amount,
       aia.description,
       decode(ail.base_amount,
              null,
,
              round(ail.base_amount / ail.amount, 4)),
       ail.inventory_item_id,
       ail.quantity_invoiced,
       ail.unit_price,
       ail.amount,
       ail.base_amount,
       ail.rcv_transaction_id,
       msi.segment1,
       msi.description,
       rsh.receipt_num,
       pha.segment1,
       pv.vendor_name,
       rsl.quantity_received
  from ap.ap_invoices_all      aia,
       ap.ap_invoice_lines_all ail,
       po.po_headers_all       pha,
       apps.po_vendors         pv,
       inv.mtl_system_items_b  msi,
       rcv_shipment_headers    rsh, --接收头
       rcv_shipment_lines      rsl --接收行
 where aia.invoice_id = ail.invoice_id
   and ail.po_header_id = pha.po_header_id(+)
   and aia.vendor_id = pv.vendor_id
   and ail.inventory_item_id = msi.inventory_item_id(+)
   and ail.org_id = msi.organization_id(+)
   and ail.rcv_shipment_line_id = rsl.shipment_line_id(+)
   and rsl.shipment_header_id = rsh.shipment_header_id(+)
   and ail.line_type_lookup_code = 'ITEM'

试试其它关键字

　AP　　应付发票凭证　

同语言下

可能有用的

专注Oracle EBS贡献的其它代码(66)