VIEW: APPS.IGS_AS_UAP_ITEM_V

Source

View Text - Preformatted

SELECT uai.rowid, uai.unit_ass_item_id, uai.unit_cd, uai.version_number, uai.cal_type, uai.ci_sequence_number, uapi.ass_pattern_id, uai.ass_id, uai.sequence_number, uai.location_cd, uai.unit_mode, uai.unit_class, uai.due_dt, uai.reference, uapi.apportionment_percentage, uai.dflt_item_ind, uai.logical_delete_dt, uai.action_dt, uai.exam_cal_type, uai.exam_ci_sequence_number ,uai.grading_schema_cd ,uai.gs_version_number ,grd.description grading_schema_desc ,uai.release_date ,uai.created_by, uai.creation_date, uai.last_updated_by, uai.last_update_date, uai.last_update_login, NVL(uai. description, ast.description) FROM IGS_AS_UNITASS_ITEM_ALL uai, IGS_AS_UNT_PATRN_ITM uapi, IGS_AS_GRD_SCHEMA grd, IGS_AS_ASSESSMNT_ITM_ALL ast WHERE uai.unit_cd = uapi.unit_cd AND uai.version_number = uapi.version_number AND uai.cal_type = uapi.cal_type AND uai.ci_sequence_number = uapi.ci_sequence_number AND uai.ass_id = uapi.ass_id AND uai.sequence_number = uapi.uai_sequence_number AND uai.ass_id = ast.ass_id and uai.grading_schema_cd = grd.grading_schema_cd and uai.gs_version_number = grd.version_number

View Text - HTML Formatted

SELECT UAI.ROWID
, UAI.UNIT_ASS_ITEM_ID
, UAI.UNIT_CD
, UAI.VERSION_NUMBER
, UAI.CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER
, UAPI.ASS_PATTERN_ID
, UAI.ASS_ID
, UAI.SEQUENCE_NUMBER
, UAI.LOCATION_CD
, UAI.UNIT_MODE
, UAI.UNIT_CLASS
, UAI.DUE_DT
, UAI.REFERENCE
, UAPI.APPORTIONMENT_PERCENTAGE
, UAI.DFLT_ITEM_IND
, UAI.LOGICAL_DELETE_DT
, UAI.ACTION_DT
, UAI.EXAM_CAL_TYPE
, UAI.EXAM_CI_SEQUENCE_NUMBER
, UAI.GRADING_SCHEMA_CD
, UAI.GS_VERSION_NUMBER
, GRD.DESCRIPTION GRADING_SCHEMA_DESC
, UAI.RELEASE_DATE
, UAI.CREATED_BY
, UAI.CREATION_DATE
, UAI.LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE
, UAI.LAST_UPDATE_LOGIN
, NVL(UAI. DESCRIPTION
, AST.DESCRIPTION)
FROM IGS_AS_UNITASS_ITEM_ALL UAI
, IGS_AS_UNT_PATRN_ITM UAPI
, IGS_AS_GRD_SCHEMA GRD
, IGS_AS_ASSESSMNT_ITM_ALL AST
WHERE UAI.UNIT_CD = UAPI.UNIT_CD
AND UAI.VERSION_NUMBER = UAPI.VERSION_NUMBER
AND UAI.CAL_TYPE = UAPI.CAL_TYPE
AND UAI.CI_SEQUENCE_NUMBER = UAPI.CI_SEQUENCE_NUMBER
AND UAI.ASS_ID = UAPI.ASS_ID
AND UAI.SEQUENCE_NUMBER = UAPI.UAI_SEQUENCE_NUMBER
AND UAI.ASS_ID = AST.ASS_ID
AND UAI.GRADING_SCHEMA_CD = GRD.GRADING_SCHEMA_CD
AND UAI.GS_VERSION_NUMBER = GRD.VERSION_NUMBER