[Home] [Help]
View: IGF_AW_LOAD_CAL_V
View Text
SELECT CI.ROW_ID
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.CAL_STATUS
, CI.ALTERNATE_CODE
, CI.SUP_CAL_STATUS_DIFFER_IND
, CI.PRIOR_CI_SEQUENCE_NUMBER
, CI.CREATED_BY
, CI.CREATION_DATE
, CI.LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN
FROM IGS_CA_INST CI
, IGS_CA_TYPE_V CTY
WHERE CI.CAL_TYPE = CTY.CAL_TYPE
AND CTY.S_CAL_CAT = 'LOAD'
Columns
Name |
ROW_ID |
LD_CAL_TYPE |
LD_SEQ_NUMBER |
LD_START_DT |
LD_END_DT |
LD_CAL_STATUS |
LD_ALTERNATE_CODE |
SUP_CAL_STAT_DIFF_IND |
PRIOR_CI_SEQ_NUM |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |