Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT TRI.ROWID
, TRI.ORG_ID
, TRI.TRACKING_ID
, TRI.TRACKING_STATUS
, TRI.TRACKING_TYPE
, TRT.DESCRIPTION
, TRI.SOURCE_PERSON_ID
, PE1.PERSON_NUMBER
, PE1.FULL_NAME DSP_PREFERRED_NAME2
, TRI.START_DT
, TRI.TARGET_DAYS
, IGS_TR_GEN_001.TRKP_CLC_DT_OFFSET ( TRI.START_DT
, TRI.TARGET_DAYS
, TRI.BUSINESS_DAYS_IND
, TRI.OVERRIDE_OFFSET_CLC_IND )
, TRI.SEQUENCE_IND
, TRI.BUSINESS_DAYS_IND
, TRI.ORIGINATOR_PERSON_ID
, PE2.PERSON_NUMBER
, PE2.FULL_NAME DSP_PREFERRED_NAME
, TRI.S_CREATED_IND
, IGS_TR_GEN_001.TRKP_CLC_TRI_CMP_DT ( TRI.TRACKING_ID
, TRI.START_DT )
, IGS_TR_GEN_001.TRKP_CLC_DAYS_OVRDUE ( IGS_TR_GEN_001.TRKP_CLC_DT_OFFSET ( TRI.START_DT
, TRI.TARGET_DAYS
, TRI.BUSINESS_DAYS_IND
, TRI.OVERRIDE_OFFSET_CLC_IND )
, IGS_TR_GEN_001.TRKP_CLC_TRI_CMP_DT ( TRI.TRACKING_ID
, TRI.START_DT )
, TRI.BUSINESS_DAYS_IND )
, TRI.CREATED_BY
, TRI.CREATION_DATE
, TRI.LAST_UPDATED_BY
, TRI.LAST_UPDATE_DATE
, TRI.LAST_UPDATE_LOGIN
, TRI.COMPLETION_DUE_DT
, TRI.OVERRIDE_OFFSET_CLC_IND
, TRI.PUBLISH_IND
FROM IGS_TR_ITEM TRI
, IGS_PE_PERSON_BASE_V PE1
, IGS_PE_PERSON_BASE_V PE2
, IGS_TR_TYPE TRT
WHERE TRI.SOURCE_PERSON_ID = PE1.PERSON_ID (+)
AND TRI.ORIGINATOR_PERSON_ID = PE2.PERSON_ID (+)
AND TRT.TRACKING_TYPE = TRI.TRACKING_TYPE