VIEW: APPS.IGS_OR_UNIT_FUNDSRC_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'