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 ASCThis query returns 4,906 records.