VIEW: APPS.IGSFV_AS_GRD_SCH_TRANSLATIONS

Source

View Text - Preformatted

SELECT GSGT.GRADING_SCHEMA_CD, GSGT.VERSION_NUMBER, GS1.DESCRIPTION, GSGT.GRADE, GSG1.FULL_GRADE_NAME, GSGT.TO_GRADING_SCHEMA_CD, GSGT.TO_VERSION_NUMBER, GS2.DESCRIPTION, GSGT.TO_GRADE, GSG2.FULL_GRADE_NAME, GSGT.CREATED_BY, GSGT.CREATION_DATE, GSGT.LAST_UPDATED_BY, GSGT.LAST_UPDATE_DATE FROM IGS_AS_GRD_SCH_TRN_ALL GSGT, IGS_AS_GRD_SCHEMA GS1, IGS_AS_GRD_SCH_GRADE GSG1, IGS_AS_GRD_SCHEMA GS2, IGS_AS_GRD_SCH_GRADE GSG2 WHERE GSGT.GRADING_SCHEMA_CD = GSG1.GRADING_SCHEMA_CD AND GSGT.VERSION_NUMBER = GSG1.VERSION_NUMBER AND GSGT.GRADE = GSG1.GRADE AND GSG1.GRADING_SCHEMA_CD = GS1.GRADING_SCHEMA_CD AND GSG1.VERSION_NUMBER = GS1.VERSION_NUMBER AND GSGT.TO_GRADING_SCHEMA_CD = GSG2.GRADING_SCHEMA_CD AND GSGT.TO_VERSION_NUMBER = GSG2.VERSION_NUMBER AND GSGT.TO_GRADE = GSG2.GRADE AND GSG2.GRADING_SCHEMA_CD = GS2.GRADING_SCHEMA_CD AND GSG2.VERSION_NUMBER = GS2.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT GSGT.GRADING_SCHEMA_CD
, GSGT.VERSION_NUMBER
, GS1.DESCRIPTION
, GSGT.GRADE
, GSG1.FULL_GRADE_NAME
, GSGT.TO_GRADING_SCHEMA_CD
, GSGT.TO_VERSION_NUMBER
, GS2.DESCRIPTION
, GSGT.TO_GRADE
, GSG2.FULL_GRADE_NAME
, GSGT.CREATED_BY
, GSGT.CREATION_DATE
, GSGT.LAST_UPDATED_BY
, GSGT.LAST_UPDATE_DATE
FROM IGS_AS_GRD_SCH_TRN_ALL GSGT
, IGS_AS_GRD_SCHEMA GS1
, IGS_AS_GRD_SCH_GRADE GSG1
, IGS_AS_GRD_SCHEMA GS2
, IGS_AS_GRD_SCH_GRADE GSG2
WHERE GSGT.GRADING_SCHEMA_CD = GSG1.GRADING_SCHEMA_CD
AND GSGT.VERSION_NUMBER = GSG1.VERSION_NUMBER
AND GSGT.GRADE = GSG1.GRADE
AND GSG1.GRADING_SCHEMA_CD = GS1.GRADING_SCHEMA_CD
AND GSG1.VERSION_NUMBER = GS1.VERSION_NUMBER
AND GSGT.TO_GRADING_SCHEMA_CD = GSG2.GRADING_SCHEMA_CD
AND GSGT.TO_VERSION_NUMBER = GSG2.VERSION_NUMBER
AND GSGT.TO_GRADE = GSG2.GRADE
AND GSG2.GRADING_SCHEMA_CD = GS2.GRADING_SCHEMA_CD
AND GSG2.VERSION_NUMBER = GS2.VERSION_NUMBER WITH READ ONLY