VIEW: APPS.IGS_RE_SPRVSR_V

Source

View Text - Preformatted

SELECT rsup.rowid row_id, rsup.ca_person_id, rsup.ca_sequence_number, rsup.person_id, pdv.person_number, rsup.sequence_number, pdv.surname, pdv.given_names, pdv.context_block_name, pdv.staff_member_ind, rsup.start_dt, rsup.end_dt, rsup.research_supervisor_type, rsup.supervisor_profession, rsup.supervision_percentage, rsup.funding_percentage, rsup.org_unit_cd, rsup.ou_start_dt, decode(rsup.replaced_person_id, NULL,NULL, rsup.replaced_person_id,rsup.ca_person_id) replaced_ca_person_id, decode(rsup.replaced_person_id, NULL,NULL, rsup.replaced_person_id,rsup.ca_sequence_number) replaced_ca_sequence_number, rsup.replaced_person_id, rsup.replaced_sequence_number, rsup.created_by, rsup.creation_date, rsup.last_updated_by, rsup.last_update_date, rsup.last_update_login, rsup.comments FROM IGS_RE_SPRVSR rsup, IGS_PE_PERSON_V pdv WHERE rsup.person_id = pdv.person_id

View Text - HTML Formatted

SELECT RSUP.ROWID ROW_ID
, RSUP.CA_PERSON_ID
, RSUP.CA_SEQUENCE_NUMBER
, RSUP.PERSON_ID
, PDV.PERSON_NUMBER
, RSUP.SEQUENCE_NUMBER
, PDV.SURNAME
, PDV.GIVEN_NAMES
, PDV.CONTEXT_BLOCK_NAME
, PDV.STAFF_MEMBER_IND
, RSUP.START_DT
, RSUP.END_DT
, RSUP.RESEARCH_SUPERVISOR_TYPE
, RSUP.SUPERVISOR_PROFESSION
, RSUP.SUPERVISION_PERCENTAGE
, RSUP.FUNDING_PERCENTAGE
, RSUP.ORG_UNIT_CD
, RSUP.OU_START_DT
, DECODE(RSUP.REPLACED_PERSON_ID
, NULL
, NULL
, RSUP.REPLACED_PERSON_ID
, RSUP.CA_PERSON_ID) REPLACED_CA_PERSON_ID
, DECODE(RSUP.REPLACED_PERSON_ID
, NULL
, NULL
, RSUP.REPLACED_PERSON_ID
, RSUP.CA_SEQUENCE_NUMBER) REPLACED_CA_SEQUENCE_NUMBER
, RSUP.REPLACED_PERSON_ID
, RSUP.REPLACED_SEQUENCE_NUMBER
, RSUP.CREATED_BY
, RSUP.CREATION_DATE
, RSUP.LAST_UPDATED_BY
, RSUP.LAST_UPDATE_DATE
, RSUP.LAST_UPDATE_LOGIN
, RSUP.COMMENTS
FROM IGS_RE_SPRVSR RSUP
, IGS_PE_PERSON_V PDV
WHERE RSUP.PERSON_ID = PDV.PERSON_ID