eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGSBV_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, 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, 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 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
, 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
, 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 WITH READ ONLY