VIEW: APPS.IGS_AV_STND_ALT_UNIT_V

Source

View Text - Preformatted

SELECT asau.rowid row_id, asau.last_update_login last_update_login, asau.created_by created_by, asau.creation_date creation_date, asau.last_updated_by last_updated_by, asau.last_update_date last_update_date, asu.person_id person_id, asu.as_course_cd as_course_cd, asu.as_version_number as_version_number, asu.s_adv_stnd_type s_adv_stnd_type, asu.unit_cd unit_cd, asu.version_number version_number , asau.alt_unit_cd alt_unit_cd, asau.alt_version_number alt_version_number, asau.optional_ind optional_ind, asau.av_stnd_unit_id av_stnd_unit_id FROM IGS_AV_STND_ALT_UNIT asau, IGS_AV_STND_UNIT asu WHERE asu.av_stnd_unit_id=asau.av_stnd_unit_id

View Text - HTML Formatted

SELECT ASAU.ROWID ROW_ID
, ASAU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASAU.CREATED_BY CREATED_BY
, ASAU.CREATION_DATE CREATION_DATE
, ASAU.LAST_UPDATED_BY LAST_UPDATED_BY
, ASAU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASU.PERSON_ID PERSON_ID
, ASU.AS_COURSE_CD AS_COURSE_CD
, ASU.AS_VERSION_NUMBER AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE S_ADV_STND_TYPE
, ASU.UNIT_CD UNIT_CD
, ASU.VERSION_NUMBER VERSION_NUMBER
, ASAU.ALT_UNIT_CD ALT_UNIT_CD
, ASAU.ALT_VERSION_NUMBER ALT_VERSION_NUMBER
, ASAU.OPTIONAL_IND OPTIONAL_IND
, ASAU.AV_STND_UNIT_ID AV_STND_UNIT_ID
FROM IGS_AV_STND_ALT_UNIT ASAU
, IGS_AV_STND_UNIT ASU
WHERE ASU.AV_STND_UNIT_ID=ASAU.AV_STND_UNIT_ID