VIEW: APPS.OKL_FUND_REQ_LINES_UV

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)