VIEW: APPS.IGS_CO_OU_CO_V

Source

View Text - Preformatted

SELECT oc.ROWID, oc.person_id person_id, per.person_number, Igs_Co_Gen_001.corp_get_cor_cat(oc.person_id, NVL(ocr.course_cd, cori.course_cd)) CORRESPONDENCE_CAT, cori.CORRESPONDENCE_TYPE CORRESPONDENCE_TYPE, cori.reference_number reference_number, oc.issue_dt issue_dt, oc.dt_sent dt_sent, oc.unknown_return_dt unknown_return_dt, oc.ADDR_TYPE ADDR_TYPE, oc.comments, oc.LETTER_REFERENCE_NUMBER, oc.SPL_SEQUENCE_NUMBER, adt.description adt_description, oc.tracking_id tracking_id, cori.create_dt create_dt, cori.originator_person_id originator_person_id, cori.request_num request_num, cori.s_job_name s_job_name, cori.request_job_id request_job_id, cori.output_num output_num, cori.request_job_run_id request_job_run_id, NVL(ocr.CAL_TYPE, cori.CAL_TYPE) CAL_TYPE, NVL(ocr.ci_sequence_number, cori.ci_sequence_number) ci_sequence_number, NVL(ocr.course_cd, cori.course_cd) course_cd, NVL(ocr.cv_version_number, cori.cv_version_number) cv_version_number, NVL(ocr.unit_cd, cori.unit_cd) unit_cd, NVL(ocr.uv_version_number, cori.uv_version_number) uv_version_number, ocr.S_OTHER_REFERENCE_TYPE S_OTHER_REFERENCE_TYPE, ocr.other_reference other_reference, oc.comments oc_comments, cori.comments cori_comments, oc.created_by created_by, oc.creation_date creation_date, oc.last_updated_by last_updated_by, oc.last_update_date last_update_date, oc.last_update_login last_update_login FROM IGS_CO_OU_CO oc, IGS_CO_ITM cori, IGS_CO_ADDR_TYPE adt, IGS_CO_OU_CO_REF ocr, IGS_PE_PERSON per WHERE cori.CORRESPONDENCE_TYPE = oc.CORRESPONDENCE_TYPE AND cori.reference_number = oc.reference_number AND adt.ADDR_TYPE(+) = oc.ADDR_TYPE AND ocr.person_id(+) = oc.person_id AND ocr.CORRESPONDENCE_TYPE(+) = oc.CORRESPONDENCE_TYPE AND ocr.reference_number(+) = oc.reference_number AND ocr.issue_dt(+) = oc.issue_dt AND per.person_id = oc.person_id

View Text - HTML Formatted

SELECT OC.ROWID
, OC.PERSON_ID PERSON_ID
, PER.PERSON_NUMBER
, IGS_CO_GEN_001.CORP_GET_COR_CAT(OC.PERSON_ID
, NVL(OCR.COURSE_CD
, CORI.COURSE_CD)) CORRESPONDENCE_CAT
, CORI.CORRESPONDENCE_TYPE CORRESPONDENCE_TYPE
, CORI.REFERENCE_NUMBER REFERENCE_NUMBER
, OC.ISSUE_DT ISSUE_DT
, OC.DT_SENT DT_SENT
, OC.UNKNOWN_RETURN_DT UNKNOWN_RETURN_DT
, OC.ADDR_TYPE ADDR_TYPE
, OC.COMMENTS
, OC.LETTER_REFERENCE_NUMBER
, OC.SPL_SEQUENCE_NUMBER
, ADT.DESCRIPTION ADT_DESCRIPTION
, OC.TRACKING_ID TRACKING_ID
, CORI.CREATE_DT CREATE_DT
, CORI.ORIGINATOR_PERSON_ID ORIGINATOR_PERSON_ID
, CORI.REQUEST_NUM REQUEST_NUM
, CORI.S_JOB_NAME S_JOB_NAME
, CORI.REQUEST_JOB_ID REQUEST_JOB_ID
, CORI.OUTPUT_NUM OUTPUT_NUM
, CORI.REQUEST_JOB_RUN_ID REQUEST_JOB_RUN_ID
, NVL(OCR.CAL_TYPE
, CORI.CAL_TYPE) CAL_TYPE
, NVL(OCR.CI_SEQUENCE_NUMBER
, CORI.CI_SEQUENCE_NUMBER) CI_SEQUENCE_NUMBER
, NVL(OCR.COURSE_CD
, CORI.COURSE_CD) COURSE_CD
, NVL(OCR.CV_VERSION_NUMBER
, CORI.CV_VERSION_NUMBER) CV_VERSION_NUMBER
, NVL(OCR.UNIT_CD
, CORI.UNIT_CD) UNIT_CD
, NVL(OCR.UV_VERSION_NUMBER
, CORI.UV_VERSION_NUMBER) UV_VERSION_NUMBER
, OCR.S_OTHER_REFERENCE_TYPE S_OTHER_REFERENCE_TYPE
, OCR.OTHER_REFERENCE OTHER_REFERENCE
, OC.COMMENTS OC_COMMENTS
, CORI.COMMENTS CORI_COMMENTS
, OC.CREATED_BY CREATED_BY
, OC.CREATION_DATE CREATION_DATE
, OC.LAST_UPDATED_BY LAST_UPDATED_BY
, OC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CO_OU_CO OC
, IGS_CO_ITM CORI
, IGS_CO_ADDR_TYPE ADT
, IGS_CO_OU_CO_REF OCR
, IGS_PE_PERSON PER
WHERE CORI.CORRESPONDENCE_TYPE = OC.CORRESPONDENCE_TYPE
AND CORI.REFERENCE_NUMBER = OC.REFERENCE_NUMBER
AND ADT.ADDR_TYPE(+) = OC.ADDR_TYPE
AND OCR.PERSON_ID(+) = OC.PERSON_ID
AND OCR.CORRESPONDENCE_TYPE(+) = OC.CORRESPONDENCE_TYPE
AND OCR.REFERENCE_NUMBER(+) = OC.REFERENCE_NUMBER
AND OCR.ISSUE_DT(+) = OC.ISSUE_DT
AND PER.PERSON_ID = OC.PERSON_ID