View: OKL_CS_PAY_INVOICES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_PAY_INVOICES_UV

View Text

SELECT CNSLD.IPVS_ID IPVS_ID
, CNSLD.CURRENCY_CODE CURRENCY
, FNDV.MEANING PAYMENT_METHOD_CODE
, CNSLD.DATE_INVOICED INVOICE_DATE
, CNSLD.IPPT_ID TERM_ID
, CNSLD.INVOICE_NUMBER INVOICE_NUMBER
, CNSLD.INVOICE_TYPE INVOICE_TYPE
, CNSLD.AMOUNT AMOUNT
, LOOKUP.MEANING TRANSACTION_TYPE
, POV.VENDOR_NAME VENDOR_NAME
, POVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, FNDVA.MEANING INVOICE_STATUS
, CNSLD.PAY_GROUP_LOOKUP_CODE
, CNSLD.VENDOR_INVOICE_NUMBER
, POV.VENDOR_ID VENDOR_ID
, TERM.NAME PAYMENTS_TERMS
, API.AMOUNT_PAID PAID_AMOUNT
, FNDV.MEANING PAYMENT_METHOD
, CNSLD.CNSLD_AP_INV_ID
, API.INVOICE_ID
FROM FND_LOOKUPS FNDVA
, FND_LOOKUPS FNDV
, AP_INVOICES_ALL API
, PO_VENDOR_SITES_ALL POVS
, PO_VENDORS POV
, OKL_CNSLD_AP_INVS_ALL CNSLD
, FND_APPLICATION APP
, FND_LOOKUPS LOOKUP
, AP_TERMS_TL TERM
WHERE CNSLD.PAYMENT_METHOD_CODE = FNDV.LOOKUP_CODE
AND FNDV.LOOKUP_TYPE = 'OKL_PAYMENT_METHODS'
AND CNSLD.TRX_STATUS_CODE = FNDVA.LOOKUP_CODE
AND FNDVA.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND NVL(CNSLD.ORG_ID
, -99) = NVL(API.ORG_ID
, -99)
AND API.VENDOR_ID = POV.VENDOR_ID
AND API.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID
AND POV.VENDOR_ID = POVS.VENDOR_ID
AND API.APPLICATION_ID = APP.APPLICATION_ID
AND APP.APPLICATION_SHORT_NAME = 'OKL'
AND API.PRODUCT_TABLE = 'OKL_CNSLD_AP_INVS_ALL'
AND CNSLD.CNSLD_AP_INV_ID = TO_NUMBER(API.REFERENCE_KEY1)
AND LOOKUP.LOOKUP_TYPE = 'OKL_PAYABLES_INVOICE_TYPE'
AND LOOKUP.LOOKUP_CODE = CNSLD.INVOICE_TYPE
AND CNSLD.IPPT_ID = TERM.TERM_ID
AND TERM.LANGUAGE = USERENV('LANG')

Columns