SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.CO
FROM V_HIERARCHY1 a
2, My Data is
HR HR Rec Records Leave Leave Records HRL.0001 Policy and Process for leave record. 27.06.2010 30.06.2010 WIP Edlink
HR HR Rec Records Leave Leave Records HRL.0002 Quarterly Review 01.07.2010 04.07.2010 Planned Edlink
HR HR DB Database SAL Salary DDS.0001 Calculation of Monthly salary 08.08.2010 09.08.2010 WIP Edlink
HR HR Rec Records Ind Induction Records HRI.0001 Completion of dossiers. 08.07.2010 10.07.2010 WIP Edlink
HR HR DB Database Emp Employee HDE.0001 Offer letter 06.07.2010 09.07.2010 WIP Edlink
IT Info Tech SW Software ERP.Web Web based ERP ISE.0001 Version 1 10.07.2010 12.07.2010 Overdue Edlink
IT Info Tech SW Software Telecall Telecall SW IST.0001 Telecall Exe V2 09.07.2010 16.07.2010 WIP Edlink
IT Info Tech SW Software ERP.Web Web based ERP ISE.0002 Deployment on Linode server. 07.07.2010 10.07.2010 Planned Edlink
IT Info Tech SW Software ERP exe Exe for ERP ISE.0003 Training 07.07.2010 10.07.2010 WIP Edlink
IT Info Tech SA Sys Admin OS OS level set up ISO.0001 Server Set up 14.07.2010 21.07.2010 WIP Edlink
IT Info Tech SW Software ERP exe Exe for ERP ISE.0014 Distributed Model 10.09.2010 30.09.2010 Planned Edlink
Admin Admin GH Guest House Eqpt Equipment AGE.0001 Shifting of BSNL Landline. 01.07.2010 04.07.2010 WIP Edlink
Admin Admin Offc Office Eqpt Equipment AOE.0002 Routine Maintenance 30.08.2010 31.08.2010 WIP Edlink
Admin Admin Offc Office Misc Miscellaneous AOM.0001 Misc Office Tasks 15.07.2010 16.07.2010 Planned Edlink
Admin Admin Offc Office Eqpt Equipment AOE.0003 Electrical Eqpt Procedures 07.07.2010 14.07.2010 Planned Edlink
Acct Accounts Books Books Annual Acct Bk Annual ABA.0001 Closure of accounts for 2009-10 30.06.2010 06.07.2010 Planned Edlink
Acct Accounts Books Books Monthly Acct Bk Monthly ABM.0003 Finalization of expense accounts for Jun 07.07.2010 10.07.2010 Planned Edlink
Mkt Marketing Advt Advertising Print Print Ad MAP.0001 Institutional Brochure 01.07.2010 08.07.2010 WIP Edlink
3. My Out Put is
<?xml version="1.0"?>
<HD id="Acct" value="Acct">
<SH id="Books" value="Books">
<TRK id="Annual" value="Annual">
<TGT id="ABA.0001" value="ABA.0001">Closure of accounts for 2009-10</TGT>
</TRK>
<TRK id="Monthly" value="Monthly">
<TGT id="ABM.0003" value="ABM.0003">Finalization of expense accounts for Jun</TGT>
</TRK>
</SH>
</HD>
<HD id="Admin" value="Admin">
<SH id="GH" value="GH">
<TRK id="Eqpt" value="Eqpt">
<TGT id="AGE.0001" value="AGE.0001">Shifting of BSNL Landline.</TGT>
</TRK>
</SH>
<SH id="Offc" value="Offc">
<TRK id="Eqpt" value="Eqpt">
<TGT id="AOE.0002" value="AOE.0002">Routine Maintenance</TGT>
<TGT id="AOE.0003" value="AOE.0003">Electrical Eqpt Procedures</TGT>
</TRK>
<TRK id="Misc" value="Misc">
<TGT id="AOM.0001" value="AOM.0001">Misc Office Tasks</TGT>
</TRK>
</SH>
</HD>
<HD id="Corp" value="Corp">
<SH id="Comp" value="Comp">
<TRK id="Insurance" value="Insurance">
<TGT id="CCI.0001" value="CCI.0001">Office Insurance</TGT>
</TRK>
</SH>
</HD>
<HD id="DB" value="DB">
<SH id="Clg" value="Clg">
<TRK id="Govt" value="Govt">
<TGT id="DCG.0001" value="DCG.0001">Upload approvals and accreditions in reposiroty.</TGT>
</TRK>
</SH>
</HD>
<HD id="Fin" value="Fin">
<SH id="MF" value="MF">
<TRK id="Red" value="Red">
<TGT id="FMR.0001" value="FMR.0001">Redemption Tata AIG</TGT>
<TGT id="FMR.0002" value="FMR.0002">Recovery from HDFC.</TGT>
</TRK>
</SH>
</HD>
<HD id="HR" value="HR">
<SH id="DB" value="DB">
<TRK id="Emp" value="Emp">
<TGT id="HDE.0001" value="HDE.0001">Offer letter</TGT>
</TRK>
<TRK id="SAL" value="SAL">
<TGT id="DDS.0001" value="DDS.0001">Calculation of Monthly salary</TGT>
</TRK>
</SH>
<SH id="Rec" value="Rec">
<TRK id="Ind" value="Ind">
<TGT id="HRI.0001" value="HRI.0001">Completion of dossiers.</TGT>
</TRK>
<TRK id="Leave" value="Leave">
<TGT id="HRL.0001" value="HRL.0001">Policy and Process for leave record.</TGT>
<TGT id="HRL.0002" value="HRL.0002">Quarterly Review</TGT>
</TRK>
</SH>
</HD>
<HD id="IT" value="IT">
<SH id="SA" value="SA">
<TRK id="OS" value="OS">
<TGT id="ISO.0001" value="ISO.0001">Server Set up</TGT>
</TRK>
</SH>
<SH id="SW" value="SW">
<TRK id="ERP exe" value="ERP exe">
<TGT id="ISE.0003" value="ISE.0003">Training</TGT>
<TGT id="ISE.0014" value="ISE.0014">Distributed Model</TGT>
</TRK>
<TRK id="ERP.Web" value="ERP.Web">
<TGT id="ISE.0001" value="ISE.0001">Version 1</TGT>
<TGT id="ISE.0002" value="ISE.0002">Deployment on Linode server.</TGT>
</TRK>
<TRK id="Telecall" value="Telecall">
<TGT id="IST.0001" value="IST.0001">Telecall Exe V2</TGT>
</TRK>
</SH>
</HD>
<HD id="Mkt" value="Mkt">
<SH id="Advt" value="Advt">
<TRK id="Print" value="Print">
<TGT id="MAP.0001" value="MAP.0001">Institutional Brochure</TGT>
</TRK>
</SH>
<SH id="Sales" value="Sales">
<TRK id="Direct" value="Direct">
<TGT id="MSD.0004" value="MSD.0004">Public Presentation Version 2</TGT>
<TGT id="MSD.0009" value="MSD.0009">Facility Presentation</TGT>
</TRK>
</SH>
</HD>
<HD id="Org" value="Org">
<SH id="Policy" value="Policy">
<TRK id="Adm Policy" value="Adm Policy">
<TGT id="OPA.0001" value="OPA.0001">Periodical Checklists.</TGT>
</TRK>
<TRK id="Mkt Policy" value="Mkt Policy">
<TGT id="OPM.0001" value="OPM.0001">Model MOU with institution.</TGT>
</TRK>
</SH>
</HD>