VIEW: APPS.IGSBV_AS_UNIT_SEC_ATTENDANCES

Source

View Text - Preformatted

SELECT HP.PARTY_NAME, HP.PARTY_NUMBER, UAL.COURSE_CD, UOO.UNIT_CD, UV.TITLE, UOO.UNIT_CLASS, UC.DESCRIPTION, UOO.LOCATION_CD, LOC.DESCRIPTION, UOO. CAL_TYPE, UOO. CI_SEQUENCE_NUMBER, CI.DESCRIPTION, UAL.ATTENDANCE_HOURS, '_LA:UAL.SUBMITTED:IGS_LOOKUP_VALUES:YES_NO:MEANING', UAL.PERSON_ID, UAL.UOO_ID, UAL.CREATED_BY, UAL.CREATION_DATE, UAL.LAST_UPDATED_BY, UAL.LAST_UPDATE_DATE FROM IGS_AS_USEC_ATD_LINE UAL, HZ_PARTIES HP, IGS_PS_UNIT_VER_ALL UV, IGS_AS_UNIT_CLASS_ALL UC, IGS_AD_LOCATION LOC, IGS_CA_INST_ALL CI, IGS_PS_UNIT_OFR_OPT_ALL UOO WHERE UAL.PERSON_ID = HP.PARTY_ID AND UAL.UOO_ID = UOO.UOO_ID AND UOO.UNIT_CD = UV.UNIT_CD AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER AND UOO.UNIT_CLASS = UC.UNIT_CLASS AND UOO.LOCATION_CD = LOC.LOCATION_CD AND UOO.CAL_TYPE = CI.CAL_TYPE AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, UAL.COURSE_CD
, UOO.UNIT_CD
, UV.TITLE
, UOO.UNIT_CLASS
, UC.DESCRIPTION
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, UOO. CAL_TYPE
, UOO. CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UAL.ATTENDANCE_HOURS
, '_LA:UAL.SUBMITTED:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, UAL.PERSON_ID
, UAL.UOO_ID
, UAL.CREATED_BY
, UAL.CREATION_DATE
, UAL.LAST_UPDATED_BY
, UAL.LAST_UPDATE_DATE
FROM IGS_AS_USEC_ATD_LINE UAL
, HZ_PARTIES HP
, IGS_PS_UNIT_VER_ALL UV
, IGS_AS_UNIT_CLASS_ALL UC
, IGS_AD_LOCATION LOC
, IGS_CA_INST_ALL CI
, IGS_PS_UNIT_OFR_OPT_ALL UOO
WHERE UAL.PERSON_ID = HP.PARTY_ID
AND UAL.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY