VIEW: APPS.IGS_EN_ELGB_OVR_UOO_V

Source

View Text - Preformatted

SELECT EOU.ROWID ROW_ID, EOU.ELGB_OVR_STEP_ID ELGB_OVR_STEP_ID, EOU.ELGB_OVR_STEP_UOO_ID ELGB_OVR_STEP_UOO_ID, EOU.UNIT_CD UNIT_CD, EOU.VERSION_NUMBER VERSION_NUMBER, UV1.TITLE TITLE, EOU.UOO_ID UOO_ID, UOO.CAL_TYPE US_CAL_TYPE, UOO.CI_SEQUENCE_NUMBER US_CI_SEQUENCE_NUMBER, CA.START_DT US_CI_START_DT, CA.END_DT US_CI_END_DT, CA.ALTERNATE_CODE US_ALTERNATE_CODE, UOO.LOCATION_CD US_LOCATION_CD, UOO.UNIT_CLASS US_UNIT_CLASS, EOU.STEP_OVERRIDE_LIMIT STEP_OVERRIDE_LIMIT, EOU.CREATED_BY CREATED_BY, EOU.CREATION_DATE CREATION_DATE, EOU.LAST_UPDATED_BY LAST_UPDATED_BY, EOU.LAST_UPDATE_DATE LAST_UPDATE_DATE, EOU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_EN_ELGB_OVR_UOO EOU, IGS_PS_UNIT_OFR_OPT UOO, IGS_PS_UNIT_VER UV1, IGS_CA_INST CA WHERE EOU.UNIT_CD = UV1.UNIT_CD AND EOU.VERSION_NUMBER = UV1.VERSION_NUMBER AND EOU.UOO_ID = UOO.UOO_ID (+) AND UOO.CAL_TYPE = CA.CAL_TYPE (+) AND UOO.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+)

View Text - HTML Formatted

SELECT EOU.ROWID ROW_ID
, EOU.ELGB_OVR_STEP_ID ELGB_OVR_STEP_ID
, EOU.ELGB_OVR_STEP_UOO_ID ELGB_OVR_STEP_UOO_ID
, EOU.UNIT_CD UNIT_CD
, EOU.VERSION_NUMBER VERSION_NUMBER
, UV1.TITLE TITLE
, EOU.UOO_ID UOO_ID
, UOO.CAL_TYPE US_CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER US_CI_SEQUENCE_NUMBER
, CA.START_DT US_CI_START_DT
, CA.END_DT US_CI_END_DT
, CA.ALTERNATE_CODE US_ALTERNATE_CODE
, UOO.LOCATION_CD US_LOCATION_CD
, UOO.UNIT_CLASS US_UNIT_CLASS
, EOU.STEP_OVERRIDE_LIMIT STEP_OVERRIDE_LIMIT
, EOU.CREATED_BY CREATED_BY
, EOU.CREATION_DATE CREATION_DATE
, EOU.LAST_UPDATED_BY LAST_UPDATED_BY
, EOU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EOU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_ELGB_OVR_UOO EOU
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_UNIT_VER UV1
, IGS_CA_INST CA
WHERE EOU.UNIT_CD = UV1.UNIT_CD
AND EOU.VERSION_NUMBER = UV1.VERSION_NUMBER
AND EOU.UOO_ID = UOO.UOO_ID (+)
AND UOO.CAL_TYPE = CA.CAL_TYPE (+)
AND UOO.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+)