VIEW: APPS.IGS_AS_UNITASS_ITEM_V

Source

View Text - Preformatted

SELECT uai.rowid row_id, uai.org_id org_id, uai.unit_cd unit_cd, uai.version_number version_number, uai.cal_type cal_type, uai.ci_sequence_number ci_sequence_number, uai.ass_id ass_id, ai.assessment_type dsp_assessment_type, NVL (uai. description, ai.description) ass_id_desc, uai.sequence_number sequence_number, uai.ci_start_dt ci_start_dt, uai.ci_end_dt ci_end_dt, NULL unit_class, NULL dsp_unit_mode, NULL unit_mode, NULL location_cd, uai.due_dt due_dt, uai.reference reference, uai.dflt_item_ind dflt_item_ind, uai.logical_delete_dt logical_delete_dt, uai.action_dt action_dt, uai.exam_cal_type exam_cal_type, uai.exam_ci_sequence_number exam_ci_sequence_number, ci.description, uai.grading_schema_cd grading_schema_cd, uai.gs_version_number gs_version_number, grd.description dsp_grd_schema_desc, uai.release_date release_date, uai.created_by created_by, uai.creation_date creation_date, uai.last_updated_by last_updated_by, uai.last_update_date last_update_date, uai.last_update_login last_update_login, uai.request_id request_id, uai.program_application_id program_application_id, uai.program_id program_id, uai.program_update_date program_update_date , uai.unit_ass_item_id, uai.unit_ass_item_group_id, uai.midterm_mandatory_type_code, uai.midterm_weight_qty, uai.final_mandatory_type_code, uai.final_weight_qty FROM igs_as_unitass_item_all uai, igs_as_assessmnt_itm_all ai, igs_as_grd_schema grd, igs_ca_inst ci WHERE uai.ass_id = ai.ass_id AND uai.grading_schema_cd = grd.grading_schema_cd AND uai.gs_version_number = grd.version_number AND uai.exam_cal_type = ci.cal_type(+) AND uai.exam_ci_sequence_number = ci.sequence_number(+)

View Text - HTML Formatted

SELECT UAI.ROWID ROW_ID
, UAI.ORG_ID ORG_ID
, UAI.UNIT_CD UNIT_CD
, UAI.VERSION_NUMBER VERSION_NUMBER
, UAI.CAL_TYPE CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, UAI.ASS_ID ASS_ID
, AI.ASSESSMENT_TYPE DSP_ASSESSMENT_TYPE
, NVL (UAI. DESCRIPTION
, AI.DESCRIPTION) ASS_ID_DESC
, UAI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, UAI.CI_START_DT CI_START_DT
, UAI.CI_END_DT CI_END_DT
, NULL UNIT_CLASS
, NULL DSP_UNIT_MODE
, NULL UNIT_MODE
, NULL LOCATION_CD
, UAI.DUE_DT DUE_DT
, UAI.REFERENCE REFERENCE
, UAI.DFLT_ITEM_IND DFLT_ITEM_IND
, UAI.LOGICAL_DELETE_DT LOGICAL_DELETE_DT
, UAI.ACTION_DT ACTION_DT
, UAI.EXAM_CAL_TYPE EXAM_CAL_TYPE
, UAI.EXAM_CI_SEQUENCE_NUMBER EXAM_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UAI.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, UAI.GS_VERSION_NUMBER GS_VERSION_NUMBER
, GRD.DESCRIPTION DSP_GRD_SCHEMA_DESC
, UAI.RELEASE_DATE RELEASE_DATE
, UAI.CREATED_BY CREATED_BY
, UAI.CREATION_DATE CREATION_DATE
, UAI.LAST_UPDATED_BY LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UAI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, UAI.REQUEST_ID REQUEST_ID
, UAI.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, UAI.PROGRAM_ID PROGRAM_ID
, UAI.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UAI.UNIT_ASS_ITEM_ID
, UAI.UNIT_ASS_ITEM_GROUP_ID
, UAI.MIDTERM_MANDATORY_TYPE_CODE
, UAI.MIDTERM_WEIGHT_QTY
, UAI.FINAL_MANDATORY_TYPE_CODE
, UAI.FINAL_WEIGHT_QTY
FROM IGS_AS_UNITASS_ITEM_ALL UAI
, IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_AS_GRD_SCHEMA GRD
, IGS_CA_INST CI
WHERE UAI.ASS_ID = AI.ASS_ID
AND UAI.GRADING_SCHEMA_CD = GRD.GRADING_SCHEMA_CD
AND UAI.GS_VERSION_NUMBER = GRD.VERSION_NUMBER
AND UAI.EXAM_CAL_TYPE = CI.CAL_TYPE(+)
AND UAI.EXAM_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)