VIEW: APPS.IGS_TR_TYPE_STEP_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)