VIEW: APPS.IGSFV_AS_SPECIAL_CONSID_APPLS

Source

View Text - Preformatted

SELECT HP.PARTY_NAME, HP.PARTY_NUMBER, SCAP.COURSE_CD, CRV.TITLE, SCAP.UNIT_CD, UV.TITLE, SCAP.CAL_TYPE, SCAP.CI_SEQUENCE_NUMBER, CI.DESCRIPTION, UOO.LOCATION_CD, LOC.DESCRIPTION, AI.DESCRIPTION, SCAP.CREATION_DT, SCAP.RECEIVED_DT, SCAP.SOUGHT_OUTCOME, SPCO1.DESCRIPTION, SCAP.SPCL_CONSIDERATION_CAT, SPCC.DESCRIPTION, SCAP.SPCL_CONSIDERATION_OUTCOME, SPCO.DESCRIPTION, SCAP.ESTIMATED_PROCESSING_DAYS, SCAP.TRACKING_ID, SCAP.COMMENTS, SCAP.NOTIFIED_DATE, SCAP.PERSON_ID, SCAP.UOO_ID, SCAP.ASS_ID, SCAP.CREATED_BY, SCAP.CREATION_DATE, SCAP.LAST_UPDATED_BY, SCAP.LAST_UPDATE_DATE FROM HZ_PARTIES HP, IGS_AS_SPL_CONS_APPL SCAP, IGS_PS_VER_ALL CRV, IGS_PS_UNIT_VER_ALL UV, IGS_AS_ASSESSMNT_ITM_ALL AI, IGS_AS_SPCL_CONS_CAT SPCC, IGS_AS_SPCL_CONS_OUT SPCO, IGS_AS_SPCL_CONS_OUT SPCO1, IGS_CA_INST_ALL CI, IGS_PS_UNIT_OFR_OPT_ALL UOO, IGS_AD_LOCATION_ALL LOC, IGS_EN_STDNT_PS_ATT_ALL SPA WHERE SCAP.PERSON_ID = HP.PARTY_ID AND SCAP.ASS_ID = AI.ASS_ID AND SCAP.CAL_TYPE = CI.CAL_TYPE AND SCAP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND SCAP.UOO_ID = UOO.UOO_ID AND SCAP.UNIT_CD = UOO.UNIT_CD AND UOO.LOCATION_CD = LOC.LOCATION_CD AND UOO.UNIT_CD = UV.UNIT_CD AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER AND SCAP.SPCL_CONSIDERATION_CAT = SPCC.SPCL_CONSIDERATION_CAT (+) AND SCAP.SPCL_CONSIDERATION_OUTCOME = SPCO.SPCL_CONSIDERATION_OUTCOME (+) AND SCAP.SOUGHT_OUTCOME = SPCO1.SPCL_CONSIDERATION_OUTCOME (+) AND SCAP.PERSON_ID = SPA.PERSON_ID AND SCAP.COURSE_CD = SPA.COURSE_CD AND SPA.COURSE_CD = CRV.COURSE_CD AND SPA.VERSION_NUMBER = CRV.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, SCAP.COURSE_CD
, CRV.TITLE
, SCAP.UNIT_CD
, UV.TITLE
, SCAP.CAL_TYPE
, SCAP.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, AI.DESCRIPTION
, SCAP.CREATION_DT
, SCAP.RECEIVED_DT
, SCAP.SOUGHT_OUTCOME
, SPCO1.DESCRIPTION
, SCAP.SPCL_CONSIDERATION_CAT
, SPCC.DESCRIPTION
, SCAP.SPCL_CONSIDERATION_OUTCOME
, SPCO.DESCRIPTION
, SCAP.ESTIMATED_PROCESSING_DAYS
, SCAP.TRACKING_ID
, SCAP.COMMENTS
, SCAP.NOTIFIED_DATE
, SCAP.PERSON_ID
, SCAP.UOO_ID
, SCAP.ASS_ID
, SCAP.CREATED_BY
, SCAP.CREATION_DATE
, SCAP.LAST_UPDATED_BY
, SCAP.LAST_UPDATE_DATE
FROM HZ_PARTIES HP
, IGS_AS_SPL_CONS_APPL SCAP
, IGS_PS_VER_ALL CRV
, IGS_PS_UNIT_VER_ALL UV
, IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_AS_SPCL_CONS_CAT SPCC
, IGS_AS_SPCL_CONS_OUT SPCO
, IGS_AS_SPCL_CONS_OUT SPCO1
, IGS_CA_INST_ALL CI
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_AD_LOCATION_ALL LOC
, IGS_EN_STDNT_PS_ATT_ALL SPA
WHERE SCAP.PERSON_ID = HP.PARTY_ID
AND SCAP.ASS_ID = AI.ASS_ID
AND SCAP.CAL_TYPE = CI.CAL_TYPE
AND SCAP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SCAP.UOO_ID = UOO.UOO_ID
AND SCAP.UNIT_CD = UOO.UNIT_CD
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND SCAP.SPCL_CONSIDERATION_CAT = SPCC.SPCL_CONSIDERATION_CAT (+)
AND SCAP.SPCL_CONSIDERATION_OUTCOME = SPCO.SPCL_CONSIDERATION_OUTCOME (+)
AND SCAP.SOUGHT_OUTCOME = SPCO1.SPCL_CONSIDERATION_OUTCOME (+)
AND SCAP.PERSON_ID = SPA.PERSON_ID
AND SCAP.COURSE_CD = SPA.COURSE_CD
AND SPA.COURSE_CD = CRV.COURSE_CD
AND SPA.VERSION_NUMBER = CRV.VERSION_NUMBER WITH READ ONLY