GMS_FUNDING_SOURCES_ALL_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
FUNDING_SOURCE_ID SOURCE_ID TYPE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER ORGANIZATION_ID ORG_STATUS PARTY_ID SPONSOR_STATUS FUNDING_SOURCE_TYPE FUNDING_SOURCE_NAME FUNDING_SOURCE_NUMBER START_DATE_ACTIVE END_DATE_ACTIVE STATUS_CODE

Query

SQL_Statement

SELECT FundingSourceEO.FUNDING_SOURCE_ID, FundingSourceEO.SOURCE_ID, FundingSourceEO.TYPE, FundingSourceEO.CREATED_BY, FundingSourceEO.CREATION_DATE, FundingSourceEO.LAST_UPDATE_DATE, FundingSourceEO.LAST_UPDATE_LOGIN, FundingSourceEO.LAST_UPDATED_BY, FundingSourceEO.OBJECT_VERSION_NUMBER, OrganizationPEO.ORGANIZATION_ID, OrganizationPEO.STATUS org_status, PartyPEO.PARTY_ID, PartyPEO.STATUS sponsor_status, GmsLookupPEO.MEANING funding_source_type, decode(FundingSourceEO.TYPE, 'O', OrganizationPEO.NAME, decode(FundingSourceEO.TYPE, 'S', PartyPEO.PARTY_NAME, FundingSourceEO.FUNDING_SOURCE_NAME )) Funding_source_name, FundingSourceEO.FUNDING_SOURCE_NUMBER, DECODE (FundingSourceEO.TYPE, 'O', OrganizationPEO.EFFECTIVE_START_DATE, 'N', FundingSourceEO.START_DATE_ACTIVE) START_DATE_ACTIVE, DECODE (FundingSourceEO.TYPE, 'O', OrganizationPEO.EFFECTIVE_END_DATE, 'N', FundingSourceEO.END_DATE_ACTIVE) END_DATE_ACTIVE, FundingSourceEO.STATUS_CODE FROM GMS_FUNDING_SOURCES_VL FundingSourceEO, GMS_ORGANIZATIONS_V OrganizationPEO, HZ_PARTIES PartyPEO, GMS_LOOKUPS GmsLookupPEO WHERE FundingSourceEO.SOURCE_ID=OrganizationPEO.ORGANIZATION_ID(+) and FundingSourceEO.SOURCE_ID = PartyPEO.PARTY_ID(+) AND FundingSourceEO.TYPE = GmsLookupPEO.LOOKUP_CODE AND GmsLookupPEO.LOOKUP_TYPE='ORA_GMS_FUNDING_SOURCE_TYPE'