eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGS_AD_ADM_UT_STA_GD_V

Source

View Text - Preformatted


SELECT ausg.ROWID ROW_ID, ausg.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS, ausg.GRADING_SCHEMA_CD GRADING_SCHEMA_CD, ausg.VERSION_NUMBER VERSION_NUMBER, ausg.GRADE GRADE , gs.START_DT START_DT, gs.END_DT END_DT, gsg.FULL_GRADE_NAME FULL_GRADE_NAME, gsg.S_RESULT_TYPE S_RESULT_TYPE, lkups.MEANING MEANING, ausg.CREATED_BY CREATED_BY, ausg.CREATION_DATE CREATION_DATE, ausg.LAST_UPDATED_BY LAST_UPDATED_BY , ausg.LAST_UPDATE_DATE LAST_UPDATE_DATE, ausg.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_ADM_UT_STA_GD AUSG, IGS_LOOKUPS_VIEW LKUPS, IGS_AS_GRD_SCH_GRADE GSG, IGS_AS_GRD_SCHEMA GS WHERE LKUPS.LOOKUP_TYPE = 'RESULT_TYPE' AND LKUPS.LOOKUP_CODE = gsg.S_RESULT_TYPE AND GSG.GRADING_SCHEMA_CD = AUSG.GRADING_SCHEMA_CD AND (GSG.VERSION_NUMBER = AUSG.VERSION_NUMBER OR (GSG.VERSION_NUMBER IS NULL AND AUSG.VERSION_NUMBER IS NULL )) AND (GSG.GRADE = AUSG.GRADE OR (GSG.GRADE IS NULL AND AUSG.GRADE IS NULL )) AND GS.GRADING_SCHEMA_CD = GSG.GRADING_SCHEMA_CD AND GS.VERSION_NUMBER = GSG.VERSION_NUMBER

View Text - HTML Formatted

SELECT AUSG.ROWID ROW_ID
, AUSG.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, AUSG.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, AUSG.VERSION_NUMBER VERSION_NUMBER
, AUSG.GRADE GRADE
, GS.START_DT START_DT
, GS.END_DT END_DT
, GSG.FULL_GRADE_NAME FULL_GRADE_NAME
, GSG.S_RESULT_TYPE S_RESULT_TYPE
, LKUPS.MEANING MEANING
, AUSG.CREATED_BY CREATED_BY
, AUSG.CREATION_DATE CREATION_DATE
, AUSG.LAST_UPDATED_BY LAST_UPDATED_BY
, AUSG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AUSG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_ADM_UT_STA_GD AUSG
, IGS_LOOKUPS_VIEW LKUPS
, IGS_AS_GRD_SCH_GRADE GSG
, IGS_AS_GRD_SCHEMA GS
WHERE LKUPS.LOOKUP_TYPE = 'RESULT_TYPE'
AND LKUPS.LOOKUP_CODE = GSG.S_RESULT_TYPE
AND GSG.GRADING_SCHEMA_CD = AUSG.GRADING_SCHEMA_CD
AND (GSG.VERSION_NUMBER = AUSG.VERSION_NUMBER OR (GSG.VERSION_NUMBER IS NULL
AND AUSG.VERSION_NUMBER IS NULL ))
AND (GSG.GRADE = AUSG.GRADE OR (GSG.GRADE IS NULL
AND AUSG.GRADE IS NULL ))
AND GS.GRADING_SCHEMA_CD = GSG.GRADING_SCHEMA_CD
AND GS.VERSION_NUMBER = GSG.VERSION_NUMBER