View: IGS_OR_UNIT_FUNDSRC_V

Product:	IGS - Student System
Description:	View of all organization units joined to all funding source to use in ADMF2M44
Implementation/DBA Data:	APPS.IGS_OR_UNIT_FUNDSRC_V

View Text

SELECT HZ.PARTY_NUMBER TCA_PARTY_NUMBER
, PEP.OSS_ORG_UNIT_CD ORG_UNIT_CD
, PEP.OU_START_DT
, PEP.OU_END_DT
, HZ.PARTY_NAME OU_DESCRIPTION
, PEP.OU_ORG_STATUS
, PEP.OU_ORG_TYPE
, PEP.OU_MEMBER_TYPE
, PEP.INSTITUTION_CD
, FS.FUNDING_SOURCE
, FS.DESCRIPTION FS_DESCRIPTION
, FS.GOVT_FUNDING_SOURCE
, FS.CLOSED_IND
, HZ.CREATED_BY
, HZ.CREATION_DATE
, HZ.LAST_UPDATED_BY
, HZ.LAST_UPDATE_DATE
, HZ.LAST_UPDATE_LOGIN
FROM HZ_PARTIES HZ
, IGS_PE_HZ_PARTIES PEP
, IGS_FI_FUND_SRC FS
WHERE HZ.PARTY_ID = PEP.PARTY_ID
AND PEP.INST_ORG_IND = 'O'

Columns