View: OKL_BPD_AP_DISB_DTLS_UV

Product:	OKL - Lease and Finance Management
Description:	AP Disbursements Details
Implementation/DBA Data:	APPS.OKL_BPD_AP_DISB_DTLS_UV

View Text

SELECT APINV.INVOICE_ID INVOICE_ID
, APINV.VOUCHER_NUM INVOICE_NUMBER
, APINV.INVOICE_DATE INVOICE_DATE
, APINV.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(NVL(APINV.INVOICE_AMOUNT
, 0)
, APINV.INVOICE_CURRENCY_CODE) INVOICE_AMOUNT
, POVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, POVS.ADDRESS_LINE1 ADDRESS1
, POVS.ADDRESS_LINE2 ADDRESS2
, POVS.ADDRESS_LINE3 ADDRESS3
, POVS.ADDRESS_LINE4 ADDRESS4
, POVS.CITY CITY
, POVS.STATE STATE
, POVS.ZIP ZIP
, POVS.COUNTRY COUNTRY
FROM PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, AP_INVOICES_ALL APINV
WHERE APINV.VENDOR_ID = POV.VENDOR_ID
AND APINV.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID

Columns