View: IGSFV_UC_TRANSACTIONS

View Text

SELECT TR.UC_TRAN_ID TRANSACTION_SEQUENCE_ID
, TR.TRANSACTION_ID TRANSACTION_ID
, TR.UPDATER UPDATER
, TR.ERROR_CODE ERROR_CODE
, TR.TRANSACTION_TYPE TRANSACTION_TYPE
, AP.PERSONAL_ID PERSONAL_ID
, TR.APP_NO APPLICANT_UCAS_NUMBER
, TR.CHOICE_NO APPLICANT_CHOICE_NUMBER
, TR.UCAS_CYCLE UCAS_CYCLE
, TR.DECISION DECISION
, TR.PROGRAM_CODE UCAS_PROGRAM_CODE
, TR.CAMPUS UCAS_CAMPUS
, TR.ENTRY_MONTH ENTRY_MONTH
, TR.ENTRY_YEAR ENTRY_YEAR
, TR.ENTRY_POINT ENTRY_POINT
, TR.SOC SUMMARY_OF_CONDITIONS
, TR.COMMENTS_IN_OFFER COMMENTS_IN_OFFER
, TR.RETURN1 RETURN1
, TR.RETURN2 RETURN2
, TR.HOLD_FLAG HOLD_FLAG
, TR.SENT_TO_UCAS SENT_TO_UCAS_FLAG
, TR.TEST_COND_CAT TEST_CONDITION_CATEGORY
, TR.TEST_COND_NAME TEST_CONDITION_NAME
, TR.INST_REFERENCE INSTITUTION_REFERENCE
, TR.AUTO_GENERATED_FLAG AUTO_GENERATED_FLAG
, TR.SYSTEM_CODE UCAS_SYSTEM_CODE
, TR.MODULAR MODULAR
, TR.PART_TIME PART_TIME
, DE.NAME UCAS_SYSTEM_NAME
, DE.DESCRIPTION UCAS_SYSTEM_DESCRIPTION
, TY.DESCRIPTION TRANSACTION_TYPE_DESCRIPTION
, HZ.PARTY_NUMBER OSS_PERSON_NUMBER
, HZ.PARTY_NAME OSS_PERSON_NAME
, DECODE (TR.ERROR_CODE
, NULL
, TO_CHAR(NULL)
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE = TR.ERROR_CODE
AND CODE_TYPE ='EC')) ERROR_CODE_DESCRIPTION
, CR.SHORT_TITLE UCAS_COURSE_SHORT_TITLE
, TR.CREATED_BY CREATED_BY
, TR.CREATION_DATE CREATION_DATE
, TR.LAST_UPDATED_BY LAST_UPDATED_BY
, TR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_TRANSACTIONS TR
, IGS_UC_DEFAULTS DE
, IGS_UC_CRSE_DETS CR
, IGS_UC_TRANS_TYPES TY
, IGS_UC_APPLICANTS AP
, HZ_PARTIES HZ
WHERE TR.SYSTEM_CODE = DE.SYSTEM_CODE
AND TR.PROGRAM_CODE = CR.UCAS_PROGRAM_CODE (+)
AND TR.CAMPUS = CR.UCAS_CAMPUS (+)
AND (TR.PROGRAM_CODE IS NULL OR CR.INSTITUTE IN (SELECT CURRENT_INST_CODE
FROM IGS_UC_DEFAULTS
WHERE SYSTEM_CODE = TR.SYSTEM_CODE))
AND TR.SYSTEM_CODE = CR.SYSTEM_CODE (+)
AND TR.TRANSACTION_TYPE = TY.TRANSACTION_TYPE
AND TR.SYSTEM_CODE = TY.SYSTEM_CODE
AND TR.APP_NO = AP.APP_NO
AND AP.OSS_PERSON_ID = HZ.PARTY_ID (+) WITH READ ONLY

Columns