I am new to ORACLE and I am struggling with the appropriate condition keywords. Tried different approach but still same error.
Please help here
select (a13.RPRT_CALL_LTRS || (' - ' || a13.SGNL_TRNSMSN_TYP_CD)) RPRT_CALL_LTRS,
a15.DYPT_LBL DYPT_LBL,
CASE WHEN a12.SRVC_MRKT_NM = 'HOUSTON DMA' THEN 'Houston DMA' ELSE a12.SRVC_MRKT_NM END SRVC_MRKT_NM,
a14.RPRT_PRD_STRT_DT RPRT_PRD_STRT_DT,
max(a14.RPRT_PRD_ABRV) RPRT_PRD_ABRV,
a11.DEMO_ID DEMO_ID,
max(a16.DEMO_NM) DEMO_NM,
a12.GEO_TYP_SHRT_DESC GEO_TYP_SHRT_DESC,
a14.RPRT_PRD_STRT_DT RPRT_PRD_STRT_DT0,
a14.RPRT_PRD_END_DT RPRT_PRD_END_DT,
sum((a11.AVG_QHR_CNT * 100.0)) WJXBFS1,
sum(a11.AVG_QHR_RTG) WJXBFS2,
sum(a11.AVG_QHR_SHR) WJXBFS3,
sum((a11.CUME_CNT * 100.0)) WJXBFS4
from SRVC_RPRT_PRD_MRKT_EST_MD_CRDT_FACT_V a11
join MTR_MKT_SMPL_GEO_DEMO_UE_FACT_V a12
on (a11.SRVY_PRD_SRVC_MKT_GEO_KEY = a12.SRVY_PRD_SRVC_MKT_GEO_KEY)
join AUDIO_MD_CRDT_DIM_V a13
on (a11.AUDIO_MD_CRDT_KEY = a13.AUDIO_MD_CRDT_KEY)
join MTR_MTH_SRVC_RPRT_PRD_DIM_V a14
on (a11.SRVC_RPRT_PRD_KEY = a14.SRVC_RPRT_PRD_KEY)
join DYPT_DIM_V a15
on (a11.DYPT_ID = a15.DYPT_ID and
a11.DYPT_KEY = a15.DYPT_KEY)
join DEMO_DIM_V a16
on (a11.DEMO_ID = a16.DEMO_ID)
where (a11.AGGRGT_ESTMT_TYP_DESC in ('SINGLE')
and a12.GEO_TYP_SHRT_DESC in ('METRO')
and a11.DEMO_ID in (42, 598, 39, 35)
and a13.SGNL_TRNSMSN_TYP_CD not in ('AM', 'FM')
and a11.DYPT_ID in (84)
and case when CAST( To_Date('01/01/2000', 'mm/dd/yyyy') AS DATE)=CAST('20000101' AS DATE)
then a14.RPRT_PRD_END_DT = (select max(rpd.RPRT_PRD_END_DT) from MTR_MTH_SRVC_RPRT_PRD_DIM_V rpd
where rpd.SRVC_CD='PPM' and rpd.RPRT_PRD_TYP_SHRT_DESC='MON' and rpd.RPRT_PRD_END_DT <= current_date -9)
else a14.RPRT_PRD_STRT_DT = CAST( To_Date('01/01/2000', 'mm/dd/yyyy') AS DATE) end)
group by (a13.RPRT_CALL_LTRS || (' - ' || a13.SGNL_TRNSMSN_TYP_CD)),
a15.DYPT_LBL,
CASE WHEN a12.SRVC_MRKT_NM = 'HOUSTON DMA' THEN 'Houston DMA' ELSE a12.SRVC_MRKT_NM END,
a14.RPRT_PRD_STRT_DT,
a11.DEMO_ID,
a12.GEO_TYP_SHRT_DESC,
a14.RPRT_PRD_STRT_DT,
a14.RPRT_PRD_END_DT