This content has been marked as final. Show 1 reply
It might help to know what exactly your query is looking to retrieve - I don't think retrieving every column of every table in your table list is going to be particularly useful.
For what it's worth, I think the table OTA_RESOURCE_BOOKINGS might prove useful somehow. Certainly it has the column SUPPLIED_RESOURCE_ID in it.
Edited to add: and another thing, you might want to apply the TRUNC function to that sysdate reference in your WHERE clause.
Edited by: clive_t on 31-Dec-2012 14:18