[Home] [Help]
View: IGF_AP_APPL_SETUP_V
View Text
SELECT DISTINCT IAS.ORG_ID
, IAS.CI_CAL_TYPE
, IAS.CI_SEQUENCE_NUMBER
, CAL.START_DT
, CAL.END_DT
, CAL.ALTERNATE_CODE
, IAS.APPLICATION_CODE
, IAS.APPLICATION_NAME
, IAS.ACTIVE_FLAG FROM IGS_CA_INST CAL
, IGF_AP_APPL_SETUP IAS
WHERE IAS.CI_CAL_TYPE = CAL.CAL_TYPE AND IAS.CI_SEQUENCE_NUMBER = CAL.SEQUENCE_NUMBER
Columns
Name |
ORG_ID |
CI_CAL_TYPE |
CI_SEQUENCE_NUMBER |
START_DT |
END_DT |
AWARD_YEAR |
APPLICATION_CODE |
APPLICATION_NAME |
ACTIVE_FLAG |