1. Tables and Views for Project Management
  2. GMS_AWARD_CONTRACTS_SEG_V

GMS_AWARD_CONTRACTS_SEG_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

CONTRACT_ID

CONTRACT_NUMBER_SEG

CONTRACT_NAME

LANGUAGE

Query

SQL_Statement

SELECT contracts_b.ID AS CONTRACT_ID,

SUBSTR(contracts_b.contract_number,1,50) AS CONTRACT_NUMBER_SEG,

contracts_tl.cognomen AS CONTRACT_NAME,

contracts_tl. language

FROM okc_k_headers_all_b contracts_b,

okc_k_headers_tl contracts_tl,

gms_award_headers_b award

WHERE award.id =contracts_b.id

AND contracts_b.id =contracts_tl.id

AND contracts_b.version_type = 'C'

AND contracts_b.major_version = contracts_tl.major_version