GMS_AWD_PRJ_LNKGS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
AWARD_ID PROJECT_ID TASK_ID

Query

SQL_Statement
SELECT distinct a.award_id, b.Project_id, a.Task_Id FROM GMS_AWARD_FUND_ALLOCATIONS a, GMS_AWARD_PROJECTS b WHERE a.project_id = b.id