select
'09' as IDENTIFICADOR,
lpcod as codigo,
lpdes as descricao,
1 as ativo,
lpempparcod as codFilialUnidade,
1 as temFreteEmbutidoNoValor,
null as condicoesAdicionais,
null as valorMinimoPedido,
0 as precoComImpostos
from lp
where lpempparcod in (select parcod from par join emp on empparcod = parcod where parsit = 'A')
order by lpcod
ExecutarScriptSempre
