VIEW: APPS.IGS_AD_ADM_UT_STT_LD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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