1. Tables and Views for Project Management
  2. GMS_AWARD_CONTRACT_V

GMS_AWARD_CONTRACT_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

ID

AWARD_PURPOSE_CODE

AWARD_TYPE

CLOSE_DATE

PRE_AWARD_DATE

ORG_ID

LEGAL_ENTITY_ID

CONTRACT_ID

MAJOR_VERSION

OWNING_ORG_ID

PRIMARY_ENT_PARTY_ID

END_DATE

START_DATE

STS_CODE

SPONSOR_AWARD_NUMBER

CONTRACT_NAME

CONTRACT_NUMBER

CURRENCY_CODE

SPONSOR_ID

CONTRACT_TYPE_ID

VALIDATE_STATUS

BUSINESS_UNIT_ID

Query

SQL_Statement

SELECT /*+ FIRST_ROWS(10) */

AwardHeaderEO.ID,

AwardHeaderEO.AWARD_PURPOSE_CODE,

AwardHeaderEO.AWARD_TYPE,

AwardHeaderEO.CLOSE_DATE,

AwardHeaderEO.PRE_AWARD_DATE,

ContractHeaderPEO.ORG_ID,

ContractHeaderPEO.LEGAL_ENTITY_ID,

ContractHeaderPEO.ID AS CONTRACT_ID,

ContractHeaderPEO.MAJOR_VERSION,

ContractHeaderPEO.OWNING_ORG_ID,

ContractHeaderPEO.PRIMARY_ENT_PARTY_ID,

ContractHeaderPEO.END_DATE,

ContractHeaderPEO.START_DATE,

ContractHeaderPEO.STS_CODE,

AwardHeaderEO.SPONSOR_AWARD_NUMBER,

ContractHeaderPEO.COGNOMEN as CONTRACT_NAME,

ContractHeaderPEO.CONTRACT_NUMBER,

ContractHeaderPEO.CURRENCY_CODE,

AwardHeaderEO.SPONSOR_ID,

ContractHeaderPEO.CONTRACT_TYPE_ID,

AwardHeaderEO.VALIDATE_STATUS,

awardheadereo.business_unit_id

FROM GMS_AWARD_HEADERS_VL AwardHeaderEO,

OKC_K_HEADERS_VL ContractHeaderPEO

WHERE AwardHeaderEO.id = ContractHeaderPEO.ID

AND ContractHeaderPEO.version_type = 'C'