[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT USXGM_CHLD.ROWID ROW_ID
, USXGM_CHLD.USEC_X_LISTED_GROUP_MEM_ID UNIT_SEC_CROSS_UNIT_SEC_ID
, USXGM.UOO_ID PARENT_UOO_ID
, USXGM_CHLD.UOO_ID CHILD_UOO_ID
, UOO.UNIT_CD CHILD_UNIT_CD
, UOO.VERSION_NUMBER CHILD_VERSION_NUMBER
, UV.TITLE CHILD_TITLE
, UOO.CAL_TYPE CHILD_CAL_TYPE
, CI.ALTERNATE_CODE CHILD_ALTERNATE_CODE
, CI.START_DT START_DT
, CI.END_DT END_DT
, UOO.CI_SEQUENCE_NUMBER CHILD_CI_SEQUENCE_NUMBER
, UOO.UNIT_CLASS CHILD_UNIT_CLASS
, UC.UNIT_MODE CHILD_UNIT_MODE
, UOO.LOCATION_CD CHILD_LOCATION_CD
, LOC.DESCRIPTION CHILD_LOCATION_DESCRIPTION
, USXGM_CHLD.CREATED_BY CREATED_BY
, USXGM_CHLD.CREATION_DATE CREATION_DATE
, USXGM_CHLD.LAST_UPDATED_BY LAST_UPDATED_BY
, USXGM_CHLD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USXGM_CHLD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_VER UV
, IGS_PS_USEC_X_GRPMEM USXGM
, IGS_PS_USEC_X_GRPMEM USXGM_CHLD
, IGS_CA_INST CI
, IGS_AS_UNIT_CLASS UC
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_AD_LOCATION LOC
WHERE UOO.UOO_ID = USXGM_CHLD.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND USXGM.USEC_X_LISTED_GROUP_ID = USXGM_CHLD.USEC_X_LISTED_GROUP_ID
AND USXGM.PARENT = 'Y'
AND USXGM_CHLD.PARENT = 'N'