Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT UOP.UNIT_CD
, UOP.VERSION_NUMBER
, UOP.CAL_TYPE
, UOP.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(UOP.CAL_TYPE
, UOP.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(UOP.CAL_TYPE
, UOP.CI_SEQUENCE_NUMBER)
, 1
, 10)
, UOP.CI_START_DT
, UOP.CI_END_DT
, UOP.CREATED_BY
, UOP.CREATION_DATE
, UOP.LAST_UPDATED_BY
, UOP.LAST_UPDATE_DATE
, UOP.LAST_UPDATE_LOGIN
, UOP.ABORT_FLAG ABORT_FLAG
FROM IGS_PS_UNIT_OFR_PAT UOP
, IGS_CA_INST CI
WHERE UOP.CAL_TYPE = CI.CAL_TYPE
AND UOP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND UOP.DELETE_FLAG = 'N'