<?xml version="1.0"?>
<SECTIONS>
	<EW_HEADER>
		<VERSION Number="2020.0.0.0"/>
		<VERSIONS>
			<DataProjectVersion>268</DataProjectVersion>
			<AppVersion>2020.0.0.31</AppVersion>
		</VERSIONS>
		<FILENAME>UnconsistantCableOriginDestinationLocation_Imperial</FILENAME>
		<DESCRIPTION>
			<LANGUAGE xml:lang="en">Cable origin-destination location different from component location</LANGUAGE>
			<LANGUAGE xml:lang="fr">Localisation d'origine-destination du câble différente de la localisation du composant</LANGUAGE>
			<LANGUAGE xml:lang="cs">Umístění svazku počátek-konec se liší od umístění součásti</LANGUAGE>
			<LANGUAGE xml:lang="de">Ursprungs-/Zielkabelposition unterscheidet sich von Bauteilposition</LANGUAGE>
			<LANGUAGE xml:lang="it">Ubicazione di origine e destinazione del cavo diversa dall'ubicazione del componente</LANGUAGE>
			<LANGUAGE xml:lang="ja">コンポーネント ロケーションとは異なるケーブルの渡り配線ロケーション</LANGUAGE>
			<LANGUAGE xml:lang="ko">케이블 원본-대상 위치가 부품 위치와 다름</LANGUAGE>
			<LANGUAGE xml:lang="pl">Lokalizacja kabla źródło-cel różna od lokalizacji komponentu</LANGUAGE>
			<LANGUAGE xml:lang="zh">电缆的起点和终点位置与设备位置不同</LANGUAGE>
			<LANGUAGE xml:lang="pt">Localização de origem e de destino do cabo diferente da localização do componente</LANGUAGE>
			<LANGUAGE xml:lang="ru">Местоположение источника и места назначения кабеля отличается от местоположения компонента</LANGUAGE>
			<LANGUAGE xml:lang="es">La situación de origen-destino de la manguera es diferente de la situación del componente</LANGUAGE>
			<LANGUAGE xml:lang="tr">Kablo başlangıç-bitiş konumu bileşen konumundan farklı</LANGUAGE>
			<LANGUAGE xml:lang="zh-tw">電纜起點-終點位置與設備位置不同</LANGUAGE>
		</DESCRIPTION>
		<FILE_TYPE>10</FILE_TYPE>
		<OBJECT_TYPE>4</OBJECT_TYPE>
		<MEASURMENT>0</MEASURMENT>
		<Datatype>0</Datatype>
	</EW_HEADER>
	<QUERY>
		<FileData>
			<FileNameFormula/>
			<TZ_0>
				<LANGUAGE xml:lang="en">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="fr">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="cs">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="de">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="it">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ja">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ko">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="pl">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="zh">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="pt">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ru">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="es">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="tr">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="zh-tw">REP_DESC</LANGUAGE>
			</TZ_0>
			<AutoFilterDesc>1</AutoFilterDesc>
		</FileData>
		<SQLQuery>SELECT DISTINCT

tew_cable.cab_tag AS cab_tag
, tew_cable.cab_id AS cab_id
, tew_location_Cab_From.loc_tagpath AS locCab_From
, tew_location_Com_From.loc_tagpath AS locCom_From
, tew_location_Cab_To.loc_tagpath AS locCab_To
, tew_location_Com_To.loc_tagpath AS locCom_To
, tew_component_To.com_id AS com_to_id
, tew_wire.wir_cel_idfrom AS cel_idfrom
, tew_wire.wir_cel_idto AS cel_idto
FROM
tew_cable
LEFT JOIN tew_wire ON (tew_wire.wir_cab_id = tew_cable.cab_id)
LEFT JOIN tew_component AS tew_component_From ON (tew_wire.wir_com_idfrom = tew_component_From.com_id)
LEFT JOIN tew_component AS tew_component_To ON (tew_wire.wir_com_idto = tew_component_To.com_id)
LEFT JOIN tew_location AS tew_location_Com_From ON (tew_component_From.com_loc_id = tew_location_Com_From.loc_id)
LEFT JOIN tew_location AS tew_location_Com_To ON (tew_component_To.com_loc_id = tew_location_Com_To.loc_id)
LEFT JOIN tew_location AS tew_location_Cab_From ON (tew_cable.cab_loc_id_from = tew_location_Cab_From.loc_id)
LEFT JOIN tew_location AS tew_location_Cab_To ON (tew_cable.cab_loc_id_to = tew_location_Cab_To.loc_id)

WHERE (NOT(tew_location_Com_To.loc_id = tew_cable.cab_loc_id_to) OR NOT (tew_location_Com_From.loc_id = tew_cable.cab_loc_id_from ))
          ORDER BY cab_tag</SQLQuery>
		<BreakFormula/>
		<ORDERS>
			<ORDER>
				<No>0</No>
				<FieldName>cab_tag</FieldName>
				<IsBreak>0</IsBreak>
			</ORDER>
		</ORDERS>
		<ObjectType>1</ObjectType>
	</QUERY>
	<LAYOUT>
		<HeadingFormula>[AUTO]""</HeadingFormula>
		<IsHeadingVisible>1</IsHeadingVisible>
		<IsTitleVisible>1</IsTitleVisible>
		<IsHorzSeparationVisible>1</IsHorzSeparationVisible>
		<IsTotalVisible>0</IsTotalVisible>
		<COLUMNS>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="de">Kabelkennzeichen</LANGUAGE>
					<LANGUAGE xml:lang="en">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="es">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="fr">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="it">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="ja">ケーブル マーク</LANGUAGE>
					<LANGUAGE xml:lang="ko">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="pl">Znacznik kabla</LANGUAGE>
					<LANGUAGE xml:lang="pt">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="ru">Метка кабеля</LANGUAGE>
					<LANGUAGE xml:lang="tr">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="zh">CableMark</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">CableMark</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>0</columnIndex>
				<ContentFormula>cab_tag</ContentFormula>
				<GotoId>cab_id</GotoId>
				<GotoType>4</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>2.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Umístění svazku (původní)</LANGUAGE>
					<LANGUAGE xml:lang="de">Kabelposition (Ursprung)</LANGUAGE>
					<LANGUAGE xml:lang="en">Cable location (origin)</LANGUAGE>
					<LANGUAGE xml:lang="es">Situación de la manguera (origen)</LANGUAGE>
					<LANGUAGE xml:lang="fr">Localisation du câble (origine)</LANGUAGE>
					<LANGUAGE xml:lang="it">Ubicazione cavo (origine)</LANGUAGE>
					<LANGUAGE xml:lang="ja">ケーブル ロケーション (始点)</LANGUAGE>
					<LANGUAGE xml:lang="ko">케이블 위치(원본)</LANGUAGE>
					<LANGUAGE xml:lang="pl">Lokalizacja kabla (źródło)</LANGUAGE>
					<LANGUAGE xml:lang="pt">Localização do Cabo (origem)</LANGUAGE>
					<LANGUAGE xml:lang="ru">Местоположение кабеля (исходная точка)</LANGUAGE>
					<LANGUAGE xml:lang="tr">Kablo Konumu (başlangıç)</LANGUAGE>
					<LANGUAGE xml:lang="zh">电缆位置（起点）</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">電纜位置 (起點)</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>1</columnIndex>
				<ContentFormula>locCab_From</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>3.500000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Umístění součásti (původní)</LANGUAGE>
					<LANGUAGE xml:lang="de">Position des Bauteils (Ursprung)</LANGUAGE>
					<LANGUAGE xml:lang="en">Component location (origin)</LANGUAGE>
					<LANGUAGE xml:lang="es">Situación del componente (origen)</LANGUAGE>
					<LANGUAGE xml:lang="fr">Localisation du composant (origine)</LANGUAGE>
					<LANGUAGE xml:lang="it">ubicazione componente (origine)</LANGUAGE>
					<LANGUAGE xml:lang="ja">コンポーネント ロケーション (始点)</LANGUAGE>
					<LANGUAGE xml:lang="ko">부품 위치(원점)</LANGUAGE>
					<LANGUAGE xml:lang="pl">lokalizacja komponentu (źródło)</LANGUAGE>
					<LANGUAGE xml:lang="pt">localização do componente (origem)</LANGUAGE>
					<LANGUAGE xml:lang="ru">месторасположение компонента (исходная точка)</LANGUAGE>
					<LANGUAGE xml:lang="tr">bileşen konumu (başlangıç)</LANGUAGE>
					<LANGUAGE xml:lang="zh">设备位置（起点）</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">設備位置 (起點)</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>2</columnIndex>
				<ContentFormula>locCom_From</ContentFormula>
				<GotoId>cel_idfrom</GotoId>
				<GotoType>51</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>3.500000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Umístění svazku (koncové)</LANGUAGE>
					<LANGUAGE xml:lang="de">Kabelposition (Ziel)</LANGUAGE>
					<LANGUAGE xml:lang="en">Cable location (destination)</LANGUAGE>
					<LANGUAGE xml:lang="es">Situación de la manguera (destino)</LANGUAGE>
					<LANGUAGE xml:lang="fr">Localisation du câble (destination)</LANGUAGE>
					<LANGUAGE xml:lang="it">Ubicazione cavo (destinazione)</LANGUAGE>
					<LANGUAGE xml:lang="ja">ケーブル ロケーション (終点)</LANGUAGE>
					<LANGUAGE xml:lang="ko">케이블 위치(대상)</LANGUAGE>
					<LANGUAGE xml:lang="pl">Lokalizacja kabla (miejsce docelowe)</LANGUAGE>
					<LANGUAGE xml:lang="pt">Localização do cabo (destino)</LANGUAGE>
					<LANGUAGE xml:lang="ru">Местоположение кабеля (назначение)</LANGUAGE>
					<LANGUAGE xml:lang="tr">Kablo konumu (bitiş)</LANGUAGE>
					<LANGUAGE xml:lang="zh">电缆位置（终点）</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">電纜位置 (終點)</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>3</columnIndex>
				<ContentFormula>locCab_To</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>3.500000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Umístění součásti (cílové)</LANGUAGE>
					<LANGUAGE xml:lang="de">Position des Bauteils (Ziel)</LANGUAGE>
					<LANGUAGE xml:lang="en">Component location (destination)</LANGUAGE>
					<LANGUAGE xml:lang="es">Situación del componente (destino)</LANGUAGE>
					<LANGUAGE xml:lang="fr">Localisation du composant (destination)</LANGUAGE>
					<LANGUAGE xml:lang="it">Componente Ubicazione (destinazione)</LANGUAGE>
					<LANGUAGE xml:lang="ja">コンポーネント ロケーション (終点)</LANGUAGE>
					<LANGUAGE xml:lang="ko">부품 위치(대상)</LANGUAGE>
					<LANGUAGE xml:lang="pl">Lokalizacja komponentu (miejsce docelowe)</LANGUAGE>
					<LANGUAGE xml:lang="pt">Localização do Componente (destino)</LANGUAGE>
					<LANGUAGE xml:lang="ru">Месторасположение компонента (назначение)</LANGUAGE>
					<LANGUAGE xml:lang="tr">Bileşen Konumu (bitiş)</LANGUAGE>
					<LANGUAGE xml:lang="zh">设备位置（终点）</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">設備位置 (終點)</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>4</columnIndex>
				<ContentFormula>locCom_To</ContentFormula>
				<GotoId>cel_idto</GotoId>
				<GotoType>51</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>3.500000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<BreakColumn>1</BreakColumn>
				<columnIndex>5</columnIndex>
				<ContentFormula>""</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter>,</EnumerationDelimiter>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>400.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>0</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
		</COLUMNS>
		<DefaultCodeLg>
		</DefaultCodeLg>
		<DefaultGoto/>
		<HorizontalCellMargin>-1</HorizontalCellMargin>
		<VerticalCellMargin>0</VerticalCellMargin>
	</LAYOUT>
	<VARIABLES/>
	<FONT>
		<HeadingFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</HeadingFont>
		<TitleFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
		</TitleFont>
		<ContentFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>7</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</ContentFont>
		<TotalFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>1</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>1</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</TotalFont>
	</FONT>
	<OPTIONS>
		<IsTxtOneArrayPerPage>1</IsTxtOneArrayPerPage>
		<DwgBOMHeight>9.500000</DwgBOMHeight>
		<DwgBOMWidth>16.000000</DwgBOMWidth>
		<IsReverseOrder>0</IsReverseOrder>
		<XDwgBOMOrigine>0.750000</XDwgBOMOrigine>
		<YDwgBOMOrigine>1.400000</YDwgBOMOrigine>
		<DwgHorzOffset>0.500000</DwgHorzOffset>
		<DwgVertOffset>0.500000</DwgVertOffset>
		<IsDwgOneArrayPerPage>0</IsDwgOneArrayPerPage>
		<IsDwgFollowingOnSameSheet>0</IsDwgFollowingOnSameSheet>
		<IsDwgOneArrayPerColumn>0</IsDwgOneArrayPerColumn>
		<TITLEBLOCK_NAME/>
		<OneArrayPerBundle>0</OneArrayPerBundle>
		<TakeIntoGeneratedFile>0</TakeIntoGeneratedFile>
		<MargeBetweenLabelAndTable>0.100000</MargeBetweenLabelAndTable>
		<UsePipeCharacter>1</UsePipeCharacter>
		<BreakTextIntoGeneratedFile>0</BreakTextIntoGeneratedFile>
	</OPTIONS>
	<FILTERS/>
</SECTIONS>
