Monday, May 8, 2017

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

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect