1. Tables and Views for Project Management
  2. GMS_FUNDING_SOURCES_S_V

GMS_FUNDING_SOURCES_S_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

FUNDING_SOURCE_ID

SOURCE_ID

TYPE

ORGANIZATION_ID

PARTY_ID

SPONSOR_STATUS

FUNDING_SOURCE_NAME

FUNDING_SOURCE_NUMBER

Query

SQL_Statement

select FUNDINGSOURCEEO.FUNDING_SOURCE_ID,

FUNDINGSOURCEEO.SOURCE_ID,

FUNDINGSOURCEEO.type,

ORGANIZATIONPEO.ORGANIZATION_ID,

PARTYPEO.PARTY_ID,

PARTYPEO.STATUS as SPONSOR_STATUS,

DECODE(FUNDINGSOURCEEO.type, 'O', ORGANIZATIONPEO.name,'S', PARTYPEO.PARTY_NAME, FUNDINGSOURCEEO.FUNDING_SOURCE_NAME) as FUNDING_SOURCE_NAME,

FUNDINGSOURCEEO.FUNDING_SOURCE_NUMBER

from GMS_FUNDING_SOURCES_VL FUNDINGSOURCEEO,

HR_ORGANIZATION_UNITS_F_TL ORGANIZATIONPEO,

HZ_PARTIES PARTYPEO

where FUNDINGSOURCEEO.SOURCE_ID =ORGANIZATIONPEO.ORGANIZATION_ID(+)

and ORGANIZATIONPEO.LANGUAGE(+) = USERENV('LANG')

and TRUNC(sysdate) between ORGANIZATIONPEO.EFFECTIVE_START_DATE(+) and

ORGANIZATIONPEO.EFFECTIVE_END_DATE(+)

and FUNDINGSOURCEEO.SOURCE_ID = PARTYPEO.PARTY_ID(+)