Have to add that i have simplified the selection criteria for this
post....there are other conditions to apply to the SUB_START and
SUB_END dates to determine whether a subscription is active or
not....just didnt want to clutter the query

Also running on 9.2.0.4