GMS_PROJECT_AWARD_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
ID AWARD_ID PROJECT_ID CONTRACT_ID CONTRACT_NUMBER COGNOMEN

Query

SQL_Statement
SELECT a.id, a.award_id, a.project_id, b.id contract_id, b.contract_number, b.cognomen FROM gms_award_projects a, okc_k_headers_vl b where a.award_id = b.id and b.version_type = 'C'