VIEW: APPS.IGSFV_AS_APPR_AST_ITM_GRD_SCHS

Source

View Text - Preformatted

SELECT AAGS.UNIT_CD, AAGS.VERSION_NUMBER, UV.TITLE, AAGS.ASSESSMENT_TYPE, ATYP.DESCRIPTION, AAGS.GRADING_SCHEMA_CD, AAGS.GS_VERSION_NUMBER, GS.DESCRIPTION, '_LA:AAGS.DEFAULT_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:AAGS.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', AAGS.CREATED_BY, AAGS.CREATION_DATE, AAGS.LAST_UPDATED_BY, AAGS.LAST_UPDATE_DATE FROM IGS_AS_APPR_GRD_SCH AAGS, IGS_PS_UNIT_VER_ALL UV, IGS_AS_ASSESSMNT_TYP ATYP, IGS_AS_GRD_SCHEMA GS WHERE AAGS.UNIT_CD = UV.UNIT_CD AND AAGS.VERSION_NUMBER = UV.VERSION_NUMBER AND AAGS.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE AND AAGS.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD AND AAGS.GS_VERSION_NUMBER = GS.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT AAGS.UNIT_CD
, AAGS.VERSION_NUMBER
, UV.TITLE
, AAGS.ASSESSMENT_TYPE
, ATYP.DESCRIPTION
, AAGS.GRADING_SCHEMA_CD
, AAGS.GS_VERSION_NUMBER
, GS.DESCRIPTION
, '_LA:AAGS.DEFAULT_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AAGS.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AAGS.CREATED_BY
, AAGS.CREATION_DATE
, AAGS.LAST_UPDATED_BY
, AAGS.LAST_UPDATE_DATE
FROM IGS_AS_APPR_GRD_SCH AAGS
, IGS_PS_UNIT_VER_ALL UV
, IGS_AS_ASSESSMNT_TYP ATYP
, IGS_AS_GRD_SCHEMA GS
WHERE AAGS.UNIT_CD = UV.UNIT_CD
AND AAGS.VERSION_NUMBER = UV.VERSION_NUMBER
AND AAGS.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE
AND AAGS.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD
AND AAGS.GS_VERSION_NUMBER = GS.VERSION_NUMBER WITH READ ONLY