Used to provide derived, absolute and effective dates for the date alias instance. It is used in conjunction with the inquire on date alias instance form to provide a meaningful description when displaying date alias instance values.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DAI.DT_ALIAS , DAI.SEQUENCE_NUMBER , DAI.CAL_TYPE , DAI.CI_SEQUENCE_NUMBER , DAI.ABSOLUTE_VAL , IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI(DAI.CI_SEQUENCE_NUMBER , DAI.CAL_TYPE , DAI.DT_ALIAS , DAI.SEQUENCE_NUMBER) DERIVED_VAL , IGS_CA_GEN_001.CALP_SET_ALIAS_VALUE(DAI.ABSOLUTE_VAL , IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI(DAI.CI_SEQUENCE_NUMBER , DAI.CAL_TYPE , DAI.DT_ALIAS , DAI.SEQUENCE_NUMBER) ) ALIAS_VAL , DA.DESCRIPTION || '/' || CAT.DESCRIPTION DAI_DESCRIPTION , DAI.CREATED_BY , DAI.CREATION_DATE , DAI.LAST_UPDATED_BY , DAI.LAST_UPDATE_DATE , DAI.LAST_UPDATE_LOGIN FROM IGS_CA_DA_INST DAI , IGS_CA_INST CI , IGS_CA_TYPE CAT , IGS_CA_DA DA WHERE DA.DT_ALIAS = DAI.DT_ALIAS AND CI.SEQUENCE_NUMBER = DAI.CI_SEQUENCE_NUMBER AND CI.CAL_TYPE = DAI.CAL_TYPE AND CAT.CAL_TYPE = CI.CAL_TYPE