Monday, May 8, 2017

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'

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect