VIEW: APPS.IGS_PS_UNITASS_ITEM_V

Source

View Text - Preformatted

SELECT uai.rowid row_id, uai.unit_section_ass_item_id unit_section_ass_item_id, uai.uoo_id uoo_id, uai.ass_id ass_id, uai.sequence_number sequence_number, uai.ci_start_dt ci_start_dt, uai.ci_end_dt ci_end_dt, NULL, /* uai.unit_class unit_class, */ NULL, /* uai.unit_mode unit_mode, */ NULL, /* uai.location_cd 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 ,uai.grading_schema_cd ,uai.gs_version_number ,grd.description grading_schema_desc ,uai.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, NVL(uai.description,ast.description) description, ci.description exam_cal_description, uai.us_ass_item_group_id us_ass_item_group_id, uai.midterm_mandatory_type_code midterm_mandatory_type_code, uai.midterm_weight_qty midterm_weight_qty, uai.final_mandatory_type_code final_mandatory_type_code, uai.final_weight_qty final_weight_qty FROM igs_ps_unitass_item uai ,igs_as_grd_schema grd ,igs_as_assessmnt_itm_all ast, igs_ca_inst ci WHERE uai.grading_schema_cd = grd.grading_schema_cd and uai.gs_version_number = grd.version_number and uai.ass_id = ast.ass_id 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.UNIT_SECTION_ASS_ITEM_ID UNIT_SECTION_ASS_ITEM_ID
, UAI.UOO_ID UOO_ID
, UAI.ASS_ID ASS_ID
, UAI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, UAI.CI_START_DT CI_START_DT
, UAI.CI_END_DT CI_END_DT
, NULL
, /* UAI.UNIT_CLASS UNIT_CLASS
, */ NULL
, /* UAI.UNIT_MODE UNIT_MODE
, */ NULL
, /* UAI.LOCATION_CD 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
, UAI.GRADING_SCHEMA_CD
, UAI.GS_VERSION_NUMBER
, GRD.DESCRIPTION GRADING_SCHEMA_DESC
, UAI.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
, NVL(UAI.DESCRIPTION
, AST.DESCRIPTION) DESCRIPTION
, CI.DESCRIPTION EXAM_CAL_DESCRIPTION
, UAI.US_ASS_ITEM_GROUP_ID US_ASS_ITEM_GROUP_ID
, UAI.MIDTERM_MANDATORY_TYPE_CODE MIDTERM_MANDATORY_TYPE_CODE
, UAI.MIDTERM_WEIGHT_QTY MIDTERM_WEIGHT_QTY
, UAI.FINAL_MANDATORY_TYPE_CODE FINAL_MANDATORY_TYPE_CODE
, UAI.FINAL_WEIGHT_QTY FINAL_WEIGHT_QTY
FROM IGS_PS_UNITASS_ITEM UAI
, IGS_AS_GRD_SCHEMA GRD
, IGS_AS_ASSESSMNT_ITM_ALL AST
, IGS_CA_INST CI
WHERE UAI.GRADING_SCHEMA_CD = GRD.GRADING_SCHEMA_CD
AND UAI.GS_VERSION_NUMBER = GRD.VERSION_NUMBER
AND UAI.ASS_ID = AST.ASS_ID
AND UAI.EXAM_CAL_TYPE = CI.CAL_TYPE (+)
AND UAI.EXAM_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER (+)