Hi there,
Could you please let me know how can we handle below DB where clause in Set Analysis -:
WHERE
SC_START_DATE < V_END_DATE + 1 AND
(
SC_ENABLED_STATE = 1 OR
(SC_LAST_CANCELLED_DATE IS NULL AND SC_ENABLED_STATE = 1) OR
SC_LAST_CANCELLED_DATE <= SC_START_DATE OR
SC_LAST_CANCELLED_DATE >= V_END_DATE + 1 OR
(SC_LAST_CANCELLED_DATE IS NULL AND SC_ENABLED_STATE <> 1 AND SC_MODIFY_DATE >= V_END_DATE + 1)
)
V_END_DATE is input from user.
Really appreciate your input on this.
Thanks
Sanket