"Expiring Agreements" Standard Query Issue

Hi All,

I m getting an issue regarding "Expiring Agreements" Standard Query.

It should show all the master agreements and contracts.But if I have attached a subagreement to the masteragreement, then I m getting the following issue:

1. Master agreement link is deactivated and subagreement link is activated.

2. If subagreement link is not attached, then Master Agreement link is activated.

Can any one help me in solving this issue.

Any help will be appreciated.

Thanks & Regards,

Vignesh