VIEW: APPS.IGS_AS_ASSESSMENT_ITM_V

Source

View Text - Preformatted

SELECT row_id ROW_ID , ai.ASS_ID , ai.ASSESSMENT_TYPE , ai.DESCRIPTION , ai.EXAM_SHORT_PAPER_NAME , ai.EXAM_PAPER_NAME , ai.EXAM_WORKING_TIME , ai.EXAM_PERUSAL_TIME , ai.EXAM_SCHEDULED_IND , ai.EXAM_SUPERVISOR_INSTRCTN , ai.EXAM_ANNOUNCEMENTS , ai.EXAM_ALLOWABLE_INSTRCTN , ai.EXAM_NON_ALLOWED_INSTRCTN , ai.EXAM_SUPPLIED_INSTRCTN , ai.EXAM_CONSTRAINTS , ai.QUESTION_OR_TITLE , ai.ASS_LENGTH_OR_DURATION , ai.CREATED_BY , ai.CREATION_DATE , ai.LAST_UPDATED_BY , ai.LAST_UPDATE_DATE , ai.LAST_UPDATE_LOGIN , ai.COMMENTS , ast.DESCRIPTION , ast.EXAMINABLE_IND , ast.CLOSED_IND , ast.ANON_GRADING_IND , ai.attribute_category , ai.attribute1 , ai.attribute2 , ai.attribute3 , ai.attribute4 , ai.attribute5 , ai.attribute6 , ai.attribute7 , ai.attribute8 , ai.attribute9 , ai.attribute10 , ai.attribute11 , ai.attribute12 , ai.attribute13 , ai.attribute14 , ai.attribute15 , ai.attribute16 , ai.attribute17 , ai.attribute18 , ai.attribute19 , ai.attribute20 ,ai.closed_ind FROM igs_as_assessmnt_itm ai , igs_as_assessmnt_typ ast WHERE ast.ASSESSMENT_TYPE = ai.ASSESSMENT_TYPE

View Text - HTML Formatted

SELECT ROW_ID ROW_ID
, AI.ASS_ID
, AI.ASSESSMENT_TYPE
, AI.DESCRIPTION
, AI.EXAM_SHORT_PAPER_NAME
, AI.EXAM_PAPER_NAME
, AI.EXAM_WORKING_TIME
, AI.EXAM_PERUSAL_TIME
, AI.EXAM_SCHEDULED_IND
, AI.EXAM_SUPERVISOR_INSTRCTN
, AI.EXAM_ANNOUNCEMENTS
, AI.EXAM_ALLOWABLE_INSTRCTN
, AI.EXAM_NON_ALLOWED_INSTRCTN
, AI.EXAM_SUPPLIED_INSTRCTN
, AI.EXAM_CONSTRAINTS
, AI.QUESTION_OR_TITLE
, AI.ASS_LENGTH_OR_DURATION
, AI.CREATED_BY
, AI.CREATION_DATE
, AI.LAST_UPDATED_BY
, AI.LAST_UPDATE_DATE
, AI.LAST_UPDATE_LOGIN
, AI.COMMENTS
, AST.DESCRIPTION
, AST.EXAMINABLE_IND
, AST.CLOSED_IND
, AST.ANON_GRADING_IND
, AI.ATTRIBUTE_CATEGORY
, AI.ATTRIBUTE1
, AI.ATTRIBUTE2
, AI.ATTRIBUTE3
, AI.ATTRIBUTE4
, AI.ATTRIBUTE5
, AI.ATTRIBUTE6
, AI.ATTRIBUTE7
, AI.ATTRIBUTE8
, AI.ATTRIBUTE9
, AI.ATTRIBUTE10
, AI.ATTRIBUTE11
, AI.ATTRIBUTE12
, AI.ATTRIBUTE13
, AI.ATTRIBUTE14
, AI.ATTRIBUTE15
, AI.ATTRIBUTE16
, AI.ATTRIBUTE17
, AI.ATTRIBUTE18
, AI.ATTRIBUTE19
, AI.ATTRIBUTE20
, AI.CLOSED_IND
FROM IGS_AS_ASSESSMNT_ITM AI
, IGS_AS_ASSESSMNT_TYP AST
WHERE AST.ASSESSMENT_TYPE = AI.ASSESSMENT_TYPE