VIEW: APPS.OKL_CS_AP_INVS_PAYMENTS_UV

Source

View Text - Preformatted

SELECT ac.check_date PAYMENT_DATE, alc.displayed_field PAYMENT_METHOD, aps.gross_amount AMOUNT, aps.invoice_id INVOICE_ID, aps.payment_num PAYMENT_NUM, ac.currency_code CURRENCY, ac.check_number CHECK_NUMBER, ac.bank_account_name BANK_NAME, ac.bank_account_num BANK_ACCOUNT FROM AP_PAYMENT_SCHEDULES_ALL APS,AP_INVOICE_PAYMENTS_ALL AIP,AP_CHECKS_ALL AC,AP_LOOKUP_CODES ALC WHERE aps.hold_flag = 'N' AND aip.invoice_id = aps.invoice_id AND aip.payment_num = aps.payment_num AND aip.check_id = ac.check_id AND alc.lookup_type = 'PAYMENT METHOD' AND alc.lookup_code = aps.payment_method_code

View Text - HTML Formatted

SELECT AC.CHECK_DATE PAYMENT_DATE
, ALC.DISPLAYED_FIELD PAYMENT_METHOD
, APS.GROSS_AMOUNT AMOUNT
, APS.INVOICE_ID INVOICE_ID
, APS.PAYMENT_NUM PAYMENT_NUM
, AC.CURRENCY_CODE CURRENCY
, AC.CHECK_NUMBER CHECK_NUMBER
, AC.BANK_ACCOUNT_NAME BANK_NAME
, AC.BANK_ACCOUNT_NUM BANK_ACCOUNT
FROM AP_PAYMENT_SCHEDULES_ALL APS
, AP_INVOICE_PAYMENTS_ALL AIP
, AP_CHECKS_ALL AC
, AP_LOOKUP_CODES ALC
WHERE APS.HOLD_FLAG = 'N'
AND AIP.INVOICE_ID = APS.INVOICE_ID
AND AIP.PAYMENT_NUM = APS.PAYMENT_NUM
AND AIP.CHECK_ID = AC.CHECK_ID
AND ALC.LOOKUP_TYPE = 'PAYMENT METHOD'
AND ALC.LOOKUP_CODE = APS.PAYMENT_METHOD_CODE