VIEW: APPS.IGS_AS_SUSA_V

Source

View Text - Preformatted

SELECT person_id, course_cd, unit_set_cd, sequence_number, us_version_number, SUBSTR(LPAD(' ',2*(LEVEL-1)) || unit_set_cd, 1, 40), end_dt, created_by, creation_date, last_updated_by, last_update_date, last_update_login FROM IGS_AS_SU_SETATMPT START WITH parent_unit_set_cd is NULL CONNECT BY PRIOR person_id = person_id AND PRIOR course_cd = course_cd AND PRIOR unit_set_cd = parent_unit_set_cd AND PRIOR sequence_number = parent_sequence_number

View Text - HTML Formatted

SELECT PERSON_ID
, COURSE_CD
, UNIT_SET_CD
, SEQUENCE_NUMBER
, US_VERSION_NUMBER
, SUBSTR(LPAD(' '
, 2*(LEVEL-1)) || UNIT_SET_CD
, 1
, 40)
, END_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_AS_SU_SETATMPT START WITH PARENT_UNIT_SET_CD IS NULL CONNECT BY PRIOR PERSON_ID = PERSON_ID
AND PRIOR COURSE_CD = COURSE_CD
AND PRIOR UNIT_SET_CD = PARENT_UNIT_SET_CD
AND PRIOR SEQUENCE_NUMBER = PARENT_SEQUENCE_NUMBER