VIEW: APPS.IGSFV_ACAD_TRANSCRIPT_TERMS

Source

View Text - Preformatted

SELECT TD.TERM, TD.START_DATE EFFECTIVE_START_DATE, TD.END_DATE EFFECTIVE_END_DATE, TD.TOTAL_CP_ATTEMPTED TOTAL_CREDIT_POINT_ATTEMPTED, TD.TOTAL_CP_EARNED TOTAL_CREDIT_POINT_EARNED, TD.TOTAL_UNIT_GP TOTAL_UNIT_GRADE_POINT, TD.TOTAL_GPA_UNITS, TD.GPA GRADE_POINT_AVERAGE, '_LA:TR.TRANSCRIPT_TYPE:IGS_LOOKUP_VALUES:TRANSCRIPT_TYPE:MEANING', '_LA:TR.TRANSCRIPT_STATUS:IGS_LOOKUP_VALUES:TRANSCRIPT_STATUS:MEANING', TR.DATE_OF_ISSUE, TR.DATE_OF_RECEIPT, TD.TERM_DETAILS_ID, TD.TRANSCRIPT_ID, TD.CREATED_BY, TD.CREATION_DATE, TD.LAST_UPDATED_BY, TD.LAST_UPDATE_DATE FROM IGS_AD_TERM_DETAILS TD, IGS_AD_TRANSCRIPT TR WHERE TD.TRANSCRIPT_ID = TR.TRANSCRIPT_ID WITH READ ONLY

View Text - HTML Formatted

SELECT TD.TERM
, TD.START_DATE EFFECTIVE_START_DATE
, TD.END_DATE EFFECTIVE_END_DATE
, TD.TOTAL_CP_ATTEMPTED TOTAL_CREDIT_POINT_ATTEMPTED
, TD.TOTAL_CP_EARNED TOTAL_CREDIT_POINT_EARNED
, TD.TOTAL_UNIT_GP TOTAL_UNIT_GRADE_POINT
, TD.TOTAL_GPA_UNITS
, TD.GPA GRADE_POINT_AVERAGE
, '_LA:TR.TRANSCRIPT_TYPE:IGS_LOOKUP_VALUES:TRANSCRIPT_TYPE:MEANING'
, '_LA:TR.TRANSCRIPT_STATUS:IGS_LOOKUP_VALUES:TRANSCRIPT_STATUS:MEANING'
, TR.DATE_OF_ISSUE
, TR.DATE_OF_RECEIPT
, TD.TERM_DETAILS_ID
, TD.TRANSCRIPT_ID
, TD.CREATED_BY
, TD.CREATION_DATE
, TD.LAST_UPDATED_BY
, TD.LAST_UPDATE_DATE
FROM IGS_AD_TERM_DETAILS TD
, IGS_AD_TRANSCRIPT TR
WHERE TD.TRANSCRIPT_ID = TR.TRANSCRIPT_ID WITH READ ONLY