Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- wf 3920 - cancelado
- -- wf 4556 - aprovado
- select * from tab_solicitacao_planejamento sp
- join tab_planejamento_cenario pc on sp.id_planejamento_cenario = pc.id
- join tab_exec_wf ewf on sp.id_exec_wf = ewf.id
- join tab_cenario ce on pc.id_cenario = ce.id
- join tab_cadastro_planejamento cp on pc.id_cadastro_planejamento = cp.id
- join tab_item_planejamento_oi ipoi on ipoi.id_planejamento_cenario = pc.id
- join tab_oi oi on ipoi.id_oi = oi.id
- where ce.des_cenario = 'RF03 2017/2017' and cp.des_cadastro='WASH ADDITIVES/OMO'
- and ipoi.id_mes_planejamento = 3
- --and ewf.id = 3920
- and oi.cod_oi = 8501010855;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement