VIEW: APPS.IGSFV_UC_TRANSACTIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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