View: OKL_CS_DISBURSEMENTS_DTL_UV

View Text

SELECT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, STYT.NAME TRANSACTION_TYPE
, TAP.VENDOR_INVOICE_NUMBER VENDOR_INVOICE_NUMBER
, APL.DESCRIPTION PAYMENT_METHOD
, APC.CHECK_DATE CHECK_DATE
, APC.AMOUNT CHECK_AMOUNT
, API.INVOICE_NUM INVOICE_NUMBER
, API.APPROVAL_STATUS INVOICE_STATUS
, APC.ADDRESS_LINE1 PAYEE_ADDRESS
, APC.CHECKRUN_NAME PAYEE_NAME
, APP.INVOICE_PAYMENT_ID PAYMENT_ID
, POV.VENDOR_NAME VENDOR_NAME
, API.INVOICE_AMOUNT DISBURSEMENT_AMOUNT
, APC.CHECK_NUMBER CHECK_NUMBER
, APC.CURRENCY_CODE CHECK_CURRENCY
, TAP.ID TAP_ID
, TAP.KHR_ID KHR_ID
, POV.SEGMENT1 VENDOR_NUMBER
, API.INVOICE_CURRENCY_CODE
FROM OKL_TRX_AP_INVOICES_B TAP
, OKL_TXL_AP_INV_LNS_B TPL
, OKL_STRM_TYPE_TL STYT
, OKC_K_HEADERS_B CHR
, AP_INVOICES_ALL API
, PO_VENDORS POV
, AP_INVOICE_PAYMENTS_ALL APP
, AP_CHECKS_ALL APC
, AP_LOOKUP_CODES APL
WHERE TAP.ID = TPL.TAP_ID
AND TPL.STY_ID = STYT.ID
AND TAP.KHR_ID = CHR.ID
AND NVL(TAP.ORG_ID
, -99) = NVL(API.ORG_ID
, -99)
AND TAP.IPVS_ID = API.VENDOR_SITE_ID
AND TAP.INVOICE_NUMBER = API.VOUCHER_NUM
AND API.SOURCE(+) = 'OKL'
AND API.VENDOR_ID = POV.VENDOR_ID
AND API.INVOICE_ID = APP.INVOICE_ID
AND APP.CHECK_ID(+) = APC.CHECK_ID
AND APC.PAYMENT_METHOD_LOOKUP_CODE = APL.LOOKUP_CODE
AND APL.LOOKUP_TYPE(+) = 'PAYMENT METHOD'

Columns