AW_004_DE01

SELECT 'Sales Exec.' CODE union
select 'Price List' union
select 'Predictive'

select id, pr.desc0 prospect, it.descr item, st.desc0 stage, cp.desc0 competitor, close_date, units, value, predictive_fct
from AW_004_000001_000002 t
inner join ed_prospect pr on pr.cod = t.prospect
inner join AW_004_000013_000001 it on it.item = t.item
inner join ed_stage st on st.cod = t.stage
inner join ed_competitor cp on cp.cod = t.competitor
where scenario = '2019BDG'
   and entity = ${$Entity.code}
   and t.product = ${$Cust_Dim2.code}
   and t.bdg_sce = ${$Scenario.code}
   and t.bdg_per =  case ${$Period.code} when '' then t.bdg_per else ${$Period.code} end
   and t.stage <> '05'
order by close_date, id