select
	t01.a2arti , t04.ardesc, t04.ardsce, t05.trnome,
	t02.dapprd, t02.daputs, t02.daputi, t02.dadese, t09.danuma,

	t10.ardesc as caixa, t13.ardesc as filme,
	t03.aculot, t03.aclotc, t03.acundc, t01.azqref, t03.acebas, t03.acealt, t03.acepal, t02.daaltc, t08.ardesc as palete
from
	eplbf01.epart2f as t01
	join eplbf01.epxdapf as t02 on t01.a2marc = t02.damarc and t01.a2arti = t02.daarti
	join eplbf01.epxacdf as t03 on t02.dacoda = t03.accoda
	join sklbf01.skartif as t04 on t01.a2marc = t04.armarc and t01.a2arti = t04.ararti
	join gllbf01.gltercf as t05 on t04.arforn = t05.trcodi
	join eplbf01.epligaf as t06 on t01.a2marc = t06.lgmrc1 and t01.a2arti = t06.lgart1 and '' = t06.lgvrs1
	join eplbf01.epligaf as t07 on t07.lgmrc1 = t06.lgmrc2 and t07.lgart1 = t06.lgart2 and (left(t07.lgart2,2) = '45' or left(t07.lgart2,3) = '145' )
	join sklbf01.skartif as t08 on t08.armarc = t07.lgmrc2 and t08.ararti = t07.lgart2
     join eplbf01.epversf as t09 on t01.a2marc = t09.vrmarc and t01.a2arti = t09.vrarti and '' = t09.vrvers
	join eplbf01.epligaf as t10 on t10.lgmrc1 = t06.lgmrc2 and t10.lgart1 = t06.lgart2 and left(t10.lgart2,4) = '4416'
	join sklbf01.skartif as t11 on t11.armarc = t10.lgmrc2 and t11.ararti = t10.lgart2
	join eplbf01.epligaf as t12 on t12.lgmrc1 = t06.lgmrc2 and t12.lgart1 = t06.lgart2 and left(t12.lgart2,4) = '4433'
	join sklbf01.skartif as t13 on t13.armarc = t12.lgmrc2 and t13.ararti = t12.lgart2
where
	t01.a2marc = '%MARCA%' and t01.a2arti = '%ARTIGO%'