<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE qml SYSTEM "/wt/query/qml/qml.dtd">
<qml bypassAccessControl="false">
	<statement>
		<query>
			<select distinct="false" group="false">
				<object alias="EPM Document" heading="EPMDocument" propertyName=""/>
				<column alias="EPMWorkspace" heading="Workspace Name" isExternal="false" propertyName="name" selectOnly="false" type="java.lang.String">
					name
				</column>
				<column alias="User" heading="User Name" isExternal="false" propertyName="name" selectOnly="false" type="java.lang.String">
					name
				</column>
				<column alias="EPM Document" heading="Checked Out By.Display Name" isExternal="false" propertyName="locker.objectId.id" selectOnly="false" type="long">
					lock.locker.key.id
				</column>
				<object alias="Part (wt.part.WTPart)" heading="WTPart" propertyName=""/>
			</select>
			<from>
				<table alias="wt.epm.workspaces.EPMCheckpoint" isExternal="false">
					wt.epm.workspaces.EPMCheckpoint
				</table>
				<table alias="EPMWorkspace" isExternal="false">
					wt.epm.workspaces.EPMWorkspace
				</table>
				<table alias="Baseline Member" isExternal="false" outerJoinAlias="wt.epm.workspaces.EPMCheckpoint">
					wt.vc.baseline.BaselineMember
				</table>
				<table alias="EPM Document" isExternal="false" outerJoinAlias="Baseline Member">
					wt.epm.EPMDocument
				</table>
				<table alias="Part (wt.part.WTPart)" isExternal="false" outerJoinAlias="Baseline Member">
					wt.part.WTPart
				</table>
				<table alias="User" isExternal="false">
					wt.org.WTUser
				</table>
			</from>
			<where>
				<compositeCondition type="and">
					<condition>
						<operand>
							<column alias="EPM Document" heading="Checked Out By.Object Id.Id" isExternal="false" propertyName="locker.objectId.id" selectOnly="false" type="long">
								lock.locker.key.id
							</column>
						</operand>
						<operator type="notEqual"/>
						<operand>
							<constant heading="0" isMacro="false" type="java.lang.Object">
								0
							</constant>
						</operand>
					</condition>
				</compositeCondition>
			</where>
			<orderBy>
				<orderByItem type="asc">
					<columnTarget heading="Workspace Name"/>
				</orderByItem>
			</orderBy>
			<linkJoin>
				<join name="wt.epm.workspaces.WorkspaceCheckpoint">
					<aliasTarget alias="EPMWorkspace"/>
					<aliasTarget alias="wt.epm.workspaces.EPMCheckpoint"/>
				</join>
			</linkJoin>
			<referenceJoin>
				<join name="roleAObjectRef">
					<aliasTarget alias="Baseline Member"/>
					<aliasTarget alias="wt.epm.workspaces.EPMCheckpoint"/>
				</join>
				<join name="roleBObjectRef">
					<aliasTarget alias="Baseline Member"/>
					<aliasTarget alias="EPM Document"/>
				</join>
				<join name="roleBObjectRef">
					<aliasTarget alias="Baseline Member"/>
					<aliasTarget alias="Part (wt.part.WTPart)"/>
				</join>
				<join name="principalReference">
					<aliasTarget alias="EPMWorkspace"/>
					<aliasTarget alias="User"/>
				</join>
			</referenceJoin>
		</query>
	</statement>
</qml>
