[Home] [Help]
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
Name |
ROW_ID |
TRACKING_TYPE |
START_DT |
COMPLETED |
BYPASSED |
PERSON_ID |
COURSE_CD |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |