VIEW: APPS.IGS_CO_INTERACTION_HISTORY_V

Source

View Text - Preformatted

SELECT CINH.ROWID, CINH.REQUEST_ID, CINH.STUDENT_ID, CINH.DOCUMENT_ID, AMV.NAME, CINH.DOCUMENT_TYPE, CINH.SYS_LTR_CODE, CINH.ADM_APPLICATION_NUMBER, CINH.NOMINATED_COURSE_CD, CINH.SEQUENCE_NUMBER, FRH.OUTCOME_CODE, CINH.CAL_TYPE, CINH.CI_SEQUENCE_NUMBER, CI.START_DT, CI.END_DT, CI.ALTERNATE_CODE, CINH.CREATED_BY, CINH.CREATION_DATE, CINH.LAST_UPDATED_BY, CINH.LAST_UPDATE_DATE, CINH.LAST_UPDATE_LOGIN, CINH.REQUESTED_DATE, CINH.DELIVERY_TYPE, FRH.PROCESSED_DT_TM, DECODE(FRH.PARENT_REQ_ID,NULL,'N','Y'), CINH.VERSION_ID VERSON_ID FROM IGS_CO_INTERAC_HIST CINH, igs_ca_inst CI, IBC_CITEMS_V AMV, JTF_FM_REQUEST_HISTORY FRH WHERE cinh.cal_type = ci.cal_type(+) AND CINH.ci_sequence_number = ci.sequence_number(+) AND CINH.DOCUMENT_ID=AMV.CITEM_ID AND NVL(CINH.VERSION_ID,1)=AMV.VERSION AND CINH.REQUEST_ID = FRH.HIST_REQ_ID(+) AND AMV.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CINH.ROWID
, CINH.REQUEST_ID
, CINH.STUDENT_ID
, CINH.DOCUMENT_ID
, AMV.NAME
, CINH.DOCUMENT_TYPE
, CINH.SYS_LTR_CODE
, CINH.ADM_APPLICATION_NUMBER
, CINH.NOMINATED_COURSE_CD
, CINH.SEQUENCE_NUMBER
, FRH.OUTCOME_CODE
, CINH.CAL_TYPE
, CINH.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CINH.CREATED_BY
, CINH.CREATION_DATE
, CINH.LAST_UPDATED_BY
, CINH.LAST_UPDATE_DATE
, CINH.LAST_UPDATE_LOGIN
, CINH.REQUESTED_DATE
, CINH.DELIVERY_TYPE
, FRH.PROCESSED_DT_TM
, DECODE(FRH.PARENT_REQ_ID
, NULL
, 'N'
, 'Y')
, CINH.VERSION_ID VERSON_ID
FROM IGS_CO_INTERAC_HIST CINH
, IGS_CA_INST CI
, IBC_CITEMS_V AMV
, JTF_FM_REQUEST_HISTORY FRH
WHERE CINH.CAL_TYPE = CI.CAL_TYPE(+)
AND CINH.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)
AND CINH.DOCUMENT_ID=AMV.CITEM_ID
AND NVL(CINH.VERSION_ID
, 1)=AMV.VERSION
AND CINH.REQUEST_ID = FRH.HIST_REQ_ID(+)
AND AMV.LANGUAGE = USERENV('LANG')