View: OKL_FUND_ASSETS_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for assets lov on funding page.
Implementation/DBA Data:	APPS.OKL_FUND_ASSETS_LOV_UV

View Text

SELECT B.ID FUND_ID
, A.CLE_ID CLE_ID
, A.CHR_ID CHR_ID
, A.ASSET_NUMBER KLE_NUM
, A.DESCRIPTION KLE_NAME
, OKL_FUNDING_PVT.GET_CONTRACT_LINE_AMT(A.CHR_ID
, A.CLE_ID
, B.IPVS_ID) KLE_AMT
, OKL_FUNDING_PVT.GET_CONTRACT_LINE_FUNDED_AMT(A.CHR_ID
, A.CLE_ID) KLE_FUND_AMT
, B.IPVS_ID VENDOR_SITE_ID
, OKL_FUNDING_PVT.GET_FUNDING_SUBSIDY_AMOUNT(A.CHR_ID
, A.CLE_ID
, B.IPVS_ID) SUB_AMT
, OKL_FUNDING_PVT.GET_AMOUNT_SUBSIDY(A.CHR_ID
, A.CLE_ID) SUB_FUND_AMT
FROM OKL_ASSETS_LOV_UV A
, OKL_TRX_AP_INVOICES_B B
, OKL_TXL_AP_INV_LNS_B TPL
WHERE B.ID = TPL.TAP_ID
AND A.CHR_ID = TPL.KHR_ID

Columns