eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKL_BPD_PAY_INVOICES_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TAP.IPVS_ID IPVS_ID
, TAP.KHR_ID KHR_ID
, TAP.CURRENCY_CODE CURRENCY
, TAP.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, TAP.DATE_INVOICED INVOICE_DATE
, TAP.IPPT_ID TERM_ID
, TAP.INVOICE_NUMBER INVOICE_NUMBER
, TAP.INVOICE_CATEGORY_CODE INVOICE_CATEGORY_CODE
, TAP.INVOICE_TYPE INVOICE_TYPE
, TAP.AMOUNT AMOUNT
, STY.ID STY_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, STY.CODE STREAM_TYPE
, POV.VENDOR_NAME VENDOR_NAME
, POVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, TAP.TRX_STATUS_CODE INVOICE_STATUS
, TAP.PAY_GROUP_LOOKUP_CODE
, TAP.VENDOR_INVOICE_NUMBER
FROM PO_VENDOR_SITES_ALL POVS
, PO_VENDORS POV
, OKC_K_HEADERS_B CHR
, OKL_STRM_TYPE_B STY
, OKL_TXL_AP_INV_LNS_B TPL
, OKL_TRX_AP_INVOICES_B TAP
WHERE TAP.ID = TPL.TAP_ID
AND TPL.STY_ID = STY.ID
AND TAP.IPVS_ID = POVS.VENDOR_SITE_ID
AND POVS.VENDOR_ID = POV.VENDOR_ID
AND TAP.KHR_ID = CHR.ID

Columns

Name
IPVS_ID
KHR_ID
CURRENCY
PAYMENT_METHOD_CODE
INVOICE_DATE
TERM_ID
INVOICE_NUMBER
INVOICE_CATEGORY_CODE
INVOICE_TYPE
AMOUNT
STY_ID
CONTRACT_NUMBER
STREAM_TYPE
VENDOR_NAME
VENDOR_SITE_CODE
INVOICE_STATUS
PAY_GROUP_LOOKUP_CODE
VENDOR_INVOICE_NUMBER