SELECT PO.VENDOR_ID,
PO.VENDOR_NAME PROVEEDOR,
AIA.INVOICE_ID,
AIA.INVOICE_NUM NUMERO_FACTURA,
AIA.INVOICE_DATE FECHA_FACTURA,
AIA.GL_DATE FECHA_CONTABLE,
aia.INVOICE_CURRENCY_CODE DIVISA,
aia.invoice_AMOUNT IMPORTE
from apps.Ap_Invoices_All aia, apps.po_vendors po
where po.vendor_Id = aia.vendor_id
and po.vendor_Name = '&vendor_name'
and aia.invoice_date between to_date('&fecha_inicio', 'dd/mm/yyyy')
and to_date('&fecha_fin', 'dd/mm/yyyy')
No hay comentarios:
Publicar un comentario