VIEW: APPS.IGSBV_UNIT_CAL_TYPE_OFFERINGS

Source

View Text - Preformatted

SELECT un.UNIT_CD, un.VERSION_NUMBER, un.CAL_TYPE, ui.TITLE, ty.DESCRIPTION, un.CREATED_BY, un.CREATION_DATE, un.LAST_UPDATED_BY, un.LAST_UPDATE_DATE FROM IGS_PS_UNIT_OFR un, IGS_CA_TYPE ty, IGS_PS_UNIT_VER_ALL ui WHERE un.CAL_TYPE =ty.CAL_TYPE AND un.UNIT_CD = ui.UNIT_CD AND un.VERSION_NUMBER = ui.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UI.TITLE
, TY.DESCRIPTION
, UN.CREATED_BY
, UN.CREATION_DATE
, UN.LAST_UPDATED_BY
, UN.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_OFR UN
, IGS_CA_TYPE TY
, IGS_PS_UNIT_VER_ALL UI
WHERE UN.CAL_TYPE =TY.CAL_TYPE
AND UN.UNIT_CD = UI.UNIT_CD
AND UN.VERSION_NUMBER = UI.VERSION_NUMBER WITH READ ONLY