View: IGS_SS_EN_POST_ADREQ_V

Product:	IGS - Student System
Description:	Selects all the Post Admission requirements for a particular Term Calendar
Implementation/DBA Data:	APPS.IGS_SS_EN_POST_ADREQ_V

View Text

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'

Columns