VIEW: APPS.IGS_TR_STEP_V

Source

View Text - Preformatted

SELECT trst.rowid, trst.tracking_id, trst.tracking_step_id, trst.tracking_step_number, trst.description, trst.completion_dt, trst.action_days, igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id, tracking_step_number, tri.start_dt, tri.sequence_ind, tri.business_days_ind ), trst.step_completion_ind, trst.by_pass_ind, trst.recipient_id, pe.person_number, pe.FULL_NAME PREFERRED_NAME, igs_tr_gen_001.trkp_clc_days_ovrdue ( igs_tr_gen_001.trkp_clc_action_dt ( trst.tracking_id, tracking_step_number, tri.start_dt, tri.sequence_ind, tri.business_days_ind ), trst.completion_dt, tri.business_days_ind ), trst.s_tracking_step_type, lkup.meaning, trst.created_by, trst.creation_date, trst.last_updated_by, trst.last_update_date, trst.last_update_login, trst.step_catalog_cd, trst.step_group_id, trst.publish_ind FROM igs_tr_item tri, igs_tr_step trst, IGS_PE_PERSON_BASE_V pe, igs_lookups_view lkup WHERE tri.tracking_id = trst.tracking_id AND trst.recipient_id = pe.person_id (+) AND lkup.lookup_type (+) = 'TRACKING_STEP_TYPE' and TRST.S_TRACKING_STEP_TYPE = lkup.lookup_code (+)

View Text - HTML Formatted

SELECT TRST.ROWID
, TRST.TRACKING_ID
, TRST.TRACKING_STEP_ID
, TRST.TRACKING_STEP_NUMBER
, TRST.DESCRIPTION
, TRST.COMPLETION_DT
, TRST.ACTION_DAYS
, IGS_TR_GEN_001.TRKP_CLC_ACTION_DT ( TRST.TRACKING_ID
, TRACKING_STEP_NUMBER
, TRI.START_DT
, TRI.SEQUENCE_IND
, TRI.BUSINESS_DAYS_IND )
, TRST.STEP_COMPLETION_IND
, TRST.BY_PASS_IND
, TRST.RECIPIENT_ID
, PE.PERSON_NUMBER
, PE.FULL_NAME PREFERRED_NAME
, IGS_TR_GEN_001.TRKP_CLC_DAYS_OVRDUE ( IGS_TR_GEN_001.TRKP_CLC_ACTION_DT ( TRST.TRACKING_ID
, TRACKING_STEP_NUMBER
, TRI.START_DT
, TRI.SEQUENCE_IND
, TRI.BUSINESS_DAYS_IND )
, TRST.COMPLETION_DT
, TRI.BUSINESS_DAYS_IND )
, TRST.S_TRACKING_STEP_TYPE
, LKUP.MEANING
, TRST.CREATED_BY
, TRST.CREATION_DATE
, TRST.LAST_UPDATED_BY
, TRST.LAST_UPDATE_DATE
, TRST.LAST_UPDATE_LOGIN
, TRST.STEP_CATALOG_CD
, TRST.STEP_GROUP_ID
, TRST.PUBLISH_IND
FROM IGS_TR_ITEM TRI
, IGS_TR_STEP TRST
, IGS_PE_PERSON_BASE_V PE
, IGS_LOOKUPS_VIEW LKUP
WHERE TRI.TRACKING_ID = TRST.TRACKING_ID
AND TRST.RECIPIENT_ID = PE.PERSON_ID (+)
AND LKUP.LOOKUP_TYPE (+) = 'TRACKING_STEP_TYPE'
AND TRST.S_TRACKING_STEP_TYPE = LKUP.LOOKUP_CODE (+)