oracle8.1.6 and sysdate-i.open_date <= 1 and sysdate-i.open_date <= 7 and months_between(sysdate,i.open_date) <= 1 select i.issue_id, u.user_id, u.first_names as users_first_names, u.last_name as users_last_name, id.user_identification_id, i.order_id, to_char(open_date,'YYYY-MM-DD HH24:MI:SS') as full_open_date, to_char(close_date,'YYYY-MM-DD HH24:MI:SS') as full_close_date from ec_customer_service_issues i, cc_users u, ec_user_identification id where i.user_identification_id = id.user_identification_id and id.user_id = u.user_id(+) and 0 = (select count(*) from ec_cs_issue_type_map m where m.issue_id=i.issue_id) $open_date_query_bit $status_query_bit order by i.issue_id desc select i.issue_id, u.user_id, u.first_names as users_first_names, u.last_name as users_last_name, id.user_identification_id, i.order_id, to_char(open_date,'YYYY-MM-DD HH24:MI:SS') as full_open_date, to_char(close_date,'YYYY-MM-DD HH24:MI:SS') as full_close_date, m.issue_type from ec_customer_service_issues i, cc_users u, ec_user_identification id, ec_cs_issue_type_map m where i.user_identification_id = id.user_identification_id and id.user_id = u.user_id (+) and i.issue_id = m.issue_id $open_date_query_bit $status_query_bit $issue_type_query_bit order by $order_by_sql select i.issue_id, u.user_id, u.first_names as users_first_names, u.last_name as users_last_name, id.user_identification_id, i.order_id, to_char(open_date,'YYYY-MM-DD HH24:MI:SS') as full_open_date, to_char(close_date,'YYYY-MM-DD HH24:MI:SS') as full_close_date, m.issue_type from ec_customer_service_issues i, cc_users u, ec_user_identification id, ec_cs_issue_type_map m where i.user_identification_id = id.user_identification_id and id.user_id = u.user_id (+) and i.issue_id = m.issue_id and m.issue_type=:view_issue_type $open_date_query_bit $status_query_bit order by $order_by_sql