VIEW: APPS.IGS_AS_UAI_FIND_V

Source

View Text - Preformatted

SELECT uai.unit_cd, uai.version_number, uai.cal_type, uai.ci_sequence_number, uai.ass_id, uai.sequence_number, uai.reference, uai.ci_start_dt, uai.ci_end_dt, NULL ,uai.grading_schema_cd ,uai.gs_version_number ,grd.description grading_schema_desc ,uai.release_date ,NULL, NULL, uai.dflt_item_ind, uai.logical_delete_dt, ai.assessment_type, NVL(uai. description, ai.description), ai.exam_scheduled_ind, ai.exam_short_paper_name, ai.exam_paper_name, ai.exam_working_time, ai.exam_perusal_time, ai.question_or_title, ai.ass_length_or_duration, atyp.examinable_ind, uai.created_by, uai.creation_date, uai.last_updated_by, uai.last_update_date, uai.last_update_login, 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_ASSESSMNT_TYP atyp, IGS_AS_ASSESSMNT_ITM_ALL ai, IGS_AS_UNITASS_ITEM_ALL uai , IGS_AS_GRD_SCHEMA grd WHERE uai.ass_id = ai.ass_id and ai.assessment_type = atyp.assessment_type and uai.grading_schema_cd = grd.grading_schema_cd and uai.gs_version_number = grd.version_number

View Text - HTML Formatted

SELECT UAI.UNIT_CD
, UAI.VERSION_NUMBER
, UAI.CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER
, UAI.ASS_ID
, UAI.SEQUENCE_NUMBER
, UAI.REFERENCE
, UAI.CI_START_DT
, UAI.CI_END_DT
, NULL
, UAI.GRADING_SCHEMA_CD
, UAI.GS_VERSION_NUMBER
, GRD.DESCRIPTION GRADING_SCHEMA_DESC
, UAI.RELEASE_DATE
, NULL
, NULL
, UAI.DFLT_ITEM_IND
, UAI.LOGICAL_DELETE_DT
, AI.ASSESSMENT_TYPE
, NVL(UAI. DESCRIPTION
, AI.DESCRIPTION)
, AI.EXAM_SCHEDULED_IND
, AI.EXAM_SHORT_PAPER_NAME
, AI.EXAM_PAPER_NAME
, AI.EXAM_WORKING_TIME
, AI.EXAM_PERUSAL_TIME
, AI.QUESTION_OR_TITLE
, AI.ASS_LENGTH_OR_DURATION
, ATYP.EXAMINABLE_IND
, UAI.CREATED_BY
, UAI.CREATION_DATE
, UAI.LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE
, UAI.LAST_UPDATE_LOGIN
, 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_ASSESSMNT_TYP ATYP
, IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_AS_UNITASS_ITEM_ALL UAI
, IGS_AS_GRD_SCHEMA GRD
WHERE UAI.ASS_ID = AI.ASS_ID
AND AI.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE
AND UAI.GRADING_SCHEMA_CD = GRD.GRADING_SCHEMA_CD
AND UAI.GS_VERSION_NUMBER = GRD.VERSION_NUMBER