View: OKL_FUND_REQ_LINES_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for funding request lines
Implementation/DBA Data:	APPS.OKL_FUND_REQ_LINES_UV

View Text

SELECT D.ID ID
, D.TAP_ID FUND_HEADER_ID
, D.LINE_NUMBER FUND_LINE_NUMBER
, D.STY_ID FUND_STREAM_ID
, A2.NAME FUND_STREAM_NAME
, D.KLE_ID KLE_ID
, AL.NAME KLE_NUM
, AL.ITEM_DESCRIPTION KLE_NAME
, OKL_FUNDING_PVT.GET_CONTRACT_LINE_AMT(AL.DNZ_CHR_ID
, D.KLE_ID
, B.IPVS_ID) KLE_AMT
, OKL_FUNDING_PVT.GET_CONTRACT_LINE_FUNDED_AMT(AL.DNZ_CHR_ID
, D.KLE_ID) KLE_FUND_AMT
, 0 CONTRACT_LINE_FUNDED_REMAIN
, D.INV_DISTR_LINE_CODE FUND_LINE_TYPE
, D.AMOUNT FUND_LINE_AMOUNT
, D.FUNDING_REFERENCE_TYPE_CODE FUND_REFERENCE_TYPE
, D.FUNDING_REFERENCE_NUMBER FUND_REFERENCE_NUMBER
, D.ORG_ID ORG_ID
, DL.DESCRIPTION FUND_LINE_DESCRIPTION
, OKL_FUNDING_PVT.GET_FUNDING_SUBSIDY_AMOUNT(AL.DNZ_CHR_ID
, D.KLE_ID
, B.IPVS_ID) SUB_AMT
, OKL_FUNDING_PVT.GET_AMOUNT_SUBSIDY(AL.DNZ_CHR_ID
, D.KLE_ID) SUB_FUND_AMT
FROM OKL_TRX_AP_INVOICES_B B
, OKL_TXL_AP_INV_LNS_ALL_B D
, OKL_TXL_AP_INV_LNS_TL DL
, OKC_K_LINES_V AL
, OKL_STRM_TYPE_V A2
WHERE B.ID = D.TAP_ID
AND D.ID = DL.ID
AND DL.LANGUAGE = USERENV('LANG')
AND D.KLE_ID = AL.ID(+)
AND D.STY_ID = A2.ID(+)

Columns