SELECT V_Prj_inquiry.prj_name, 
           V_Prj_inquiry.emp_code_resp, 
           V_Prj_inquiry.resp_type_code,
           V_Prj_inquiry.total_prj_eff, 
           V_Prj_inquiry.clnt_name, 
           V_Prj_inquiry.start_date,
           V_Prj_inquiry.finish_date,
           V_Prj_inquiry.chargeable_prj_yn,
           V_Prj_inquiry.prj_status_ind,
           V_Prj_inquiry.org_code_resp, 
           V_Prj_inquiry.org_name, 
           prj_detail.prj_code, 
           prj_detail.phase_code,
           prj_detail.task_code,
           prj_detail.acct_code,
           prj_detail.org_code, 
           prj_detail.rev_type_code,
           prj_detail.evc_code, 
           prj_detail.per_end_date, 
           prj_detail.eff_pc, 
           prj_detail.qty_amt, 
           v_Employee_GlobalChanges.emp_name, 
           prj_bill_summary.bill_pc, 
           prj_bill_summary.collect_pc, 
           evc_master.evc_name, 
           V_Prj_Phase_inquiry.phase_name, 
           V_Prj_Phase_inquiry.sys_fee_type_code, 
           V_Prj_Phase_inquiry.total_fee_phase, 
           vid_igc_revenue.igc_rev_pc 
	    FROM 
           { oj (((((ProdDB.dbo.V_Prj_inquiry V_Prj_inquiry INNER JOIN ProdDB.dbo.prj_detail prj_detail ON 
           V_Prj_inquiry.prj_code = prj_detail.prj_code) 
           INNER JOIN ProdDB.dbo.prj_bill_summary prj_bill_summary ON 
           V_Prj_inquiry.prj_code = prj_bill_summary.prj_code) 
           RIGHT OUTER JOIN ProdDB.dbo.v_Employee_GlobalChanges v_Employee_GlobalChanges ON 
           V_Prj_inquiry.emp_code_resp = v_Employee_GlobalChanges.emp_code) 
           INNER JOIN ProdDB.dbo.V_Prj_Phase_inquiry V_Prj_Phase_inquiry ON 
           prj_detail.prj_code = V_Prj_Phase_inquiry.prj_code AND 
           prj_detail.phase_code = V_Prj_Phase_inquiry.phase_code) 
           INNER JOIN ProdDB.dbo.vid_igc_revenue vid_igc_revenue ON 
           prj_detail.prj_code = vid_igc_revenue.prj_code) 
           INNER JOIN ProdDB.dbo.evc_master evc_master ON 
           prj_detail.evc_type_code = evc_master.evc_type_code AND 
           prj_detail.evc_code = evc_master.evc_code} 
        WHERE 
           V_Prj_inquiry.resp_type_code = 'PM' AND 
           V_Prj_inquiry.chargeable_prj_yn = 'y' AND 
           V_Prj_inquiry.prj_status_ind = 'A' AND 
           V_Prj_inquiry.org_code_resp LIKE  '10%' 
        ORDER BY 
           V_Prj_inquiry.emp_code_resp ASC, 
           V_Prj_inquiry.org_name ASC, 
           prj_detail.prj_code ASC, 
           prj_detail.phase_code ASC, 
           prj_detail.task_code ASC, 
           prj_detail.org_code ASC, 
           prj_detail.rev_type_code ASC, 
	   prj_detail.evc_code ASC