VIEW: APPS.IGS_PS_UNIT_VER_HIST

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.unit_cd unit_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.unit_status unit_status, tab.title title, tab.short_title short_title, tab.title_override_ind title_override_ind, tab.abbreviation abbreviation, tab.unit_level unit_level, tab.ul_description ul_description, tab.credit_point_descriptor credit_point_descriptor, tab.enrolled_credit_points enrolled_credit_points, tab.points_override_ind points_override_ind, tab.supp_exam_permitted_ind supp_exam_permitted_ind, tab.coord_person_id coord_person_id, tab.owner_org_unit_cd owner_org_unit_cd, tab.owner_ou_start_dt owner_ou_start_dt, tab.ou_description ou_description, tab.award_course_only_ind award_course_only_ind, tab.research_unit_ind research_unit_ind, tab.sub_unit_allowed_ind sub_unit_allowed_ind, tab.sup_unit_allowed_ind sup_unit_allowed_ind, tab.industrial_ind industrial_ind, tab.practical_ind practical_ind, tab.repeatable_ind repeatable_ind, tab.assessable_ind assessable_ind, tab.achievable_credit_points achievable_credit_points, tab.points_increment points_increment, tab.points_min points_min, tab.points_max points_max, tab.unit_int_course_level_cd unit_int_course_level_cd, tab.uicl_description uicl_description, tab.ss_enrol_ind ss_enrol_ind, tab.ivr_enrol_ind ivr_enrol_ind, tab.work_load_other, tab.contact_hrs_lecture, tab.contact_hrs_lab, tab.contact_hrs_other, tab.billing_hrs, tab.non_schd_required_hrs, tab.fin_aid_cp, tab.fin_aid_hrs, tab.exclude_from_max_cp_limit, tab.record_exclusion_flag, tab.ss_display_ind, tab.cal_type_enrol_load_cal, tab.sequence_num_enrol_load_cal, tab.cal_type_offer_load_cal, tab.sequence_num_offer_load_cal, tab.curriculum_id, tab.override_enrollment_max, tab.rpt_fmly_id, tab.repeat_code, tab.unit_type_id, tab.level_code, tab.advance_maximum, tab.approval_date, tab.billing_credit_points, tab.continuing_education_units, tab.enrollment_expected, tab.enrollment_maximum, tab.enrollment_minimum, tab.federal_financial_aid, tab.institutional_financial_aid, tab.lab_credit_points, tab.lecture_credit_points, tab.max_repeats_for_credit, tab.max_repeats_for_funding, tab.max_repeat_credit_points, tab.clock_hours, tab.other_credit_points, tab.same_teaching_period, tab.same_teach_period_repeats, tab.same_teach_period_repeats_cp, tab.state_financial_aid, tab.work_load_cp_lab, tab.work_load_cp_lecture, tab.subtitle_id, tab.subtitle, tab.subtitle_modifiable_flag, tab.special_permission_ind, 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.CLAIMABLE_HOURS, tab.auditable_ind auditable_ind, tab.audit_permission_ind audit_permission_ind, tab.max_auditors_allowed max_auditors_allowed, TAB.OVRD_WKLD_VAL_FLAG, TAB.WORKLOAD_VAL_CODE FROM igs_ps_unit_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.UNIT_CD UNIT_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.UNIT_STATUS UNIT_STATUS
, TAB.TITLE TITLE
, TAB.SHORT_TITLE SHORT_TITLE
, TAB.TITLE_OVERRIDE_IND TITLE_OVERRIDE_IND
, TAB.ABBREVIATION ABBREVIATION
, TAB.UNIT_LEVEL UNIT_LEVEL
, TAB.UL_DESCRIPTION UL_DESCRIPTION
, TAB.CREDIT_POINT_DESCRIPTOR CREDIT_POINT_DESCRIPTOR
, TAB.ENROLLED_CREDIT_POINTS ENROLLED_CREDIT_POINTS
, TAB.POINTS_OVERRIDE_IND POINTS_OVERRIDE_IND
, TAB.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERMITTED_IND
, TAB.COORD_PERSON_ID COORD_PERSON_ID
, TAB.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CD
, TAB.OWNER_OU_START_DT OWNER_OU_START_DT
, TAB.OU_DESCRIPTION OU_DESCRIPTION
, TAB.AWARD_COURSE_ONLY_IND AWARD_COURSE_ONLY_IND
, TAB.RESEARCH_UNIT_IND RESEARCH_UNIT_IND
, TAB.SUB_UNIT_ALLOWED_IND SUB_UNIT_ALLOWED_IND
, TAB.SUP_UNIT_ALLOWED_IND SUP_UNIT_ALLOWED_IND
, TAB.INDUSTRIAL_IND INDUSTRIAL_IND
, TAB.PRACTICAL_IND PRACTICAL_IND
, TAB.REPEATABLE_IND REPEATABLE_IND
, TAB.ASSESSABLE_IND ASSESSABLE_IND
, TAB.ACHIEVABLE_CREDIT_POINTS ACHIEVABLE_CREDIT_POINTS
, TAB.POINTS_INCREMENT POINTS_INCREMENT
, TAB.POINTS_MIN POINTS_MIN
, TAB.POINTS_MAX POINTS_MAX
, TAB.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CD
, TAB.UICL_DESCRIPTION UICL_DESCRIPTION
, TAB.SS_ENROL_IND SS_ENROL_IND
, TAB.IVR_ENROL_IND IVR_ENROL_IND
, TAB.WORK_LOAD_OTHER
, TAB.CONTACT_HRS_LECTURE
, TAB.CONTACT_HRS_LAB
, TAB.CONTACT_HRS_OTHER
, TAB.BILLING_HRS
, TAB.NON_SCHD_REQUIRED_HRS
, TAB.FIN_AID_CP
, TAB.FIN_AID_HRS
, TAB.EXCLUDE_FROM_MAX_CP_LIMIT
, TAB.RECORD_EXCLUSION_FLAG
, TAB.SS_DISPLAY_IND
, TAB.CAL_TYPE_ENROL_LOAD_CAL
, TAB.SEQUENCE_NUM_ENROL_LOAD_CAL
, TAB.CAL_TYPE_OFFER_LOAD_CAL
, TAB.SEQUENCE_NUM_OFFER_LOAD_CAL
, TAB.CURRICULUM_ID
, TAB.OVERRIDE_ENROLLMENT_MAX
, TAB.RPT_FMLY_ID
, TAB.REPEAT_CODE
, TAB.UNIT_TYPE_ID
, TAB.LEVEL_CODE
, TAB.ADVANCE_MAXIMUM
, TAB.APPROVAL_DATE
, TAB.BILLING_CREDIT_POINTS
, TAB.CONTINUING_EDUCATION_UNITS
, TAB.ENROLLMENT_EXPECTED
, TAB.ENROLLMENT_MAXIMUM
, TAB.ENROLLMENT_MINIMUM
, TAB.FEDERAL_FINANCIAL_AID
, TAB.INSTITUTIONAL_FINANCIAL_AID
, TAB.LAB_CREDIT_POINTS
, TAB.LECTURE_CREDIT_POINTS
, TAB.MAX_REPEATS_FOR_CREDIT
, TAB.MAX_REPEATS_FOR_FUNDING
, TAB.MAX_REPEAT_CREDIT_POINTS
, TAB.CLOCK_HOURS
, TAB.OTHER_CREDIT_POINTS
, TAB.SAME_TEACHING_PERIOD
, TAB.SAME_TEACH_PERIOD_REPEATS
, TAB.SAME_TEACH_PERIOD_REPEATS_CP
, TAB.STATE_FINANCIAL_AID
, TAB.WORK_LOAD_CP_LAB
, TAB.WORK_LOAD_CP_LECTURE
, TAB.SUBTITLE_ID
, TAB.SUBTITLE
, TAB.SUBTITLE_MODIFIABLE_FLAG
, TAB.SPECIAL_PERMISSION_IND
, 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.CLAIMABLE_HOURS
, TAB.AUDITABLE_IND AUDITABLE_IND
, TAB.AUDIT_PERMISSION_IND AUDIT_PERMISSION_IND
, TAB.MAX_AUDITORS_ALLOWED MAX_AUDITORS_ALLOWED
, TAB.OVRD_WKLD_VAL_FLAG
, TAB.WORKLOAD_VAL_CODE
FROM IGS_PS_UNIT_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)