Product: | IGS - Student System |
---|---|
Description: | This view describes the load calendar type relationship to administrative unit status to determine load incurred. |
Implementation/DBA Data: | APPS.IGS_AD_ADM_UT_STT_LD_V |
SELECT AUSL.ROWID ROW_ID
, LKUPS.MEANING MEANING
, AUS.DESCRIPTION DESCRIPTION
, AUS.UNIT_ATTEMPT_STATUS UNIT_ATTEMPT_STATUS
, AUS.CLOSED_IND CLOSED_IND
, AUSL.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, AUSL.CAL_TYPE CAL_TYPE
, AUSL.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, AUSL.TEACH_CAL_TYPE TEACH_CAL_TYPE
, AUSL.LOAD_INCURRED_IND LOAD_INCURRED_IND
, AUSL.CREATED_BY CREATED_BY
, AUSL.CREATION_DATE CREATION_DATE
, AUSL.LAST_UPDATED_BY LAST_UPDATED_BY
, AUSL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AUSL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_LOOKUPS_VIEW LKUPS
, IGS_AD_ADM_UT_STT_LD AUSL
, IGS_AD_ADM_UNIT_STAT AUS
WHERE AUS.ADMINISTRATIVE_UNIT_STATUS = AUSL.ADMINISTRATIVE_UNIT_STATUS
AND ((AUS.UNIT_ATTEMPT_STATUS = 'DISCONTIN'
AND AUS.CLOSED_IND = 'N') OR AUS.ADMINISTRATIVE_UNIT_STATUS = AUSL.ADMINISTRATIVE_UNIT_STATUS) AND LKUPS.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'
AND LKUPS.LOOKUP_CODE = AUS.UNIT_ATTEMPT_STATUS