VIEW: APPS.IGS_CO_ITM_V

Source

View Text - Preformatted

SELECT c.ROW_ID , c.CORRESPONDENCE_TYPE , c.REFERENCE_NUMBER , c.CREATE_DT , c.S_JOB_NAME , c.REQUEST_JOB_ID , c.OUTPUT_NUM , c.REQUEST_JOB_RUN_ID, c.CAL_TYPE , c.CI_SEQUENCE_NUMBER , c.COURSE_CD , c.CV_VERSION_NUMBER , c.UNIT_CD , c.UV_VERSION_NUMBER , c.COMMENTS , c.CREATED_BY , c.CREATION_DATE , c.LAST_UPDATED_BY , c.LAST_UPDATE_DATE , c.LAST_UPDATE_LOGIN , c.REQUEST_ID , c.PROGRAM_ID , c.PROGRAM_APPLICATION_ID , c.PROGRAM_UPDATE_DATE , c.ORIGINATOR_PERSON_ID , P.PERSON_NUMBER , c.REQUEST_NUM , c.JOB_REQUEST_ID , c.ORG_ID FROM igs_co_itm c, igs_pe_person p WHERE c.ORIGINATOR_PERSON_ID = p.person_id (+)

View Text - HTML Formatted

SELECT C.ROW_ID
, C.CORRESPONDENCE_TYPE
, C.REFERENCE_NUMBER
, C.CREATE_DT
, C.S_JOB_NAME
, C.REQUEST_JOB_ID
, C.OUTPUT_NUM
, C.REQUEST_JOB_RUN_ID
, C.CAL_TYPE
, C.CI_SEQUENCE_NUMBER
, C.COURSE_CD
, C.CV_VERSION_NUMBER
, C.UNIT_CD
, C.UV_VERSION_NUMBER
, C.COMMENTS
, C.CREATED_BY
, C.CREATION_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATE_LOGIN
, C.REQUEST_ID
, C.PROGRAM_ID
, C.PROGRAM_APPLICATION_ID
, C.PROGRAM_UPDATE_DATE
, C.ORIGINATOR_PERSON_ID
, P.PERSON_NUMBER
, C.REQUEST_NUM
, C.JOB_REQUEST_ID
, C.ORG_ID
FROM IGS_CO_ITM C
, IGS_PE_PERSON P
WHERE C.ORIGINATOR_PERSON_ID = P.PERSON_ID (+)