GMS_XLA_AWARD_REF_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name

CONTRACT_ID CONTRACT_NAME CONTRACT_NUMBER CUSTOMER_NAME CUSTOMER_NUMBER CUSTOMER_CLASS_CATEGORY CUSTOMER_CLASS_NAME CONTRACT_OWNING_ORG_NAME CONTRACT_OWN_ORG_COMPANY CONTRACT_OWN_ORG_COST_CENTER CONTRACT_ORGANIZATION_NAME CONTRACT_LEGAL_ENTITY_NAME AWARD_INSTITUTION AWARD_TYPE_NAME AWARD_PURPOSE_NAME AWARD_CONTEXT_CATEGORY AWARD_ATTRIBUTE_TEXT1 AWARD_ATTRIBUTE_TEXT2 AWARD_ATTRIBUTE_TEXT3 AWARD_ATTRIBUTE_TEXT4 AWARD_ATTRIBUTE_TEXT5 AWARD_ATTRIBUTE_TEXT6 AWARD_ATTRIBUTE_TEXT7 AWARD_ATTRIBUTE_TEXT8 AWARD_ATTRIBUTE_TEXT9 AWARD_ATTRIBUTE_TEXT10 AWARD_ATTRIBUTE_TEXT11 AWARD_ATTRIBUTE_TEXT12 AWARD_ATTRIBUTE_TEXT13 AWARD_ATTRIBUTE_TEXT14 AWARD_ATTRIBUTE_TEXT15 AWARD_ATTRIBUTE_TEXT16 AWARD_ATTRIBUTE_TEXT17 AWARD_ATTRIBUTE_TEXT18 AWARD_ATTRIBUTE_TEXT19 AWARD_ATTRIBUTE_TEXT20 AWARD_ATTRIBUTE_NUM1 AWARD_ATTRIBUTE_NUM2 AWARD_ATTRIBUTE_NUM3 AWARD_ATTRIBUTE_NUM4 AWARD_ATTRIBUTE_NUM5 AWARD_ATTRIBUTE_NUM6 AWARD_ATTRIBUTE_NUM7 AWARD_ATTRIBUTE_NUM8 AWARD_ATTRIBUTE_NUM9 AWARD_ATTRIBUTE_NUM10 AWARD_ATTRIBUTE_DATE1 AWARD_ATTRIBUTE_DATE2 AWARD_ATTRIBUTE_DATE3 AWARD_ATTRIBUTE_DATE4 AWARD_ATTRIBUTE_DATE5 AWARD_ATTRIBUTE_DATE6 AWARD_ATTRIBUTE_DATE7 AWARD_ATTRIBUTE_DATE8 AWARD_ATTRIBUTE_DATE9 AWARD_ATTRIBUTE_DATE10 AWARD_ATTRIBUTE_TIMESTAMP1 AWARD_ATTRIBUTE_TIMESTAMP2 AWARD_ATTRIBUTE_TIMESTAMP3 AWARD_ATTRIBUTE_TIMESTAMP4 AWARD_ATTRIBUTE_TIMESTAMP5 AWARD_ATTRIBUTE_TIMESTAMP6 AWARD_ATTRIBUTE_TIMESTAMP7 AWARD_ATTRIBUTE_TIMESTAMP8 AWARD_ATTRIBUTE_TIMESTAMP9 AWARD_ATTRIBUTE_TIMESTAMP10 FEDERAL_SPONSOR FUNDING_SOURCE_ID FUNDING_SOURCE_NAME FUNDING_SOURCE_TYPE PROJECT_ID AWARDPRJ_ATTRIBUTE_CATEGORY AWARDPRJ_ATTRIBUTE_NUMBER1 AWARDPRJ_ATTRIBUTE_NUMBER2 AWARDPRJ_ATTRIBUTE_NUMBER3 AWARDPRJ_ATTRIBUTE_NUMBER4 AWARDPRJ_ATTRIBUTE_NUMBER5 AWARDPRJ_ATTRIBUTE_NUMBER6 AWARDPRJ_ATTRIBUTE_NUMBER7 AWARDPRJ_ATTRIBUTE_NUMBER8 AWARDPRJ_ATTRIBUTE_NUMBER9 AWARDPRJ_ATTRIBUTE_NUMBER10 AWARDPRJ_ATTRIBUTE_DATE1 AWARDPRJ_ATTRIBUTE_DATE2 AWARDPRJ_ATTRIBUTE_DATE3 AWARDPRJ_ATTRIBUTE_DATE4 AWARDPRJ_ATTRIBUTE_DATE5 AWARDPRJ_ATTRIBUTE_DATE6 AWARDPRJ_ATTRIBUTE_DATE7 AWARDPRJ_ATTRIBUTE_DATE8 AWARDPRJ_ATTRIBUTE_DATE9 AWARDPRJ_ATTRIBUTE_DATE10 AWARDPRJ_ATTRIBUTE1 AWARDPRJ_ATTRIBUTE2 AWARDPRJ_ATTRIBUTE3 AWARDPRJ_ATTRIBUTE4 AWARDPRJ_ATTRIBUTE5 AWARDPRJ_ATTRIBUTE6 AWARDPRJ_ATTRIBUTE7 AWARDPRJ_ATTRIBUTE8 AWARDPRJ_ATTRIBUTE9 AWARDPRJ_ATTRIBUTE10 AWARDPRJ_ATTRIBUTE11 AWARDPRJ_ATTRIBUTE12 AWARDPRJ_ATTRIBUTE13 AWARDPRJ_ATTRIBUTE14 AWARDPRJ_ATTRIBUTE15 AWARDPRJ_ATTRIBUTE16 AWARDPRJ_ATTRIBUTE17 AWARDPRJ_ATTRIBUTE18 AWARDPRJ_ATTRIBUTE19 AWARDPRJ_ATTRIBUTE20 AWARDPRJ_ATTRIBUTE_TIMESTAMP1 AWARDPRJ_ATTRIBUTE_TIMESTAMP2 AWARDPRJ_ATTRIBUTE_TIMESTAMP3 AWARDPRJ_ATTRIBUTE_TIMESTAMP4 AWARDPRJ_ATTRIBUTE_TIMESTAMP5 AWARDPRJ_ATTRIBUTE_TIMESTAMP6 AWARDPRJ_ATTRIBUTE_TIMESTAMP7 AWARDPRJ_ATTRIBUTE_TIMESTAMP8 AWARDPRJ_ATTRIBUTE_TIMESTAMP9 AWARDPRJ_ATTRIBUTE_TIMESTAMP10

Query

SQL_Statement

SELECT contract.id contract_id, contract.id contract_name, contract.contract_number contract_number, sponsor.party_id customer_name, party.party_number customer_number, null as customer_class_category, accounts.customer_class_code customer_class_name, award.award_owning_org_id contract_owning_org_name, pjc_accounting_pvt.get_company_info(award.award_owning_org_id) contract_own_org_company, pjc_accounting_pvt.get_costcenter_info(award.award_owning_org_id) contract_own_org_cost_center, contract.org_id contract_organization_name, contract.legal_entity_id contract_legal_entity_name, award.institution_id award_institution, award.award_type award_type_name, award.award_purpose_code award_purpose_name, award.attribute_category award_context_category, award.attribute1 award_attribute_text1, award.attribute2 award_attribute_text2, award.attribute3 award_attribute_text3, award.attribute4 award_attribute_text4, award.attribute5 award_attribute_text5, award.attribute6 award_attribute_text6, award.attribute7 award_attribute_text7, award.attribute8 award_attribute_text8, award.attribute9 award_attribute_text9, award.attribute10 award_attribute_text10, award.attribute11 award_attribute_text11, award.attribute12 award_attribute_text12, award.attribute13 award_attribute_text13, award.attribute14 award_attribute_text14, award.attribute15 award_attribute_text15, award.attribute16 award_attribute_text16, award.attribute17 award_attribute_text17, award.attribute18 award_attribute_text18, award.attribute19 award_attribute_text19, award.attribute20 award_attribute_text20, award.attribute_number1 award_attribute_num1, award.attribute_number2 award_attribute_num2, award.attribute_number3 award_attribute_num3, award.attribute_number4 award_attribute_num4, award.attribute_number5 award_attribute_num5, award.attribute_number6 award_attribute_num6, award.attribute_number7 award_attribute_num7, award.attribute_number8 award_attribute_num8, award.attribute_number9 award_attribute_num9, award.attribute_number10 award_attribute_num10, award.attribute_date1 award_attribute_date1, award.attribute_date2 award_attribute_date2, award.attribute_date3 award_attribute_date3, award.attribute_date4 award_attribute_date4, award.attribute_date5 award_attribute_date5, award.attribute_date6 award_attribute_date6, award.attribute_date7 award_attribute_date7, award.attribute_date8 award_attribute_date8, award.attribute_date9 award_attribute_date9, award.attribute_date10 award_attribute_date10, award.attribute_timestamp1 award_attribute_timestamp1, award.attribute_timestamp2 award_attribute_timestamp2, award.attribute_timestamp3 award_attribute_timestamp3, award.attribute_timestamp4 award_attribute_timestamp4, award.attribute_timestamp5 award_attribute_timestamp5, award.attribute_timestamp6 award_attribute_timestamp6, award.attribute_timestamp7 award_attribute_timestamp7, award.attribute_timestamp8 award_attribute_timestamp8, award.attribute_timestamp9 award_attribute_timestamp9, award.attribute_timestamp10 award_attribute_timestamp10, sponsor.federal_flag federal_sponsor, award_funding_source.funding_source_id funding_source_id, award_funding_source.funding_source_id funding_source_name, funding_source.type funding_source_type, award_project.project_id, award_project.attribute_category awardprj_attribute_category, award_project.attribute_number1 awardprj_attribute_number1, award_project.attribute_number2 awardprj_attribute_number2, award_project.attribute_number3 awardprj_attribute_number3, award_project.attribute_number4 awardprj_attribute_number4, award_project.attribute_number5 awardprj_attribute_number5, award_project.attribute_number6 awardprj_attribute_number6, award_project.attribute_number7 awardprj_attribute_number7, award_project.attribute_number8 awardprj_attribute_number8, award_project.attribute_number9 awardprj_attribute_number9, award_project.attribute_number10 awardprj_attribute_number10, award_project.attribute_date1 awardprj_attribute_date1, award_project.attribute_date2 awardprj_attribute_date2, award_project.attribute_date3 awardprj_attribute_date3, award_project.attribute_date4 awardprj_attribute_date4, award_project.attribute_date5 awardprj_attribute_date5, award_project.attribute_date6 awardprj_attribute_date6, award_project.attribute_date7 awardprj_attribute_date7, award_project.attribute_date8 awardprj_attribute_date8, award_project.attribute_date9 awardprj_attribute_date9, award_project.attribute_date10 awardprj_attribute_date10, award_project.attribute1 awardprj_attribute1, award_project.attribute2 awardprj_attribute2, award_project.attribute3 awardprj_attribute3, award_project.attribute4 awardprj_attribute4, award_project.attribute5 awardprj_attribute5, award_project.attribute6 awardprj_attribute6, award_project.attribute7 awardprj_attribute7, award_project.attribute8 awardprj_attribute8, award_project.attribute9 awardprj_attribute9, award_project.attribute10 awardprj_attribute10, award_project.attribute11 awardprj_attribute11, award_project.attribute12 awardprj_attribute12, award_project.attribute13 awardprj_attribute13, award_project.attribute14 awardprj_attribute14, award_project.attribute15 awardprj_attribute15, award_project.attribute16 awardprj_attribute16, award_project.attribute17 awardprj_attribute17, award_project.attribute18 awardprj_attribute18, award_project.attribute19 awardprj_attribute19, award_project.attribute20 awardprj_attribute20, trunc(award_project.attribute_timestamp1) awardprj_attribute_timestamp1, trunc(award_project.attribute_timestamp2) awardprj_attribute_timestamp2, trunc(award_project.attribute_timestamp3) awardprj_attribute_timestamp3, trunc(award_project.attribute_timestamp4) awardprj_attribute_timestamp4, trunc(award_project.attribute_timestamp5) awardprj_attribute_timestamp5, trunc(award_project.attribute_timestamp6) awardprj_attribute_timestamp6, trunc(award_project.attribute_timestamp7) awardprj_attribute_timestamp7, trunc(award_project.attribute_timestamp8) awardprj_attribute_timestamp8, trunc(award_project.attribute_timestamp9) awardprj_attribute_timestamp9, trunc(award_project.attribute_timestamp10) awardprj_attribute_timestamp10 FROM gms_award_headers_b award, okc_k_headers_all_b contract, gms_sponsors_b sponsor, hz_parties party, gms_award_funding_sources_b award_funding_source, gms_funding_sources_b funding_source, gms_award_projects award_project, hz_cust_accounts accounts,GMS_SPONSOR_ACCT_DETAILS_B sponsor_accounts WHERE award.id =contract.id AND award.sponsor_id =sponsor.sponsor_id AND sponsor.party_id =party.party_id AND sponsor.sponsor_id = sponsor_accounts.sponsor_id AND sponsor_accounts.primary_flag='Y' AND accounts.cust_account_id =nvl(sponsor_accounts.related_sponsor_acct_id,sponsor_accounts.sponsor_acct_id ) AND award.id =award_project.award_id(+) AND award.id =award_funding_source.award_id AND award_funding_source.funding_source_id=funding_source.funding_source_id AND contract.version_type = 'C' AND accounts.STATUS='A'