Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Contains data used to link tables for application instances and admission requirements related tracking items. |
Implementation/DBA Data: | Not implemented in this database |
SELECT APR.APLINS_ADMREQ_ID
, APR.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APR.ADMISSION_APPL_NUMBER
, APR.COURSE_CD
, APR.SEQUENCE_NUMBER
, APR.TRACKING_ID
, TRST.TRACKING_STEP_ID
, TRST.TRACKING_STEP_NUMBER
, TRST.DESCRIPTION
, TRST.COMPLETION_DT
, TRST.ACTION_DAYS
, '_LA:TRST.STEP_COMPLETION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:TRST.BY_PASS_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, TRI.TRACKING_STATUS
, TRI.TRACKING_TYPE
, TRT.DESCRIPTION
, '_LA:TRT.S_TRACKING_TYPE:IGS_LOOKUP_VALUES:TRACKING_TYPE:MEANING'
, APR.CREATED_BY
, APR.CREATION_DATE
, APR.LAST_UPDATED_BY
, APR.LAST_UPDATE_DATE
FROM IGS_AD_APLINS_ADMREQ APR
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_TR_ITEM_ALL TRI
, IGS_TR_TYPE_ALL TRT
, IGS_TR_STEP TRST
WHERE APR.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND APR.TRACKING_ID = TRI.TRACKING_ID
AND TRI.TRACKING_TYPE = TRT.TRACKING_TYPE
AND TRI.TRACKING_ID = TRST.TRACKING_ID WITH READ ONLY