Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
NVL((
SELECT COUNT(INSTALL_MENT_AMOUNT) FROM XX_MG_BANK_LOAN_REPAYMENT
WHERE HEADER_ID = AA.HEADER_ID AND TO_DATE(MONTH_NAME) <= to_date( substr(:p_to_d_date,1,10),'YYYY/MM/DD')
AND NVL(INSTALL_MENT_AMOUNT,0) > 0
and paid = 1
),0)
)) as outstanding_amount
This is not a Qlik query. This looks like Oracle SQL. You should chat with your local Oracle SQL developers.