VIEW: APPS.OKL_CS_PAY_INVOICES_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')