When I first add a null column to the interactive grade, everything works fine. But if I add another column later, the null column no longer works. when I add tow new items MFG_DATE, EXP_DATE then '' RETURN_QTY, '' NEW_LOT is not working.
IG SQL Query is given below:
select A.LOAN_ID_DTL,
A.LOAN_ID,
A.ITEM_ID,
B.ITEM_CODE,
B.ITEM_DESC ITEM_NAME,
C.UNIT_NAME MOU,
A.UNIT_PRICE,
A.LOAN_QTY,
(select sum(LOAN_QTY) from LOAN_ORDER_DTL where REF_LOAN = :P127_REF_LOAN and ITEM_ID = a.ITEM_ID) RETURNED_QTY,
'' RETURN_QTY,
A.LOT_NO,
A.LOCATION_ID,
'' NEW_LOT,
'' STOCK_QTY,
'' MFG_DATE,
'' EXP_DATE,
A.REMARKS
FROM LOAN_ORDER_DTL A, INV_ITEM_DTL B, MSR_UNIT C
WHERE A.ITEM_ID = B.ITEM_ID
AND A.MSR_UNIT = C.UNIT_ID
AND A.LOAN_ID = :P127_REF_LOAN;