eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_OR_UNIT_HIST_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT OUH1.ORG_UNIT_CD
, OUH1.OU_START_DT
, OUH1.HIST_START_DT
, OUH1.HIST_END_DT
, OUH1.HIST_WHO
, NVL( OUH1.OU_END_DT
, NVL(IGS_GE_DATE.IGSDATE( IGS_AU_GEN_003.AUDP_GET_OUH_COL( 'OU_END_DT'
, OUH1.ORG_UNIT_CD
, OUH1.OU_START_DT
, OUH1.HIST_END_DT))
, IHP.OU_END_DT)) END_DT
, NVL( OUH1.DESCRIPTION
, NVL( IGS_AU_GEN_003.AUDP_GET_OUH_COL( 'DESCRIPTION'
, OUH1.ORG_UNIT_CD
, OUH1.OU_START_DT
, OUH1.HIST_END_DT)
, HP.PARTY_NAME)) DESCRIPTION
, NVL( OUH1.ORG_STATUS
, NVL( IGS_AU_GEN_003.AUDP_GET_OUH_COL( 'ORG_STATUS'
, OUH1.ORG_UNIT_CD
, OUH1.OU_START_DT
, OUH1.HIST_END_DT)
, IHP.OU_ORG_STATUS)) ORG_STATUS
, NVL( OUH1.ORG_TYPE
, NVL( IGS_AU_GEN_003.AUDP_GET_OUH_COL( 'ORG_TYPE'
, OUH1.ORG_UNIT_CD
, OUH1.OU_START_DT
, OUH1.HIST_END_DT)
, IHP.OU_ORG_TYPE)) ORG_TYPE
, NVL( OUH1.MEMBER_TYPE
, NVL( IGS_AU_GEN_003.AUDP_GET_OUH_COL( 'MEMBER_TYPE'
, OUH1.ORG_UNIT_CD
, OUH1.OU_START_DT
, OUH1.HIST_END_DT)
, IHP.OU_MEMBER_TYPE)) MEMBER_TYPE
, NVL( OUH1.INSTITUTION_CD
, NVL( IGS_AU_GEN_003.AUDP_GET_OUH_COL( 'INSTITUTION_CD'
, OUH1.ORG_UNIT_CD
, OUH1.OU_START_DT
, OUH1.HIST_END_DT)
, IHP.INSTITUTION_CD)) INSTITUTION_CD
, NVL( OUH1.NAME
, NVL( IGS_AU_GEN_003.AUDP_GET_OUH_COL( 'NAME'
, OUH1.ORG_UNIT_CD
, OUH1.OU_START_DT
, OUH1.HIST_END_DT)
, HP_INST.PARTY_NAME)) NAME
, OUH1.CREATED_BY
, OUH1.CREATION_DATE
, OUH1.LAST_UPDATED_BY
, OUH1.LAST_UPDATE_DATE
, OUH1.LAST_UPDATE_LOGIN FROM IGS_OR_UNIT_HIST_ALL OUH1
, IGS_PE_HZ_PARTIES IHP
, HZ_PARTIES HP
, HZ_PARTIES HP_INST
, IGS_PE_HZ_PARTIES IHP_INST
WHERE IHP.OSS_ORG_UNIT_CD = OUH1.ORG_UNIT_CD
AND HP.PARTY_ID = IHP.PARTY_ID
AND IHP.INSTITUTION_CD = IHP_INST.OSS_ORG_UNIT_CD
AND IHP_INST.PARTY_ID = HP_INST.PARTY_ID UNION ALL SELECT HP2.PARTY_NUMBER
, IHP2.OU_START_DT
, HP2.LAST_UPDATE_DATE
, TO_DATE(NULL)
, HP2.LAST_UPDATED_BY
, IHP2.OU_END_DT
, HP2.PARTY_NAME
, IHP2.OU_ORG_STATUS
, IHP2.OU_ORG_TYPE
, IHP2.OU_MEMBER_TYPE
, IHP2.INSTITUTION_CD
, HP_INST2.PARTY_NAME
, HP2.CREATED_BY
, HP2.CREATION_DATE
, HP2.LAST_UPDATED_BY
, HP2.LAST_UPDATE_DATE
, HP2.LAST_UPDATE_LOGIN
FROM HZ_PARTIES HP2
, IGS_PE_HZ_PARTIES IHP2
, HZ_PARTIES HP_INST2
, IGS_PE_HZ_PARTIES IHP_INST2
WHERE HP2.PARTY_ID = IHP2.PARTY_ID
AND IHP2.INST_ORG_IND = 'O'
AND IHP2.INSTITUTION_CD = IHP_INST2.OSS_ORG_UNIT_CD
AND IHP_INST2.PARTY_ID = HP_INST2.PARTY_ID GROUP BY HP2.PARTY_NUMBER
, IHP2.OU_START_DT
, IHP2.OU_END_DT
, HP2.PARTY_NAME
, IHP2.OU_ORG_STATUS
, IHP2.OU_ORG_TYPE
, IHP2.OU_MEMBER_TYPE
, IHP2.INSTITUTION_CD
, HP_INST2.PARTY_NAME
, HP2.CREATED_BY
, HP2.CREATION_DATE
, HP2.LAST_UPDATED_BY
, HP2.LAST_UPDATE_DATE
, HP2.LAST_UPDATE_LOGIN

Columns

Name
ORG_UNIT_CD
OU_START_DT
HIST_START_DT
HIST_END_DT
HIST_WHO
END_DT
DESCRIPTION
ORG_STATUS
ORG_TYPE
MEMBER_TYPE
INSTITUTION_CD
NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN