DBA Data[Home] [Help]

VIEW: APPS.IGSBV_TRANSCRIPT_TERM_UNITS

Source

View Text - Preformatted

SELECT TU.TERM_DETAILS_ID, TU.UNIT, TU.UNIT_NAME, TU.CP_ATTEMPTED CREDIT_POINT_ATTEMPTED, TU.CP_EARNED CREDIT_POINT_EARNED, TU.GRADE, TU.UNIT_GRADE_POINTS, TD.TERM, TD.START_DATE EFFECTIVE_START_DATE, TD.END_DATE EFFECTIVE_END_DATE, TU.UNIT_DETAILS_ID, TU.UNIT_DIFFICULTY UNIT_DIFFICULTY_ID, TU.DEG_AUD_DETAIL_ID, TU.CREATED_BY, TU.CREATION_DATE, TU.LAST_UPDATED_BY, TU.LAST_UPDATE_DATE FROM IGS_AD_TERM_UNITDTLS TU, IGS_AD_TERM_DETAILS TD WHERE TU.TERM_DETAILS_ID = TD.TERM_DETAILS_ID WITH READ ONLY
View Text - HTML Formatted

SELECT TU.TERM_DETAILS_ID
, TU.UNIT
, TU.UNIT_NAME
, TU.CP_ATTEMPTED CREDIT_POINT_ATTEMPTED
, TU.CP_EARNED CREDIT_POINT_EARNED
, TU.GRADE
, TU.UNIT_GRADE_POINTS
, TD.TERM
, TD.START_DATE EFFECTIVE_START_DATE
, TD.END_DATE EFFECTIVE_END_DATE
, TU.UNIT_DETAILS_ID
, TU.UNIT_DIFFICULTY UNIT_DIFFICULTY_ID
, TU.DEG_AUD_DETAIL_ID
, TU.CREATED_BY
, TU.CREATION_DATE
, TU.LAST_UPDATED_BY
, TU.LAST_UPDATE_DATE
FROM IGS_AD_TERM_UNITDTLS TU
, IGS_AD_TERM_DETAILS TD
WHERE TU.TERM_DETAILS_ID = TD.TERM_DETAILS_ID WITH READ ONLY