Set Analysis : OR Conditions

[sanketkhunte]

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