VIEW: APPS.IGSFV_AS_ASSESSMENT_ITEMS

Source

View Text - Preformatted

SELECT AI.DESCRIPTION , AI.ASSESSMENT_TYPE , ATYP.DESCRIPTION , AI.EXAM_SHORT_PAPER_NAME , AI.EXAM_PAPER_NAME , AI.EXAM_WORKING_TIME , AI.EXAM_PERUSAL_TIME , '_LA:AI.EXAM_SCHEDULED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING' , 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.COMMENTS , '_LA:AI.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING' , '_DF:IGS:IGS_AS_ASS_ITM_DESC_FLEX:AI' , AI.ASS_ID , AI.CREATED_BY , AI.CREATION_DATE , AI.LAST_UPDATED_BY , AI.LAST_UPDATE_DATE FROM IGS_AS_ASSESSMNT_ITM_ALL AI, IGS_AS_ASSESSMNT_TYP ATYP WHERE AI.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT AI.DESCRIPTION
, AI.ASSESSMENT_TYPE
, ATYP.DESCRIPTION
, AI.EXAM_SHORT_PAPER_NAME
, AI.EXAM_PAPER_NAME
, AI.EXAM_WORKING_TIME
, AI.EXAM_PERUSAL_TIME
, '_LA:AI.EXAM_SCHEDULED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, 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.COMMENTS
, '_LA:AI.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_DF:IGS:IGS_AS_ASS_ITM_DESC_FLEX:AI'
, AI.ASS_ID
, AI.CREATED_BY
, AI.CREATION_DATE
, AI.LAST_UPDATED_BY
, AI.LAST_UPDATE_DATE
FROM IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_AS_ASSESSMNT_TYP ATYP
WHERE AI.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE WITH READ ONLY