[Home] [Help]
View: OKL_BPD_AP_INV_LINES_UV
Product: | OKL - Leasing and Finance Management |
Description: | View to display Payable Invoice Line details in the View Transactions Details screen. |
Implementation/DBA Data: |
APPS.OKL_BPD_AP_INV_LINES_UV
|
View Text
SELECT INV.INVOICE_NUM
, INV.INVOICE_ID
, LIN.LINE_NUMBER
, LIN.DESCRIPTION
, LIN.AMOUNT + NVL(( SELECT SUM(ZX_LINES.TAX_AMT)
FROM ZX_LINES ZX_LINES
WHERE ZX_LINES.APPLICATION_ID = LIN.PROGRAM_APPLICATION_ID
AND ZX_LINES.TRX_ID = LIN.INVOICE_ID
AND ZX_LINES.TRX_LINE_ID = LIN.LINE_NUMBER
AND ZX_LINES.ENTITY_CODE = 'AP_INVOICES'
AND NVL(ZX_LINES.CANCEL_FLAG
, 'N') = 'N' )
, 0) AMOUNT
, INV.SET_OF_BOOKS_ID
, STY.STREAM_TYPE_PURPOSE
, STY.NAME
, TPL.KHR_ID
, KHR.CONTRACT_NUMBER
FROM OKL_CNSLD_AP_INVS_ALL CIN
, OKL_TRX_AP_INVS_ALL_B TAP
, OKL_TXL_AP_INV_LNS_B TPL
, AP_INVOICES_ALL INV
, AP_INVOICE_LINES_ALL LIN
, OKC_K_HEADERS_B KHR
, FND_APPLICATION APP
, OKL_STRM_TYPE_V STY
WHERE LIN.APPLICATION_ID = APP.APPLICATION_ID
AND APP.APPLICATION_SHORT_NAME = 'OKL'
AND LIN.PRODUCT_TABLE = 'OKL_TXL_AP_INV_LNS_ALL_B'
AND TPL.ID = TO_NUMBER(LIN.REFERENCE_KEY1)
AND LIN.INVOICE_ID = INV.INVOICE_ID
AND TPL.KHR_ID = KHR.ID
AND TPL.STY_ID = STY.ID
AND TAP.VENDOR_ID = INV.VENDOR_ID
AND TAP.IPVS_ID (+) = INV.VENDOR_SITE_ID UNION SELECT INV.INVOICE_NUM
, INV.INVOICE_ID
, LIN.AMOUNT + NVL(( SELECT SUM(ZX_LINES.TAX_AMT)
FROM ZX_LINES ZX_LINES
WHERE ZX_LINES.APPLICATION_ID = LIN.PROGRAM_APPLICATION_ID
AND ZX_LINES.TRX_ID = LIN.INVOICE_ID
AND ZX_LINES.TRX_LINE_ID = LIN.LINE_NUMBER
AND ZX_LINES.ENTITY_CODE = 'AP_INVOICES'
AND NVL(ZX_LINES.CANCEL_FLAG
, 'N') = 'N' )
, 0) AMOUNT
, LIN.DESCRIPTION
, LIN.AMOUNT
, INV.SET_OF_BOOKS_ID
, STY.STREAM_TYPE_PURPOSE
, STY.NAME
, TPL.KHR_ID
, KHR.CONTRACT_NUMBER
FROM OKL_TRX_AP_INVS_ALL_B TAP
, OKL_TXL_AP_INV_LNS_B TPL
, AP_INVOICES_ALL INV
, AP_INVOICE_LINES_ALL LIN
, OKC_K_HEADERS_B KHR
, FND_APPLICATION APP
, OKL_STRM_TYPE_V STY
, OKL_CNSLD_AP_INVS_ALL CIN
WHERE INV.APPLICATION_ID = APP.APPLICATION_ID
AND APP.APPLICATION_SHORT_NAME = 'OKL'
AND INV.PRODUCT_TABLE = 'OKL_CNSLD_AP_INVS_ALL'
AND CIN.CNSLD_AP_INV_ID = TO_NUMBER(INV.REFERENCE_KEY1)
AND TPL.CNSLD_AP_INV_ID = CIN.CNSLD_AP_INV_ID
AND LIN.INVOICE_ID = INV.INVOICE_ID
AND LIN.APPLICATION_ID = INV.APPLICATION_ID
AND LIN.PRODUCT_TABLE = 'OKL_TXL_AP_INV_LNS_ALL_B'
AND LIN.REFERENCE_KEY1 IS NULL
AND TPL.KHR_ID = KHR.ID
AND TPL.STY_ID = STY.ID
AND TAP.ID = TPL.TAP_ID
AND TAP.VENDOR_ID = INV.VENDOR_ID
AND TAP.IPVS_ID (+) = INV.VENDOR_SITE_ID
Columns
Name |
INVOICE_NUM |
INVOICE_ID |
LINE_NUMBER |
DESCRIPTION |
AMOUNT |
SET_OF_BOOKS_ID |
STREAM_TYPE_PURPOSE |
NAME |
KHR_ID |
CONTRACT_NUMBER |