Queries to get Budget Allocation details Major, Minor, Sub, Charge Head Wise.

Budget Allocation.sql

SELECT
	concat(vwc.majorheadvalue, ' - ', vwc.majorhead),
	
	SUM(f.amt) AS Current_Allocation
FROM
	gl_fund f
	INNER JOIN ad_org o ON (( o.ad_org_id = f.ad_org_id))
	INNER JOIN gl_budget b ON (( b.gl_budget_id = f.gl_budget_id ))
	INNER JOIN f_vwchart vwc ON (( vwc.c_elementvalue_id = f.c_elementvalue_id ))
	
WHERE
	b.gl_budget_id = 1000000

GROUP BY
	vwc.majorheadvalue,
	vwc.majorhead

ORDER BY
	vwc.majorheadvalue,
	vwc.majorhead
ASC

Charge Head Wise.sql

SELECT
	concat(vwc.value, ' - ', vwc.name) AS Charge_Head,
	
	SUM(f.amt) AS Current_Allocation
FROM
	gl_fund f
	INNER JOIN ad_org o ON (( o.ad_org_id = f.ad_org_id))
	INNER JOIN gl_budget b ON (( b.gl_budget_id = f.gl_budget_id ))
	INNER JOIN f_vwchart vwc ON (( vwc.c_elementvalue_id = f.c_elementvalue_id ))
	
WHERE
	b.gl_budget_id = 1000000

GROUP BY
	vwc.value,
	vwc.name

ORDER BY
	vwc.value,
	vwc.name
ASC

Minor Head wise allocation.sql

SELECT
	concat(vwc.minorheadvalue, ' - ', vwc.minerhead),
	
	SUM(f.amt) AS Current_Allocation
FROM
	gl_fund f
	INNER JOIN ad_org o ON (( o.ad_org_id = f.ad_org_id))
	INNER JOIN gl_budget b ON (( b.gl_budget_id = f.gl_budget_id ))
	INNER JOIN f_vwchart vwc ON (( vwc.c_elementvalue_id = f.c_elementvalue_id ))
	
WHERE
	b.gl_budget_id = 1000000

GROUP BY
	vwc.minorheadvalue,
	vwc.minerhead

ORDER BY
	vwc.minorheadvalue,
	vwc.minerhead
ASC

Sub Head wise Budget.sql

SELECT
	concat(vwc.subheadvalue, ' - ', vwc.subhead),
	
	SUM(f.amt) AS Current_Allocation
FROM
	gl_fund f
	INNER JOIN ad_org o ON (( o.ad_org_id = f.ad_org_id))
	INNER JOIN gl_budget b ON (( b.gl_budget_id = f.gl_budget_id ))
	INNER JOIN f_vwchart vwc ON (( vwc.c_elementvalue_id = f.c_elementvalue_id ))
	
WHERE
	b.gl_budget_id = 1000000

GROUP BY
	vwc.subheadvalue,
	vwc.subhead

ORDER BY
	vwc.subheadvalue,
	vwc.subhead
ASC

Use WHERE Clause to get data against specific Head: e.g.

WHERE b.gl_budget_id = 1000000 AND vwc.minorheadvalue = 'A03'