VIEW: APPS.IGS_AD_APLINS_ADMREQ_APLPRC_V

Source

View Text - Preformatted

SELECT APREQ.ROWID ROW_ID, APREQ.APLINS_ADMREQ_ID, APREQ.PERSON_ID, APREQ.ADMISSION_APPL_NUMBER, APREQ.COURSE_CD, APREQ.SEQUENCE_NUMBER, APREQ.TRACKING_ID, TRI.TRACKING_STATUS, TRI.TRACKING_TYPE, TRT.DESCRIPTION, TRT.S_TRACKING_TYPE, APREQ.CREATED_BY, APREQ.CREATION_DATE, APREQ.LAST_UPDATED_BY, APREQ.LAST_UPDATE_DATE, APREQ.LAST_UPDATE_LOGIN, APREQ.REQUEST_ID, APREQ.PROGRAM_APPLICATION_ID, APREQ.PROGRAM_ID, APREQ.PROGRAM_UPDATE_DATE FROM IGS_AD_APLINS_ADMREQ APREQ, IGS_TR_ITEM TRI, IGS_TR_TYPE TRT, IGS_LOOKUPS_VIEW LKP WHERE APREQ.TRACKING_ID = TRI.TRACKING_ID AND TRI.TRACKING_TYPE = TRT.TRACKING_TYPE AND TRT.S_TRACKING_TYPE = LKP.LOOKUP_CODE AND LKP.LOOKUP_TYPE = 'TRACKING_TYPE' AND LKP.LOOKUP_CODE IN ('ADM_PROCESSING', 'POST_ADMISSION')

View Text - HTML Formatted

SELECT APREQ.ROWID ROW_ID
, APREQ.APLINS_ADMREQ_ID
, APREQ.PERSON_ID
, APREQ.ADMISSION_APPL_NUMBER
, APREQ.COURSE_CD
, APREQ.SEQUENCE_NUMBER
, APREQ.TRACKING_ID
, TRI.TRACKING_STATUS
, TRI.TRACKING_TYPE
, TRT.DESCRIPTION
, TRT.S_TRACKING_TYPE
, APREQ.CREATED_BY
, APREQ.CREATION_DATE
, APREQ.LAST_UPDATED_BY
, APREQ.LAST_UPDATE_DATE
, APREQ.LAST_UPDATE_LOGIN
, APREQ.REQUEST_ID
, APREQ.PROGRAM_APPLICATION_ID
, APREQ.PROGRAM_ID
, APREQ.PROGRAM_UPDATE_DATE
FROM IGS_AD_APLINS_ADMREQ APREQ
, IGS_TR_ITEM TRI
, IGS_TR_TYPE TRT
, IGS_LOOKUPS_VIEW LKP
WHERE APREQ.TRACKING_ID = TRI.TRACKING_ID
AND TRI.TRACKING_TYPE = TRT.TRACKING_TYPE
AND TRT.S_TRACKING_TYPE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'TRACKING_TYPE'
AND LKP.LOOKUP_CODE IN ('ADM_PROCESSING'
, 'POST_ADMISSION')