1. Tables and Views for Project Management
  2. GMS_AWARD_CONTRACTS_SEG_XCC_V

GMS_AWARD_CONTRACTS_SEG_XCC_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_TL. LANGUAGE =USERENV('LANG')

AND CONTRACTS_B.MAJOR_VERSION = CONTRACTS_TL.MAJOR_VERSION