[Home] [Help]
View: OKL_CS_ALL_DISBURSEMENTS_UV
Product: | OKL - Lease and Finance Management |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.ADDRESS_LINE1 ADDRESS
, TAP.KHR_ID KHR_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR.ID CHR_ID
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 |
VENDOR_NAME |
VENDOR_NUMBER |
ADDRESS |
KHR_ID |
CONTRACT_NUMBER |
CHR_ID |