VIEW: APPS.OKL_FUND_ASSETS_LOV_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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