VIEW: APPS.IGS_SS_EN_POST_ADREQ_V

Source

View Text - Preformatted

SELECT ts.rowid row_id, ts.description tracking_type , ts.completion_dt start_dt, lk1.meaning completed, lk2.meaning bypassed, at.person_id person_id, at.course_cd course_cd , ts.CREATED_BY , ts.CREATION_DATE , ts.LAST_UPDATED_BY , ts.LAST_UPDATE_DATE , ts.LAST_UPDATE_LOGIN FROM IGS_TR_STEP ts, IGS_TR_TYPE tt, IGS_TR_ITEM ti, IGS_AD_APLINS_ADMREQ at, IGS_LOOKUPS_VIEW lk1, IGS_LOOKUPS_VIEW lk2 WHERE ts.tracking_id = ti.tracking_id AND ti.tracking_id = at.tracking_id AND tt.tracking_type = ti.tracking_type AND tt.s_tracking_type = 'POST_ADMISSION' AND lk1.lookup_code = ts.step_completion_ind AND lk1.lookup_type = 'VS_AS_YN' AND lk2.lookup_code = ts.by_pass_ind AND lk2.lookup_type = 'VS_AS_YN'

View Text - HTML Formatted

SELECT TS.ROWID ROW_ID
, TS.DESCRIPTION TRACKING_TYPE
, TS.COMPLETION_DT START_DT
, LK1.MEANING COMPLETED
, LK2.MEANING BYPASSED
, AT.PERSON_ID PERSON_ID
, AT.COURSE_CD COURSE_CD
, TS.CREATED_BY
, TS.CREATION_DATE
, TS.LAST_UPDATED_BY
, TS.LAST_UPDATE_DATE
, TS.LAST_UPDATE_LOGIN
FROM IGS_TR_STEP TS
, IGS_TR_TYPE TT
, IGS_TR_ITEM TI
, IGS_AD_APLINS_ADMREQ AT
, IGS_LOOKUPS_VIEW LK1
, IGS_LOOKUPS_VIEW LK2
WHERE TS.TRACKING_ID = TI.TRACKING_ID
AND TI.TRACKING_ID = AT.TRACKING_ID
AND TT.TRACKING_TYPE = TI.TRACKING_TYPE
AND TT.S_TRACKING_TYPE = 'POST_ADMISSION'
AND LK1.LOOKUP_CODE = TS.STEP_COMPLETION_IND
AND LK1.LOOKUP_TYPE = 'VS_AS_YN'
AND LK2.LOOKUP_CODE = TS.BY_PASS_IND
AND LK2.LOOKUP_TYPE = 'VS_AS_YN'