VIEW: APPS.IGS_CA_DA_INST_DISPLAY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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