Query To Get The Project Funding Details

SELECT

agreement_num,

segment1 PROJECT_NUMBER,

NAME PROJECT_NAME,

LONG_NAME PROJECT_LONG_NAME,

TASK_NUMBER,

ALLOCATED_AMOUNT,

submit_baseline_flag

FROM

pa_project_fundings A,

pa_tasks b,

pa_projects_all c,

pa_agreements_all d

WHERE a.project_id = c.project_id

AND a.task_id = b.task_id

AND a.agreement_id = d.agreement_id

AND c.project_type IN ('YOUR PROJECT TYPES')

--AND a.creation_date LIKE '01-OCT-06'