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.IGS_AD_PS_APINTUNTHS

Source

View Text - Preformatted


SELECT tab.rowid row_id, tab.org_id org_id, tab.person_id person_id, tab.admission_appl_number admission_appl_number, tab.nominated_course_cd nominated_course_cd, tab.acai_sequence_number acai_sequence_number, tab.unit_cd unit_cd, tab.hist_start_dt hist_start_dt, tab.hist_end_dt hist_end_dt, tab.hist_who hist_who, tab.uv_version_number uv_version_number, tab.cal_type cal_type, tab.ci_sequence_number ci_sequence_number, tab.location_cd location_cd, tab.unit_class unit_class, tab.unit_mode unit_mode, tab.adm_unit_outcome_status adm_unit_outcome_status, tab.ass_tracking_id ass_tracking_id, tab.rule_waived_dt rule_waived_dt, tab.rule_waived_person_id rule_waived_person_id, tab.sup_unit_cd sup_unit_cd, tab.sup_uv_version_number sup_uv_version_number, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login, tab.adm_ps_appl_inst_unit_hist_id, tab.adm_ps_appl_inst_unit_id FROM igs_ad_ps_apintunths_all tab WHERE NVL (tab.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.PERSON_ID PERSON_ID
, TAB.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, TAB.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, TAB.ACAI_SEQUENCE_NUMBER ACAI_SEQUENCE_NUMBER
, TAB.UNIT_CD UNIT_CD
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.UV_VERSION_NUMBER UV_VERSION_NUMBER
, TAB.CAL_TYPE CAL_TYPE
, TAB.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, TAB.LOCATION_CD LOCATION_CD
, TAB.UNIT_CLASS UNIT_CLASS
, TAB.UNIT_MODE UNIT_MODE
, TAB.ADM_UNIT_OUTCOME_STATUS ADM_UNIT_OUTCOME_STATUS
, TAB.ASS_TRACKING_ID ASS_TRACKING_ID
, TAB.RULE_WAIVED_DT RULE_WAIVED_DT
, TAB.RULE_WAIVED_PERSON_ID RULE_WAIVED_PERSON_ID
, TAB.SUP_UNIT_CD SUP_UNIT_CD
, TAB.SUP_UV_VERSION_NUMBER SUP_UV_VERSION_NUMBER
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ADM_PS_APPL_INST_UNIT_HIST_ID
, TAB.ADM_PS_APPL_INST_UNIT_ID
FROM IGS_AD_PS_APINTUNTHS_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)