select i.instance_id, a.application_name, wt.workflow_type_name, w_to_s.state_name to_state, w_from_s.state_name from_state, --ip.property_name, ip.property_value from stategps.t_gps_instances i, stategps.t_gps_applications a, stategps.t_gps_workflow_types wt, stategps.t_gps_workflow_states w_to_s, stategps.t_gps_workflow_states w_from_s, stategps.t_gps_instance_properties ip where i.application_id=a.application_id(+) and i.workflow_type_id=wt.workflow_type_id(+) and i.current_state_id=w_to_s.state_id(+) and i.from_state_id=w_from_s.state_id(+) and i.instance_id=ip.instance_id Order By i.instance_id, i.current_state_id