VIEW: APPS.IGS_AS_EXM_SUPRVISOR_V

Source

View Text - Preformatted

SELECT ES.ROWID ROW_ID, P.PERSON_NUMBER PERSON_NUMBER, ES.PERSON_ID PERSON_ID, P.PREFERRED_NAME PREFERRED_NAME, PDV.SEX SEX, PDV.MEANING_SEX MEANING_SEX, PDV.BIRTH_DT BIRTH_DT, P.ENCUMBERED_IND ENCUMBERED_IND, PDV.DECEASED_IND DECEASED_IND, EST.DESCRIPTION ES_DESCRIPTION, EST.IN_CHARGE_IND IN_CHARGE_IND, EST.CLOSED_IND CLOSED_IND, ES.EXAM_SUPERVISOR_TYPE EXAM_SUPERVISOR_TYPE, ES.PREVIOUS_SESSIONS PREVIOUS_SESSIONS, ES.RESPONSIBLE_ORG_UNIT_CD RESPONSIBLE_ORG_UNIT_CD, OU.DESCRIPTION OU_DESCRIPTION, OU.ORG_STATUS ORG_STATUS, ORG_STATUS.S_ORG_STATUS S_ORG_STATUS, ES.RESPONSIBLE_OU_START_DT RESPONSIBLE_OU_START_DT, ES.COMMENTS COMMENTS, ES.CREATED_BY CREATED_BY, ES.CREATION_DATE CREATION_DATE, ES.LAST_UPDATED_BY LAST_UPDATED_BY, ES.LAST_UPDATE_DATE LAST_UPDATE_DATE, ES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AS_EXM_SUPRVISOR ES, IGS_PE_PERSON_V P, IGS_PE_PERSON_LKUPV_V PDV, IGS_AS_EXM_SPRVSRTYP EST, IGS_OR_UNIT OU, IGS_OR_STATUS ORG_STATUS WHERE ES.PERSON_ID = P.PERSON_ID AND PDV.PERSON_ID = ES.PERSON_ID AND EST.EXAM_SUPERVISOR_TYPE = ES.EXAM_SUPERVISOR_TYPE AND OU.ORG_UNIT_CD(+) = ES.RESPONSIBLE_ORG_UNIT_CD AND OU.START_DT(+) = ES.RESPONSIBLE_OU_START_DT AND ORG_STATUS.ORG_STATUS(+) = OU.ORG_STATUS

View Text - HTML Formatted

SELECT ES.ROWID ROW_ID
, P.PERSON_NUMBER PERSON_NUMBER
, ES.PERSON_ID PERSON_ID
, P.PREFERRED_NAME PREFERRED_NAME
, PDV.SEX SEX
, PDV.MEANING_SEX MEANING_SEX
, PDV.BIRTH_DT BIRTH_DT
, P.ENCUMBERED_IND ENCUMBERED_IND
, PDV.DECEASED_IND DECEASED_IND
, EST.DESCRIPTION ES_DESCRIPTION
, EST.IN_CHARGE_IND IN_CHARGE_IND
, EST.CLOSED_IND CLOSED_IND
, ES.EXAM_SUPERVISOR_TYPE EXAM_SUPERVISOR_TYPE
, ES.PREVIOUS_SESSIONS PREVIOUS_SESSIONS
, ES.RESPONSIBLE_ORG_UNIT_CD RESPONSIBLE_ORG_UNIT_CD
, OU.DESCRIPTION OU_DESCRIPTION
, OU.ORG_STATUS ORG_STATUS
, ORG_STATUS.S_ORG_STATUS S_ORG_STATUS
, ES.RESPONSIBLE_OU_START_DT RESPONSIBLE_OU_START_DT
, ES.COMMENTS COMMENTS
, ES.CREATED_BY CREATED_BY
, ES.CREATION_DATE CREATION_DATE
, ES.LAST_UPDATED_BY LAST_UPDATED_BY
, ES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_EXM_SUPRVISOR ES
, IGS_PE_PERSON_V P
, IGS_PE_PERSON_LKUPV_V PDV
, IGS_AS_EXM_SPRVSRTYP EST
, IGS_OR_UNIT OU
, IGS_OR_STATUS ORG_STATUS
WHERE ES.PERSON_ID = P.PERSON_ID
AND PDV.PERSON_ID = ES.PERSON_ID
AND EST.EXAM_SUPERVISOR_TYPE = ES.EXAM_SUPERVISOR_TYPE
AND OU.ORG_UNIT_CD(+) = ES.RESPONSIBLE_ORG_UNIT_CD
AND OU.START_DT(+) = ES.RESPONSIBLE_OU_START_DT
AND ORG_STATUS.ORG_STATUS(+) = OU.ORG_STATUS