shieldsco
asked on
SQL Error Missing keyword
I'm getting the following case statement error when trying to execute the code below
java.sql.SQLSyntaxErrorExc eption: ORA-00905: missing keyword
Select
A.C_ALJ_APPEAL_NUM AS "Appeal Number"
,A.C_RECONSIDER_NUM AS "Level 2 Appeal Number"
,Case When DT.C_NAME IS NULL Then W.C_NAME
,Else W.C_NAME ||' '||'('|| DT.C_NAME ||')' AS "Appeal Status"
,End
, TO_CHAR(coalesce(A.C_COMPL ETE_REQUES T_RECVD_DT ,A.C_REQUE ST_RECV_DT ), 'MM-DD-YYYY') as "Dt Comp Rqst Recd"
, ' ' as "Begin Hearing Date"
,TO_CHAR (A.C_DLM_DATE, 'MM-DD-YYYY') AS "Dec Ltr Mailed"
, ' ' as "New Appeal Number"
,ALJ.C_Team_NAme AS "Adjudicator Login"
From
((T_APL A
inner join T_RF_STATE W on A.C_WORKFLOW_STATE = W.ID)
left outer join T_ALJ ALJ on ALJ.ID = A.C_ALJ_TEAM
left outer join T_APPEAL_DECISION_WRITING ADW on A.id = ADW.ID_PARENT)
left outer join T_DECISION_TYPE DT on adw.C_DECISION_TYPE = DT.ID
WHERE
A.C_WORKFLOW_STATE not in (136,140,139,143,137,138,1 30,144) --Draft RFH, Invalid, Not Promotable, Promote Failed ,Waiting for MAS , Validation in Progress ,Un-Promoted, process in MAS
order by A.C_ALJ_TEAM
]
java.sql.SQLSyntaxErrorExc
Select
A.C_ALJ_APPEAL_NUM AS "Appeal Number"
,A.C_RECONSIDER_NUM AS "Level 2 Appeal Number"
,Case When DT.C_NAME IS NULL Then W.C_NAME
,Else W.C_NAME ||' '||'('|| DT.C_NAME ||')' AS "Appeal Status"
,End
, TO_CHAR(coalesce(A.C_COMPL
, ' ' as "Begin Hearing Date"
,TO_CHAR (A.C_DLM_DATE, 'MM-DD-YYYY') AS "Dec Ltr Mailed"
, ' ' as "New Appeal Number"
,ALJ.C_Team_NAme AS "Adjudicator Login"
From
((T_APL A
inner join T_RF_STATE W on A.C_WORKFLOW_STATE = W.ID)
left outer join T_ALJ ALJ on ALJ.ID = A.C_ALJ_TEAM
left outer join T_APPEAL_DECISION_WRITING ADW on A.id = ADW.ID_PARENT)
left outer join T_DECISION_TYPE DT on adw.C_DECISION_TYPE = DT.ID
WHERE
A.C_WORKFLOW_STATE not in (136,140,139,143,137,138,1
order by A.C_ALJ_TEAM
]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Open in new window
becomes:Open in new window
»bp