Exemplo 2 - Query do CBS

select

top 100

cenario.ID_CENARIO

 

cbs_cst

cbs_class_trib

cbs_aliq

cbs_vlr_aliq_efetiva

cbs_displeg

cbs_obs

cbs.base_calculo

cbs_red_aliq

cbs_inf_adic

cred_cbs_ind_cred

cred_cbs_cst_entr

cred_cbs_perc_cred

cred_cbs_vig_de

cred_cbs_vig_ate

cred_cbs_obs

cbs_tribreg_CSTReg

cbs_tribreg_cClassTribReg

cbs_tribreg_pCBS

cbs_tribreg_baseCalculoReg

cbs_tribreg_pRedAliq

credpresu_cbs_cCredPres

credpresu_cbs_pCredPres

credpresu_cbs_vigenciaDe

credpresu_cbs_vigenciaAte

credpresu_cbs_observacoes

 

From

TBL_CENARIO_MATERIAL_REFORMA CM (NOLOCK)

LEFT JOIN TBL_MATERIAL M (NOLOCK) ON CM.MAT_CODI = M.MAT_CODI

INNER JOIN TBL_CENARIO C (NOLOCK) ON CM.CENARIO_CODI = C.CENARIO_CODI

LEFT JOIN TBL_IMP_CBS I3 (NOLOCK) ON CM.CMA_CODI = I3.CMA_CODI

LEFT JOIN TBL_CBS CBS (NOLOCK) ON I3.IMP_CODI = CBS.IMP_CODI

 

where 

material.COD_PROD='X62002003405'

cenario.UF_ORIGEM='SP' AND

cenario.UF_DESTINO='SP' AND

cenario.ORIGEM='3' AND

cenario.DESTINACAO='3' AND

material.MAT_STATUS='P' AND

material.MAT_ATIVO=1 AND

cen_mat.cma_ativ=1 AND

IBSUF.imp_ativ='1' AND

IBSUF.imp_status='A'