Query To Get Project Chargeable Tasks

SELECT

B.segment1 PROJECT_NUMBER,

B.NAME,

B.project_status_code project_status,

task_number,

task_name,

service_type_code

FROM

PA_TASKS A,

PA_PROJECTS_ALL B

WHERE a.project_id = b.project_id

AND b.project_type IN ('Your Project Types')

--AND task_number LIKE 'Task Number%'

AND chargeable_flag = 'Y'

ORDER BY B.project_status_code, B.segment1, B.NAME, task_number