1. Tables and Views for Project Management
  2. GMS_AWARD_HEADERS_INFO_V

GMS_AWARD_HEADERS_INFO_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

ACTIVE_PI_ID

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

ATTRIBUTE_TIMESTAMP6

ATTRIBUTE_TIMESTAMP7

ATTRIBUTE_TIMESTAMP8

ATTRIBUTE_TIMESTAMP9

ATTRIBUTE_TIMESTAMP10

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

AWARD_OWNING_ORG_ID

CONTRACT_NUMBER_SEG

AWARD_TYPE_NAME

AWARD_PURPOSE_NAME

BU_ID

AWARD_BUSINESS_UNIT_NAME

PI_NAME

PERSON_NUMBER

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 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 CONTRACT_NAME,

ContractHeaderPEO.CONTRACT_NUMBER,

ContractHeaderPEO.CURRENCY_CODE,

AwardHeaderEO.SPONSOR_ID,

ContractHeaderPEO.CONTRACT_TYPE_ID,

AwardPI.active_pi_id,

AwardHeaderEO.ATTRIBUTE_NUMBER6,

AwardHeaderEO.ATTRIBUTE_NUMBER7,

AwardHeaderEO.ATTRIBUTE_NUMBER8,

AwardHeaderEO.ATTRIBUTE_NUMBER9,

AwardHeaderEO.ATTRIBUTE_NUMBER10,

AwardHeaderEO.ATTRIBUTE_DATE6,

AwardHeaderEO.ATTRIBUTE_DATE7,

AwardHeaderEO.ATTRIBUTE_DATE8,

AwardHeaderEO.ATTRIBUTE_DATE9,

AwardHeaderEO.ATTRIBUTE_DATE10,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP1,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP2,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP3,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP4,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP5,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP6,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP7,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP8,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP9,

AwardHeaderEO.ATTRIBUTE_TIMESTAMP10,

AwardHeaderEO.ATTRIBUTE1,

AwardHeaderEO.ATTRIBUTE2,

AwardHeaderEO.ATTRIBUTE3,

AwardHeaderEO.ATTRIBUTE4,

AwardHeaderEO.ATTRIBUTE5,

AwardHeaderEO.ATTRIBUTE6,

AwardHeaderEO.ATTRIBUTE7,

AwardHeaderEO.ATTRIBUTE8,

AwardHeaderEO.ATTRIBUTE9,

AwardHeaderEO.ATTRIBUTE10,

AwardHeaderEO.ATTRIBUTE11,

AwardHeaderEO.ATTRIBUTE12,

AwardHeaderEO.ATTRIBUTE13,

AwardHeaderEO.ATTRIBUTE14,

AwardHeaderEO.ATTRIBUTE15,

AwardHeaderEO.ATTRIBUTE16,

AwardHeaderEO.ATTRIBUTE17,

AwardHeaderEO.ATTRIBUTE18,

AwardHeaderEO.ATTRIBUTE19,

AwardHeaderEO.ATTRIBUTE20,

AwardHeaderEO.ATTRIBUTE_NUMBER1,

AwardHeaderEO.ATTRIBUTE_NUMBER2,

AwardHeaderEO.ATTRIBUTE_NUMBER3,

AwardHeaderEO.ATTRIBUTE_NUMBER4,

AwardHeaderEO.ATTRIBUTE_NUMBER5,

AwardHeaderEO.ATTRIBUTE_DATE1,

AwardHeaderEO.ATTRIBUTE_DATE2,

AwardHeaderEO.ATTRIBUTE_DATE3,

AwardHeaderEO.ATTRIBUTE_DATE4,

AwardHeaderEO.ATTRIBUTE_DATE5,

AwardHeaderEO.AWARD_OWNING_ORG_ID,

SUBSTR(ContractHeaderPEO.contract_number,1,50) CONTRACT_NUMBER_SEG,

AwardType.MEANING AWARD_TYPE_NAME,

AwardPurpose.MEANING AWARD_PURPOSE_NAME,

ContractHeaderPEO.ORG_ID BU_ID,

OrgUnitTranslationPEO.NAME AWARD_BUSINESS_UNIT_NAME,

AwardPI.PI_NAME,

AwardPI.PERSON_NUMBER

FROM GMS_AWARD_HEADERS_B AwardHeaderEO,

OKC_K_HEADERS_VL ContractHeaderPEO,

gms_award_pi_v AwardPI,

GMS_LOOKUPS AwardType,

GMS_LOOKUPS AwardPurpose,

HR_ORGANIZATION_UNITS_F_TL OrgUnitTranslationPEO

WHERE AwardHeaderEO.id = ContractHeaderPEO.ID

AND ContractHeaderPEO.version_type = 'C'

AND AwardHeaderEO.ID = AwardPI.ID

AND AwardHeaderEO.AWARD_TYPE = AwardType.LOOKUP_CODE(+)

AND AwardType.LOOKUP_TYPE(+) = 'ORA_GMS_AWARD_TYPE'

AND AwardHeaderEO.AWARD_PURPOSE_CODE = AwardPurpose.LOOKUP_CODE(+)

AND AwardPurpose.LOOKUP_TYPE(+) = 'ORA_GMS_AWARD_PURPOSE_CODE'

AND ContractHeaderPEO.ORG_ID = OrgUnitTranslationPEO.ORGANIZATION_ID

AND TRUNC(sysdate) BETWEEN OrgUnitTranslationPEO.EFFECTIVE_START_DATE AND OrgUnitTranslationPEO.EFFECTIVE_END_DATE

AND OrgUnitTranslationPEO.LANGUAGE = USERENV('LANG')