GMS_AWARD_FUNDINGSOURCES_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
ID PROJECT_ID AWARD_ID AWARD_FUNDING_SOURCE_ID FUNDING_SOURCE_ID TYPE FUNDING_SOURCE_NAME FUNDING_SOURCE_NUMBER

Query

SQL_Statement

SELECT GmsAwardProjectFundingSourceEO.AWD_PRJ_FUND_SOURCE_ID AS ID, GmsAwardProjectFundingSourceEO.PROJECT_ID, GmsAwardProjectFundingSourceEO.AWARD_ID, GmsAwardProjectFundingSourceEO.AWARD_FUNDING_SOURCE_ID, GmsAwardProjectFundingSourceEO.FUNDING_SOURCE_ID, GmsFundingSourcesVL.TYPE, DECODE(GmsFundingSourcesVL.TYPE, 'O', OrgUnitTranslationPEO.NAME, 'S', PartyPEO.PARTY_NAME, GmsFundingSourcesVL.FUNDING_SOURCE_NAME ) AS FUNDING_SOURCE_NAME, GmsFundingSourcesVL.FUNDING_SOURCE_NUMBER FROM GMS_AWD_PRJ_FND_SOURCES GmsAwardProjectFundingSourceEO, GMS_FUNDING_SOURCES_VL GmsFundingSourcesVL, HR_ORGANIZATION_UNITS_F_TL OrgUnitTranslationPEO, HR_ORG_UNIT_CLASSIFICATIONS_F OUC, HZ_PARTIES PartyPEO WHERE GmsAwardProjectFundingSourceEO.FUNDING_SOURCE_ID = GmsFundingSourcesVL.FUNDING_SOURCE_ID AND GmsFundingSourcesVL.SOURCE_ID = OrgUnitTranslationPEO.ORGANIZATION_ID (+) AND TRUNC(SYSDATE) BETWEEN OrgUnitTranslationPEO.EFFECTIVE_START_DATE(+) AND OrgUnitTranslationPEO.EFFECTIVE_END_DATE(+) AND OrgUnitTranslationPEO.LANGUAGE(+) = USERENV('LANG') AND OrgUnitTranslationPEO.ORGANIZATION_ID = OUC.ORGANIZATION_ID(+) AND TRUNC(SYSDATE) BETWEEN OUC.EFFECTIVE_START_DATE(+) AND OUC.EFFECTIVE_END_DATE(+) AND OUC.CLASSIFICATION_CODE(+) = 'PA_PROJECT_ORG' AND OUC.STATUS(+) IN ( 'A', 'ACTIVE') AND GmsFundingSourcesVL.SOURCE_ID = PartyPEO.PARTY_ID(+)