View: IGS_CA_DA_INST_ALIAS_VAL_V

Product:	IGS - Student System
Description:	This view is used to provide derived, absolute and effective dates for the date alias instance.
Implementation/DBA Data:	APPS.IGS_CA_DA_INST_ALIAS_VAL_V

View Text

SELECT DT_ALIAS
, SEQUENCE_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ABSOLUTE_VAL
, IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI(CI_SEQUENCE_NUMBER
, CAL_TYPE
, DT_ALIAS
, SEQUENCE_NUMBER) DERIVED_VAL
, IGS_CA_GEN_001.CALP_SET_ALIAS_VALUE(ABSOLUTE_VAL
, IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI(CI_SEQUENCE_NUMBER
, CAL_TYPE
, DT_ALIAS
, SEQUENCE_NUMBER)) ALIAS_VAL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_CA_DA_INST

Columns