Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT TTS.ROWID ROW_ID
, TTS.ORG_ID
, TTS.TRACKING_TYPE
, TTS.TRACKING_TYPE_STEP_ID
, TTS.TRACKING_TYPE_STEP_NUMBER
, TTS.DESCRIPTION
, TTS.S_TRACKING_STEP_TYPE
, LKUP.MEANING
, TTS.ACTION_DAYS
, TTS.RECIPIENT_ID
, PE.PERSON_NUMBER RECIPIENT_NUMBER
, NULL DSP_STAFF_MEMBER_IND
, PE.FULL_NAME DSP_PREFERRED_NAME
, TTS.CREATED_BY
, TTS.CREATION_DATE
, TTS.LAST_UPDATED_BY
, TTS.LAST_UPDATE_DATE
, TTS.LAST_UPDATE_LOGIN
, TTS.STEP_CATALOG_CD
, TTS.STEP_GROUP_ID
, TTS.PUBLISH_IND
FROM IGS_TR_TYPE_STEP TTS
, IGS_PE_PERSON_BASE_V PE
, IGS_LOOKUPS_VIEW LKUP
WHERE TTS.RECIPIENT_ID = PE.PERSON_ID (+)
AND LKUP.LOOKUP_TYPE (+) = 'TRACKING_STEP_TYPE'
AND TTS.S_TRACKING_STEP_TYPE = LKUP.LOOKUP_CODE (+)