[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Advance Standing Calandar Configuration |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CF.ROWID ROW_ID
, CF.S_CONTROL_NUM
, CF.ASS_ITEM_CUTOFF_DT_ALIAS
, ASS.DESCRIPTION ASS_ITEM_CUTOFF_DT_DESC
, CF.MID_MGS_START_DT_ALIAS
, MID_S.DESCRIPTION MID_MGS_START_DT_DESC
, CF.MID_MGS_END_DT_ALIAS
, MID_E.DESCRIPTION MID_MGS_END_DT_DESC
, CF.EFINAL_MGS_START_DT_ALIAS
, EFINAL_S.DESCRIPTION EFINAL_MGS_START_DT_DESC
, CF.EFINAL_MGS_END_DT_ALIAS
, EFINAL_E.DESCRIPTION EFINAL_MGS_END_DT_DESC
, CF.FINAL_MGS_START_DT_ALIAS
, FINAL_S.DESCRIPTION FINAL_MGS_START_DT_DESC
, CF.FINAL_MGS_END_DT_ALIAS
, FINAL_E.DESCRIPTION FINAL_MGS_END_DT_DESC
, CF.CREATED_BY
, CF.CREATION_DATE
, CF.LAST_UPDATED_BY
, CF.LAST_UPDATE_DATE
, CF.LAST_UPDATE_LOGIN
FROM IGS_AS_CAL_CONF CF
, IGS_CA_DA ASS
, IGS_CA_DA MID_S
, IGS_CA_DA MID_E
, IGS_CA_DA EFINAL_S
, IGS_CA_DA EFINAL_E
, IGS_CA_DA FINAL_S
, IGS_CA_DA FINAL_E
WHERE ASS.DT_ALIAS(+)=CF.ASS_ITEM_CUTOFF_DT_ALIAS
AND MID_S.DT_ALIAS(+)=CF.MID_MGS_START_DT_ALIAS
AND MID_E.DT_ALIAS(+)=CF.MID_MGS_END_DT_ALIAS
AND FINAL_S.DT_ALIAS(+)=CF.FINAL_MGS_START_DT_ALIAS
AND FINAL_E.DT_ALIAS(+)=CF.FINAL_MGS_END_DT_ALIAS
AND EFINAL_S.DT_ALIAS(+)=CF.EFINAL_MGS_START_DT_ALIAS
AND EFINAL_E.DT_ALIAS(+)=CF.EFINAL_MGS_END_DT_ALIAS