Sql Querry Required for Terminated Contracts....

Hi Experts,

Iam working on 11.5.9 version.

I need sql query for terminated contracts which are billing active.

The objective is to select the contracts which were terminated in the past with active schedule billing lines.

E.g. Contract Start Date: 01-JUL-2010 – 01-JUL-2015(see future date) and terminated already or have a future terminated date and still has active billing schedules under the line and sub line level.

Thanks in advanced.

Regards,

VK.