DBA Data[Home] [Help]

VIEW: APPS.IGS_AD_TERM_UNITDTLS_V

Source

View Text - Preformatted

SELECT TU.ROWID ROW_ID, TU.UNIT_DETAILS_ID, TU.TERM_DETAILS_ID, TU.UNIT, TU.UNIT_DIFFICULTY, CC1.NAME UNIT_DIFFICULTY_DESC, TU.UNIT_NAME, TU.CP_ATTEMPTED, TU.CP_EARNED, TU.GRADE, TU.UNIT_GRADE_POINTS, TU.CREATED_BY, TU.CREATION_DATE, TU.LAST_UPDATED_BY, TU.LAST_UPDATE_DATE, TU.LAST_UPDATE_LOGIN ,TU. DEG_AUD_DETAIL_ID FROM IGS_AD_TERM_UNITDTLS TU, IGS_AD_CODE_CLASSES CC1 WHERE CC1.CODE_ID = TU.UNIT_DIFFICULTY (+)
View Text - HTML Formatted

SELECT TU.ROWID ROW_ID
, TU.UNIT_DETAILS_ID
, TU.TERM_DETAILS_ID
, TU.UNIT
, TU.UNIT_DIFFICULTY
, CC1.NAME UNIT_DIFFICULTY_DESC
, TU.UNIT_NAME
, TU.CP_ATTEMPTED
, TU.CP_EARNED
, TU.GRADE
, TU.UNIT_GRADE_POINTS
, TU.CREATED_BY
, TU.CREATION_DATE
, TU.LAST_UPDATED_BY
, TU.LAST_UPDATE_DATE
, TU.LAST_UPDATE_LOGIN
, TU. DEG_AUD_DETAIL_ID
FROM IGS_AD_TERM_UNITDTLS TU
, IGS_AD_CODE_CLASSES CC1
WHERE CC1.CODE_ID = TU.UNIT_DIFFICULTY (+)