VIEW: APPS.IGSBV_USEC_GRADING_SCHEMAS

Source

View Text - Preformatted

SELECT US.UNIT_SECTION_GRADING_SCHEMA_ID , US.UOO_ID UNIT_SECTION_ID, US.GRADING_SCHEMA_CODE, US.GRD_SCHM_VERSION_NUMBER, US.DEFAULT_FLAG DEFAULT_GRAD_SCHEMA_INDICATOR, GR.DESCRIPTION GRADING_SCHEMA_DESCRIPTION, UN.UNIT_CD, UN.VERSION_NUMBER, UN.CAL_TYPE, UN.CI_SEQUENCE_NUMBER, UN.LOCATION_CD, UN.UNIT_CLASS, US.CREATED_BY, US.CREATION_DATE, US.LAST_UPDATED_BY, US.LAST_UPDATE_DATE FROM IGS_PS_USEC_GRD_SCHM US , IGS_AS_GRD_SCHEMA GR, IGS_PS_UNIT_OFR_OPT_ALL UN WHERE US.GRADING_SCHEMA_CODE = GR.GRADING_SCHEMA_CD AND US.GRD_SCHM_VERSION_NUMBER = GR.VERSION_NUMBER AND US.UOO_ID = UN.UOO_ID WITH READ ONLY

View Text - HTML Formatted

SELECT US.UNIT_SECTION_GRADING_SCHEMA_ID
, US.UOO_ID UNIT_SECTION_ID
, US.GRADING_SCHEMA_CODE
, US.GRD_SCHM_VERSION_NUMBER
, US.DEFAULT_FLAG DEFAULT_GRAD_SCHEMA_INDICATOR
, GR.DESCRIPTION GRADING_SCHEMA_DESCRIPTION
, UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UN.CI_SEQUENCE_NUMBER
, UN.LOCATION_CD
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_GRD_SCHM US
, IGS_AS_GRD_SCHEMA GR
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE US.GRADING_SCHEMA_CODE = GR.GRADING_SCHEMA_CD
AND US.GRD_SCHM_VERSION_NUMBER = GR.VERSION_NUMBER
AND US.UOO_ID = UN.UOO_ID WITH READ ONLY