VIEW: APPS.IGS_AS_INC_GRD_CPROF_V

Source

View Text - Preformatted

SELECT IGCP.ROWID ROW_ID, IGCP.INC_GRD_CPROF_ID INC_GRD_CPROF_ID, IGCP.GRADING_SCHEMA_CD GRADING_SCHEMA_CD, IGCP.VERSION_NUMBER VERSION_NUMBER, IGCP.INCOMPLETE_GRADE INCOMPLETE_GRADE, IGCP.ORG_UNIT_CD ORG_UNIT_CD, ORGU.DESCRIPTION ORG_UNIT_NAME, IGCP.NUMBER_UNIT_TIME NUMBER_UNIT_TIME, IGCP.TYPE_UNIT_TIME TYPE_UNIT_TIME, IGCP.COMP_AFTER_DT_ALIAS COMP_AFTER_DT_ALIAS, IGCP.DEFAULT_GRADE DEFAULT_GRADE, IGCP.DEFAULT_MARK DEFAULT_MARK, IGCP.INSTRUCTOR_UPDATE_IND INSTRUCTOR_UPDATE_IND, IGCP.CREATED_BY CREATED_BY, IGCP.CREATION_DATE CREATION_DATE, IGCP.LAST_UPDATED_BY LAST_UPDATED_BY, IGCP.LAST_UPDATE_DATE LAST_UPDATE_DATE, IGCP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AS_INC_GRD_CPROF IGCP, IGS_OR_UNIT ORGU WHERE IGCP.ORG_UNIT_CD = ORGU.ORG_UNIT_CD (+)

View Text - HTML Formatted

SELECT IGCP.ROWID ROW_ID
, IGCP.INC_GRD_CPROF_ID INC_GRD_CPROF_ID
, IGCP.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, IGCP.VERSION_NUMBER VERSION_NUMBER
, IGCP.INCOMPLETE_GRADE INCOMPLETE_GRADE
, IGCP.ORG_UNIT_CD ORG_UNIT_CD
, ORGU.DESCRIPTION ORG_UNIT_NAME
, IGCP.NUMBER_UNIT_TIME NUMBER_UNIT_TIME
, IGCP.TYPE_UNIT_TIME TYPE_UNIT_TIME
, IGCP.COMP_AFTER_DT_ALIAS COMP_AFTER_DT_ALIAS
, IGCP.DEFAULT_GRADE DEFAULT_GRADE
, IGCP.DEFAULT_MARK DEFAULT_MARK
, IGCP.INSTRUCTOR_UPDATE_IND INSTRUCTOR_UPDATE_IND
, IGCP.CREATED_BY CREATED_BY
, IGCP.CREATION_DATE CREATION_DATE
, IGCP.LAST_UPDATED_BY LAST_UPDATED_BY
, IGCP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IGCP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_INC_GRD_CPROF IGCP
, IGS_OR_UNIT ORGU
WHERE IGCP.ORG_UNIT_CD = ORGU.ORG_UNIT_CD (+)