VIEW: APPS.IGSFV_AS_UNIT_ASSESSMENT_ITEMS

Source

View Text - Preformatted

SELECT UAI.REFERENCE , UAI.DESCRIPTION , UAI.UNIT_CD , UAI.VERSION_NUMBER , UV.TITLE , UAI.CAL_TYPE , UAI.CI_SEQUENCE_NUMBER , CI1.DESCRIPTION , AI.DESCRIPTION , UAIG.GROUP_NAME , UAI.CI_START_DT , UAI.CI_END_DT , '_LA:UAI.MIDTERM_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING' , UAI.MIDTERM_WEIGHT_QTY , '_LA:UAI.FINAL_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING' , UAI.FINAL_WEIGHT_QTY , GS.DESCRIPTION , UAI.DUE_DT , UAI.RELEASE_DATE , UAI.EXAM_CAL_TYPE , UAI.EXAM_CI_SEQUENCE_NUMBER , CI2.DESCRIPTION , UAI.ACTION_DT , '_LA:UAI.DFLT_ITEM_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING' , UAI.LOGICAL_DELETE_DT , UAI.UNIT_ASS_ITEM_ID , UAI.ASS_ID , UAI.SEQUENCE_NUMBER , UAI.UNIT_ASS_ITEM_GROUP_ID , UAI.GRADING_SCHEMA_CD , UAI.GS_VERSION_NUMBER , UAI.CREATED_BY , UAI.CREATION_DATE , UAI.LAST_UPDATED_BY , UAI.LAST_UPDATE_DATE FROM IGS_AS_UNITASS_ITEM_ALL UAI, IGS_PS_UNIT_VER_ALL UV, IGS_CA_INST_ALL CI1, IGS_AS_ASSESSMNT_ITM_ALL AI, IGS_AS_UNIT_AI_GRP UAIG, IGS_AS_GRD_SCHEMA GS, IGS_CA_INST_ALL CI2 WHERE UAI.UNIT_CD = UV.UNIT_CD AND UAI.VERSION_NUMBER = UV.VERSION_NUMBER AND UAI.CAL_TYPE = CI1.CAL_TYPE AND UAI.CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER AND UAI.ASS_ID = AI.ASS_ID AND UAI.UNIT_ASS_ITEM_GROUP_ID = UAIG.UNIT_ASS_ITEM_GROUP_ID AND UAI.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD AND UAI.GS_VERSION_NUMBER = GS.VERSION_NUMBER AND UAIG.CAL_TYPE = CI2.CAL_TYPE (+) AND UAIG.CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER (+) WITH READ ONLY

View Text - HTML Formatted

SELECT UAI.REFERENCE
, UAI.DESCRIPTION
, UAI.UNIT_CD
, UAI.VERSION_NUMBER
, UV.TITLE
, UAI.CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER
, CI1.DESCRIPTION
, AI.DESCRIPTION
, UAIG.GROUP_NAME
, UAI.CI_START_DT
, UAI.CI_END_DT
, '_LA:UAI.MIDTERM_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, UAI.MIDTERM_WEIGHT_QTY
, '_LA:UAI.FINAL_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, UAI.FINAL_WEIGHT_QTY
, GS.DESCRIPTION
, UAI.DUE_DT
, UAI.RELEASE_DATE
, UAI.EXAM_CAL_TYPE
, UAI.EXAM_CI_SEQUENCE_NUMBER
, CI2.DESCRIPTION
, UAI.ACTION_DT
, '_LA:UAI.DFLT_ITEM_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, UAI.LOGICAL_DELETE_DT
, UAI.UNIT_ASS_ITEM_ID
, UAI.ASS_ID
, UAI.SEQUENCE_NUMBER
, UAI.UNIT_ASS_ITEM_GROUP_ID
, UAI.GRADING_SCHEMA_CD
, UAI.GS_VERSION_NUMBER
, UAI.CREATED_BY
, UAI.CREATION_DATE
, UAI.LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE
FROM IGS_AS_UNITASS_ITEM_ALL UAI
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CI1
, IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_AS_UNIT_AI_GRP UAIG
, IGS_AS_GRD_SCHEMA GS
, IGS_CA_INST_ALL CI2
WHERE UAI.UNIT_CD = UV.UNIT_CD
AND UAI.VERSION_NUMBER = UV.VERSION_NUMBER
AND UAI.CAL_TYPE = CI1.CAL_TYPE
AND UAI.CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND UAI.ASS_ID = AI.ASS_ID
AND UAI.UNIT_ASS_ITEM_GROUP_ID = UAIG.UNIT_ASS_ITEM_GROUP_ID
AND UAI.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD
AND UAI.GS_VERSION_NUMBER = GS.VERSION_NUMBER
AND UAIG.CAL_TYPE = CI2.CAL_TYPE (+)
AND UAIG.CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER (+) WITH READ ONLY