select a.challan_no,a.CHALLAN_DT,a.ITEM_DESC,a.recd_QTY_NOS,a.recd_QTY_wt,a.ISS_QTY_NOS,a.ISS_QTY_wt,
b.vend_code,c.vend_name

(
(
select a.challan_no,a.CHALLAN_DT,a.ITEM_DESC,(0) "recd_QTY_NOS",(0) "recd_QTY_wt",
sum(a.ISS_QTY_NOS),sum(a.ISS_QTY_wt),
b.vend_code,c.vend_name
from jw_issue_det a,jw_issue_mas b,vendor_mas c
where
a.challan_no=b.challan_no and
a.challan_dt=b.challan_dt and
b.vend_code=c.vend_code and a.challan_dt>= : From_Dt and a.challan_dt <= :To_Dt and b.vend_code = :Vendor_Name
group by b.vend_code,c.vend_name,a.challan_no,a.CHALLAN_DT,a.ITEM_DESC
)
Union
(
Select challan_no,CHALLAN_DT,ITEM_DESC,sum(recd_QTY_NOS),sum(recd_QTY_wt),(0) "ISS_QTY_NOS",(0) "ISS_QTY_wt"
from jw_recd_det
group by challan_no,CHALLAN_DT,ITEM_DESC 
)
)
a

function CF_CbnoFormula return Number is
Cf_cbno Number(15,3);

Begin

Cf_cbNo := :recd_QTY_NOS - ISS_QTY_NOS;


Return(Cf_cbno);

End;