VIEW: APPS.IGS_TR_ITEM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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