VIEW: APPS.IGS_AD_ADM_UNIT_STAT_V

Source

View Text - Preformatted

SELECT aus.row_id ROW_ID, aus.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS, aus.UNIT_ATTEMPT_STATUS UNIT_ATTEMPT_STATUS, aus.DESCRIPTION DESCRIPTION, aus.SHOW_ON_OFFIC_NTFCTN_IND SHOW_ON_OFFIC_NTFCTN_IND, aus.EFFECTIVE_PROGRESSION_IND EFFECTIVE_PROGRESSION_IND, aus.EFFECTIVE_TIME_ELAPSED_IND EFFECTIVE_TIME_ELAPSED_IND, aus.CLOSED_IND CLOSED_IND, lkups.meaning MEANING, lkups.fee_ass_ind FEE_ASS_IND, aus.CREATED_BY CREATED_BY, aus.CREATION_DATE CREATION_DATE, aus.LAST_UPDATED_BY LAST_UPDATED_BY, aus.LAST_UPDATE_DATE LAST_UPDATE_DATE, aus.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN From IGS_AD_ADM_UNIT_STAT aus, IGS_LOOKUPS_VIEW lkups WHERE lkups.LOOKUP_CODE = AUS.UNIT_ATTEMPT_STATUS AND lkups.lookup_type = 'UNIT_ATTEMPT_STATUS'

View Text - HTML Formatted

SELECT AUS.ROW_ID ROW_ID
, AUS.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, AUS.UNIT_ATTEMPT_STATUS UNIT_ATTEMPT_STATUS
, AUS.DESCRIPTION DESCRIPTION
, AUS.SHOW_ON_OFFIC_NTFCTN_IND SHOW_ON_OFFIC_NTFCTN_IND
, AUS.EFFECTIVE_PROGRESSION_IND EFFECTIVE_PROGRESSION_IND
, AUS.EFFECTIVE_TIME_ELAPSED_IND EFFECTIVE_TIME_ELAPSED_IND
, AUS.CLOSED_IND CLOSED_IND
, LKUPS.MEANING MEANING
, LKUPS.FEE_ASS_IND FEE_ASS_IND
, AUS.CREATED_BY CREATED_BY
, AUS.CREATION_DATE CREATION_DATE
, AUS.LAST_UPDATED_BY LAST_UPDATED_BY
, AUS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AUS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_ADM_UNIT_STAT AUS
, IGS_LOOKUPS_VIEW LKUPS
WHERE LKUPS.LOOKUP_CODE = AUS.UNIT_ATTEMPT_STATUS
AND LKUPS.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'