[Home] [Help]
View: IGS_EN_UNIT_SET_MAP_V
Product: | IGS - Student System (Obsolete) |
Description: | Unit Set Mapping View |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT USM.MAPPING_SET_CD MAPPING_SET_CD
, USM.SEQUENCE_NO SEQUENCE_NO
, USM.STREAM_UNIT_SET_CD STREAM_UNIT_SET_CD
, USM.US_VERSION_NUMBER US_VERSION_NUMBER
, US.SHORT_TITLE SHORT_TITLE
, US.START_DT START_DT
, USM.CREATED_BY CREATED_BY
, USM.CREATION_DATE CREATION_DATE
, USM.LAST_UPDATED_BY LAST_UPDATED_BY
, USM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_UNIT_SET_MAP USM
, IGS_EN_UNIT_SET US
WHERE STREAM_UNIT_SET_CD = UNIT_SET_CD
AND US_VERSION_NUMBER = VERSION_NUMBER
Columns
Name |
MAPPING_SET_CD |
SEQUENCE_NO |
STREAM_UNIT_SET_CD |
US_VERSION_NUMBER |
SHORT_TITLE |
START_DT |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |