DBA Data[Home] [Help]

VIEW: APPS.IGS_CA_DA_INST_ALIAS_VAL_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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