SELECT s.task_type , o.entity_code , a.attribute_code , s.TASK_TYPE_ID , s.ORCHESTRATION_APPLICATION_ID , s.TASK_SUB_TYPE_CODE , s.SEEDED_FLAG FROM fusion.doo_tls_attribute_details t , fusion.doo_attributes_b a , fusion.doo_TASK_TYPES_B s , fusion.doo_objects_b o WHERE a.attribute_id =t.attribute_id AND s.task_type_id=t.tlservice_id AND t.entity_id =o.entity_id AND task_type LIKE '%' ORDER BY s.TASK_TYPE , o.entity_code , a.attribute_code