GMS_AWARD_HEADERS_VL

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name

ID AWARD_TYPE AWARD_PURPOSE_CODE IDC_SCHEDULE_ID PRE_AWARD_DATE CLOSE_DATE COST_IND_SCH_FIXED_DATE PROPOSAL_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE ATTRIBUTE_CATEGORY VALIDATE_STATUS AMENDMENT_EFFECTIVE_DATE 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 LAST_UPDATE_LOGIN AWARD_OWNING_ORG_ID INSTITUTION_ID SPONSOR_AWARD_NUMBER DESCRIPTION SPONSOR_ID LAST_VALIDATED COI_INST_POLICY_COMPLIANT COI_REVIEW_COMPLETED COI_APPROVAL_DATE FT_PRIMARY_SPONSOR FT_FROM_DATE FT_TO_DATE FT_AMOUNT FT_IS_FEDERAL IS_INTELL_PROP_REPORTED PREV_AWARD_BU PREV_AWARD_ID PREV_AWARD_RENEWAL_INPRG PREV_AWARD_ABR PRE_AWARD_SPENDING_ALLOWED EXPANDED_AUTH_FLAG PRE_AWARD_GSF INTELL_PROP_DESC FT_REF_AWARD_NAME 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 TEMPLATE_FLAG SOURCE_TEMPLATE_ID BUSINESS_UNIT_ID SOURCE_AWARD_ID IFS_APPROVER_ID IFS_APPROVAL_DATE IFS_SPONSOR_APPROVAL_REQ_FLAG SUMMARY_REQUEST_ID AWARD_SOURCE CREATED_FROM DC_REQUEST_ID DC_STAGE

Query

SQL_Statement

SELECT B.ID, B.AWARD_TYPE, B.AWARD_PURPOSE_CODE, B.IDC_SCHEDULE_ID, B.PRE_AWARD_DATE, B.CLOSE_DATE, B.COST_IND_SCH_FIXED_DATE, B.PROPOSAL_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.ATTRIBUTE_CATEGORY, B.VALIDATE_STATUS, B.AMENDMENT_EFFECTIVE_DATE, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.ATTRIBUTE16, B.ATTRIBUTE17, B.ATTRIBUTE18, B.ATTRIBUTE19, B.ATTRIBUTE20, B.ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5, B.ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5, B.LAST_UPDATE_LOGIN, B.AWARD_OWNING_ORG_ID, B.INSTITUTION_ID, B.SPONSOR_AWARD_NUMBER, TL.DESCRIPTION, B.SPONSOR_ID, B.LAST_VALIDATED, B.COI_INST_POLICY_COMPLIANT, B.COI_REVIEW_COMPLETED, B.COI_APPROVAL_DATE, B.FT_PRIMARY_SPONSOR, B.FT_FROM_DATE, B.FT_TO_DATE, B.FT_AMOUNT, B.FT_IS_FEDERAL, B.IS_INTELL_PROP_REPORTED, B.PREV_AWARD_BU, B.PREV_AWARD_ID, B.PREV_AWARD_RENEWAL_INPRG, B.PREV_AWARD_ABR, B.PRE_AWARD_SPENDING_ALLOWED, B.EXPANDED_AUTH_FLAG, TL.PRE_AWARD_GSF, TL.INTELL_PROP_DESC, TL.FT_REF_AWARD_NAME, B.ATTRIBUTE_NUMBER6, B.ATTRIBUTE_NUMBER7, B.ATTRIBUTE_NUMBER8, B.ATTRIBUTE_NUMBER9, B.ATTRIBUTE_NUMBER10, B.ATTRIBUTE_DATE6, B.ATTRIBUTE_DATE7, B.ATTRIBUTE_DATE8, B.ATTRIBUTE_DATE9, B.ATTRIBUTE_DATE10, B.ATTRIBUTE_TIMESTAMP1, B.ATTRIBUTE_TIMESTAMP2, B.ATTRIBUTE_TIMESTAMP3, B.ATTRIBUTE_TIMESTAMP4, B.ATTRIBUTE_TIMESTAMP5, B.ATTRIBUTE_TIMESTAMP6, B.ATTRIBUTE_TIMESTAMP7, B.ATTRIBUTE_TIMESTAMP8, B.ATTRIBUTE_TIMESTAMP9, B.ATTRIBUTE_TIMESTAMP10, B.TEMPLATE_FLAG, B.SOURCE_TEMPLATE_ID, B.BUSINESS_UNIT_ID, B.SOURCE_AWARD_ID, B.IFS_APPROVER_ID, B.IFS_APPROVAL_DATE, B.IFS_SPONSOR_APPROVAL_REQ_FLAG, B.SUMMARY_REQUEST_ID, B.AWARD_SOURCE, B.CREATED_FROM, B.DC_REQUEST_ID, B.DC_STAGE FROM GMS_AWARD_HEADERS_B B, GMS_AWARD_HEADERS_TL TL WHERE B.ID = TL.ID AND TL.LANGUAGE = USERENV('LANG')