VIEW: APPS.IGSFV_AS_UNT_SECTION_ASS_ITEMS

Source

View Text - Preformatted

SELECT UNAS.REFERENCE , UNAS.DESCRIPTION , UOO.UNIT_CD , UOO.VERSION_NUMBER , UOO.CAL_TYPE , UOO.CI_SEQUENCE_NUMBER , CI1.DESCRIPTION , UOO.LOCATION_CD , LOC.DESCRIPTION , UOO.UNIT_CLASS , UC.DESCRIPTION , USAG.GROUP_NAME , UNAS.CI_START_DT , UNAS.CI_END_DT , '_LA:UNAS.MIDTERM_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING' , UNAS.MIDTERM_WEIGHT_QTY , '_LA:UNAS.FINAL_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING' , UNAS.FINAL_WEIGHT_QTY , GS.DESCRIPTION , UNAS.DUE_DT , UNAS.RELEASE_DATE , UNAS.EXAM_CAL_TYPE , UNAS.EXAM_CI_SEQUENCE_NUMBER , CI2.DESCRIPTION , UNAS.ACTION_DT , '_LA:UNAS.DFLT_ITEM_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING' , UNAS.LOGICAL_DELETE_DT , UNAS.UNIT_SECTION_ASS_ITEM_ID , UNAS.UOO_ID , UNAS.ASS_ID , UNAS.SEQUENCE_NUMBER , UNAS.US_ASS_ITEM_GROUP_ID , UNAS.GRADING_SCHEMA_CD , UNAS.GS_VERSION_NUMBER , UNAS.CREATED_BY , UNAS.CREATION_DATE , UNAS.LAST_UPDATED_BY , UNAS.LAST_UPDATE_DATE FROM IGS_PS_UNITASS_ITEM UNAS, IGS_PS_UNIT_OFR_OPT_ALL UOO, IGS_PS_UNIT_VER_ALL UV, IGS_CA_INST_ALL CI1, IGS_AD_LOCATION_ALL LOC, IGS_AS_UNIT_CLASS_ALL UC, IGS_AS_US_AI_GROUP USAG, IGS_AS_GRD_SCHEMA GS, IGS_CA_INST_ALL CI2 WHERE UNAS.UOO_ID = UOO.UOO_ID AND UOO.UNIT_CD = UV.UNIT_CD AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER AND UOO.CAL_TYPE = CI1.CAL_TYPE AND UOO.CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER AND UOO.LOCATION_CD = LOC.LOCATION_CD AND UOO.UNIT_CLASS = UC.UNIT_CLASS AND UNAS.US_ASS_ITEM_GROUP_ID = USAG.US_ASS_ITEM_GROUP_ID AND UNAS.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD (+) AND UNAS.GS_VERSION_NUMBER = GS.VERSION_NUMBER (+) AND UNAS.EXAM_CAL_TYPE = CI2.CAL_TYPE (+) AND UNAS.EXAM_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER (+) WITH READ ONLY

View Text - HTML Formatted

SELECT UNAS.REFERENCE
, UNAS.DESCRIPTION
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, CI1.DESCRIPTION
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, UOO.UNIT_CLASS
, UC.DESCRIPTION
, USAG.GROUP_NAME
, UNAS.CI_START_DT
, UNAS.CI_END_DT
, '_LA:UNAS.MIDTERM_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, UNAS.MIDTERM_WEIGHT_QTY
, '_LA:UNAS.FINAL_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, UNAS.FINAL_WEIGHT_QTY
, GS.DESCRIPTION
, UNAS.DUE_DT
, UNAS.RELEASE_DATE
, UNAS.EXAM_CAL_TYPE
, UNAS.EXAM_CI_SEQUENCE_NUMBER
, CI2.DESCRIPTION
, UNAS.ACTION_DT
, '_LA:UNAS.DFLT_ITEM_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, UNAS.LOGICAL_DELETE_DT
, UNAS.UNIT_SECTION_ASS_ITEM_ID
, UNAS.UOO_ID
, UNAS.ASS_ID
, UNAS.SEQUENCE_NUMBER
, UNAS.US_ASS_ITEM_GROUP_ID
, UNAS.GRADING_SCHEMA_CD
, UNAS.GS_VERSION_NUMBER
, UNAS.CREATED_BY
, UNAS.CREATION_DATE
, UNAS.LAST_UPDATED_BY
, UNAS.LAST_UPDATE_DATE
FROM IGS_PS_UNITASS_ITEM UNAS
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CI1
, IGS_AD_LOCATION_ALL LOC
, IGS_AS_UNIT_CLASS_ALL UC
, IGS_AS_US_AI_GROUP USAG
, IGS_AS_GRD_SCHEMA GS
, IGS_CA_INST_ALL CI2
WHERE UNAS.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.CAL_TYPE = CI1.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND UNAS.US_ASS_ITEM_GROUP_ID = USAG.US_ASS_ITEM_GROUP_ID
AND UNAS.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD (+)
AND UNAS.GS_VERSION_NUMBER = GS.VERSION_NUMBER (+)
AND UNAS.EXAM_CAL_TYPE = CI2.CAL_TYPE (+)
AND UNAS.EXAM_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER (+) WITH READ ONLY