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.

[Home] [Help]

VIEW: APPS.IGS_PS_VER_HIST

Source

View Text - Preformatted


SELECT tab.rowid row_id, tab.course_cd course_cd, tab.version_number version_number, tab.hist_start_dt hist_start_dt, tab.hist_end_dt hist_end_dt, tab.hist_who hist_who, tab.start_dt start_dt, tab.review_dt review_dt, tab.expiry_dt expiry_dt, tab.end_dt end_dt, tab.course_status course_status, tab.title title, tab.short_title short_title, tab.abbreviation abbreviation, tab.supp_exam_permitted_ind supp_exam_permitted_ind, tab.generic_course_ind generic_course_ind, tab.graduate_students_ind graduate_students_ind, tab.count_intrmsn_in_time_ind count_intrmsn_in_time_ind, tab.intrmsn_allowed_ind intrmsn_allowed_ind, tab.course_type course_type, tab.ct_description ct_description, tab.responsible_org_unit_cd responsible_org_unit_cd, tab.responsible_ou_start_dt responsible_ou_start_dt, tab.ou_description ou_description, tab.govt_special_course_type govt_special_course_type, tab.gsct_description gsct_description, tab.qualification_recency qualification_recency, tab.external_adv_stnd_limit external_adv_stnd_limit, tab.internal_adv_stnd_limit internal_adv_stnd_limit, tab.contact_hours contact_hours, tab.credit_points_required credit_points_required, tab.govt_course_load govt_course_load, tab.std_annual_load std_annual_load, tab.annual_instruction_time annual_instruction_time, tab.course_total_eftsu course_total_eftsu, TAB.STD_FT_COMPLETION_TIME STD_FT_COMPLETION_TIME, TAB.STD_PT_COMPLETION_TIME STD_PT_COMPLETION_TIME, tab.max_intrmsn_duration max_intrmsn_duration, tab.num_of_units_before_intrmsn num_of_units_before_intrmsn, tab.min_sbmsn_percentage min_sbmsn_percentage, tab.min_cp_per_calendar min_cp_per_calendar, tab.approval_date approval_date, tab.external_approval_date external_approval_date, tab.federal_financial_aid federal_financial_aid, tab.institutional_financial_aid institutional_financial_aid, tab.max_cp_per_teaching_period max_cp_per_teaching_period, tab.residency_cp_required residency_cp_required , tab.state_financial_aid state_financial_aid, tab.primary_program_rank primary_program_rank, 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.org_id org_id, tab.MAX_WLST_PER_STUD FROM igs_ps_ver_hist_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.COURSE_CD COURSE_CD
, TAB.VERSION_NUMBER VERSION_NUMBER
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.START_DT START_DT
, TAB.REVIEW_DT REVIEW_DT
, TAB.EXPIRY_DT EXPIRY_DT
, TAB.END_DT END_DT
, TAB.COURSE_STATUS COURSE_STATUS
, TAB.TITLE TITLE
, TAB.SHORT_TITLE SHORT_TITLE
, TAB.ABBREVIATION ABBREVIATION
, TAB.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERMITTED_IND
, TAB.GENERIC_COURSE_IND GENERIC_COURSE_IND
, TAB.GRADUATE_STUDENTS_IND GRADUATE_STUDENTS_IND
, TAB.COUNT_INTRMSN_IN_TIME_IND COUNT_INTRMSN_IN_TIME_IND
, TAB.INTRMSN_ALLOWED_IND INTRMSN_ALLOWED_IND
, TAB.COURSE_TYPE COURSE_TYPE
, TAB.CT_DESCRIPTION CT_DESCRIPTION
, TAB.RESPONSIBLE_ORG_UNIT_CD RESPONSIBLE_ORG_UNIT_CD
, TAB.RESPONSIBLE_OU_START_DT RESPONSIBLE_OU_START_DT
, TAB.OU_DESCRIPTION OU_DESCRIPTION
, TAB.GOVT_SPECIAL_COURSE_TYPE GOVT_SPECIAL_COURSE_TYPE
, TAB.GSCT_DESCRIPTION GSCT_DESCRIPTION
, TAB.QUALIFICATION_RECENCY QUALIFICATION_RECENCY
, TAB.EXTERNAL_ADV_STND_LIMIT EXTERNAL_ADV_STND_LIMIT
, TAB.INTERNAL_ADV_STND_LIMIT INTERNAL_ADV_STND_LIMIT
, TAB.CONTACT_HOURS CONTACT_HOURS
, TAB.CREDIT_POINTS_REQUIRED CREDIT_POINTS_REQUIRED
, TAB.GOVT_COURSE_LOAD GOVT_COURSE_LOAD
, TAB.STD_ANNUAL_LOAD STD_ANNUAL_LOAD
, TAB.ANNUAL_INSTRUCTION_TIME ANNUAL_INSTRUCTION_TIME
, TAB.COURSE_TOTAL_EFTSU COURSE_TOTAL_EFTSU
, TAB.STD_FT_COMPLETION_TIME STD_FT_COMPLETION_TIME
, TAB.STD_PT_COMPLETION_TIME STD_PT_COMPLETION_TIME
, TAB.MAX_INTRMSN_DURATION MAX_INTRMSN_DURATION
, TAB.NUM_OF_UNITS_BEFORE_INTRMSN NUM_OF_UNITS_BEFORE_INTRMSN
, TAB.MIN_SBMSN_PERCENTAGE MIN_SBMSN_PERCENTAGE
, TAB.MIN_CP_PER_CALENDAR MIN_CP_PER_CALENDAR
, TAB.APPROVAL_DATE APPROVAL_DATE
, TAB.EXTERNAL_APPROVAL_DATE EXTERNAL_APPROVAL_DATE
, TAB.FEDERAL_FINANCIAL_AID FEDERAL_FINANCIAL_AID
, TAB.INSTITUTIONAL_FINANCIAL_AID INSTITUTIONAL_FINANCIAL_AID
, TAB.MAX_CP_PER_TEACHING_PERIOD MAX_CP_PER_TEACHING_PERIOD
, TAB.RESIDENCY_CP_REQUIRED RESIDENCY_CP_REQUIRED
, TAB.STATE_FINANCIAL_AID STATE_FINANCIAL_AID
, TAB.PRIMARY_PROGRAM_RANK PRIMARY_PROGRAM_RANK
, 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.ORG_ID ORG_ID
, TAB.MAX_WLST_PER_STUD
FROM IGS_PS_VER_HIST_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)