Timberline SQL Query

CR_DATA

SELECT 
	 PJD_DOCUMENT__CHANGE_REQUEST.Job, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Contract_Item,
	 PJD_DOCUMENT__CHANGE_REQUEST.Internal, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Number, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Cr_Misc_Date, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Cr_Misc_List, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Status,	 
	 PJD_DOCUMENT__CHANGE_REQUEST.Schedule_Impact,
	 PJD_DOCUMENT__CHANGE_REQUEST.Date,
	 PJD_DOCUMENT__CHANGE_REQUEST.Source_Type, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Source_Type_Number, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Description, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Reason, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Response_Due_Date, 
	 PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Total_Cost, 
	 PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Total_Price, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Completed_On, 
	 PJD_DOCUMENT__CHANGE_ORDER.Number, 
	 PJD_DOCUMENT__CHANGE_ORDER.Total_Price, 
	 PJD_DOCUMENT__CHANGE_ORDER.Date, 
	 PJD_DOCUMENT__CHANGE_ORDER.Status, 
	 PJD_DOCUMENT__CHANGE_ORDER.Post_Approved_Date, 
	 PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Total_Addon_Price, 
	 APM_MASTER__VENDOR.Name,
	 JCM_MASTER__COST_CODE.Description,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Extra,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Cost_Code,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Description,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Commitment,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Total_Cost, 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Total_Price, 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Response_Due_Date,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Reference_Number, 	 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Vendor_Price, 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Received_From_Vendor_On,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.No_Impact,	 
	 PJD_DOCUMENT__COMMITMENT_CO.Number, 
	 PJD_DOCUMENT__COMMITMENT_CO.Date, 
	 PJD_DOCUMENT__COMMITMENT_CO.Actual_Status, 
	 PJD_DOCUMENT__COMMITMENT_CO.Pending_Amount, 
	 PJD_DOCUMENT__COMMITMENT_CO.Approved_Amount, 
	 PJD_DOCUMENT__COMMITMENT_CO.Signed_Date,
	 PJD_DOCUMENT__COMMITMENT_CO.CCO_Misc_Text,  	 
	 PJD_DOCUMENT__COMMITMENT_CO.Total

FROM {oj
	"\\THINKSERVER\Timberline Office\Data\BLT Live\".PJD_DOCUMENT__CHANGE_REQUEST

LEFT OUTER JOIN PJD_DOCUMENT__CHANGE_REQUEST_TOTAL ON
	PJD_DOCUMENT__CHANGE_REQUEST.Change_Request_Index = PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Change_Request_Index

LEFT OUTER JOIN PJD_DOCUMENT__CHANGE_ORDER ON
	PJD_DOCUMENT__CHANGE_REQUEST.Change_Order_Index = PJD_DOCUMENT__CHANGE_ORDER.Change_Order_Index

LEFT OUTER JOIN PJD_DOCUMENT__ADDON ON
	PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Change_Request_Index = PJD_DOCUMENT__ADDON.Change_Request_Index
	
LEFT OUTER JOIN PJD_DOCUMENT__CHANGE_REQUEST_DETAIL ON
	PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Change_Request_Index = PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Change_Request_Index

LEFT OUTER JOIN APM_MASTER__VENDOR ON	
	PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Vendor = APM_MASTER__VENDOR.Vendor
		 			
LEFT OUTER JOIN PJD_DOCUMENT__COMMITMENT_CO ON
	PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Commitment_CO_Index = PJD_DOCUMENT__COMMITMENT_CO.Commitment_CO_Index

INNER JOIN JCM_MASTER__COST_CODE ON 
	PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Cost_Code = JCM_MASTER__COST_CODE.Cost_Code AND
	PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Job = JCM_MASTER__COST_CODE.Job AND
	PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Extra = JCM_MASTER__COST_CODE.Extra

}


GROUP BY
	 PJD_DOCUMENT__CHANGE_REQUEST.Job, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Contract_Item, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Extra, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Internal, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Number, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Cr_Misc_Date, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Cr_Misc_List, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Status, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Schedule_Impact,
	 PJD_DOCUMENT__CHANGE_REQUEST.Date,
	 PJD_DOCUMENT__CHANGE_REQUEST.Source_Type, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Source_Type_Number, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Description, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Reason, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Response_Due_Date, 
	 PJD_DOCUMENT__CHANGE_REQUEST.Completed_On, 
	 PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Total_Cost, 
	 PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Total_Price, 
	 PJD_DOCUMENT__CHANGE_ORDER.Number, 
	 PJD_DOCUMENT__CHANGE_ORDER.Total_Price, 
	 PJD_DOCUMENT__CHANGE_ORDER.Date, 
	 PJD_DOCUMENT__CHANGE_ORDER.Status, 
	 PJD_DOCUMENT__CHANGE_ORDER.Post_Approved_Date, 
	 PJD_DOCUMENT__CHANGE_REQUEST_TOTAL.Total_Addon_Price, 
	 APM_MASTER__VENDOR.Name,
	 JCM_MASTER__COST_CODE.Description,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Extra,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Cost_Code,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Description,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Commitment,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Total_Cost, 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Total_Price, 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Response_Due_Date,
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Reference_Number, 	 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Vendor_Price, 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.Received_From_Vendor_On, 
	 PJD_DOCUMENT__CHANGE_REQUEST_DETAIL.No_Impact,
	 PJD_DOCUMENT__COMMITMENT_CO.Number, 
	 PJD_DOCUMENT__COMMITMENT_CO.Date, 
	 PJD_DOCUMENT__COMMITMENT_CO.Actual_Status, 
	 PJD_DOCUMENT__COMMITMENT_CO.Pending_Amount, 
	 PJD_DOCUMENT__COMMITMENT_CO.Approved_Amount, 
	 PJD_DOCUMENT__COMMITMENT_CO.Signed_Date,  
	 PJD_DOCUMENT__COMMITMENT_CO.CCO_Misc_Text,
	 PJD_DOCUMENT__COMMITMENT_CO.Total