VIEW: APPS.IGS_PS_UNIT_VER_V

Source

View Text - Preformatted

SELECT PUV.ROWID ROW_ID , PUV.UNIT_CD UNIT_CD , PUV.VERSION_NUMBER VERSION_NUMBER, PUV.START_DT START_DT, PUV.REVIEW_DT REVIEW_DT, PUV.EXPIRY_DT EXPIRY_DT, PUV.END_DT END_DT, PUV.UNIT_STATUS UNIT_STATUS , PUV.TITLE TITLE , PUV.SHORT_TITLE SHORT_TITLE , PUV.TITLE_OVERRIDE_IND TITLE_OVERRIDE_IND , PUV.ABBREVIATION ABBREVIATION , PUV.UNIT_LEVEL UNIT_LEVEL , PUV.CREDIT_POINT_DESCRIPTOR CREDIT_POINT_DESCRIPTOR, LK.MEANING CPD_DESCRIPTION, PUV.ENROLLED_CREDIT_POINTS ENROLLED_CREDIT_POINTS, PUV.POINTS_OVERRIDE_IND POINTS_OVERRIDE_IND, PUV.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERMITTED_IND, PUV.COORD_PERSON_ID COORD_PERSON_ID, PE.PARTY_NUMBER PERSON_NUMBER, PUV.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CD, PUV.OWNER_OU_START_DT OWNER_OU_START_DT, PUV.AWARD_COURSE_ONLY_IND AWARD_COURSE_ONLY_IND, PUV.RESEARCH_UNIT_IND RESEARCH_UNIT_IND, PUV.SUB_UNIT_ALLOWED_IND SUB_UNIT_ALLOWED_IND, PUV.SUP_UNIT_ALLOWED_IND SUP_UNIT_ALLOWED_IND, PUV.INDUSTRIAL_IND INDUSTRIAL_IND, PUV.PRACTICAL_IND PRACTICAL_IND, PUV.REPEATABLE_IND REPEATABLE_IND, PUV.ASSESSABLE_IND ASSESSABLE_IND, PUV.ACHIEVABLE_CREDIT_POINTS ACHIEVABLE_CREDIT_POINTS, PUV.POINTS_INCREMENT POINTS_INCREMENT, PUV.POINTS_MIN POINTS_MIN, PUV.POINTS_MAX POINTS_MAX, PUV.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CD, UVS.SUBTITLE SUBTITLE , PUV.SUBTITLE_ID subtitle_id, PUV.SUBTITLE_MODIFIABLE_FLAG SUBTITLE_MODIFIABLE_FLAG , PUV.APPROVAL_DATE APPROVAL_DATE, PUV.LECTURE_CREDIT_POINTS LECTURE_CREDIT_POINTS , PUV.LAB_CREDIT_POINTS LAB_CREDIT_POINTS, PUV.OTHER_CREDIT_POINTS OTHER_CREDIT_POINTS, PUV.CLOCK_HOURS CLOCK_HOURS, PUV.BILLING_CREDIT_POINTS BILLING_CREDIT_POINTS , PUV.WORK_LOAD_CP_LECTURE WORK_LOAD_CP_LECTURE, PUV.WORK_LOAD_CP_LAB WORK_LOAD_CP_LAB, PUV.CONTINUING_EDUCATION_UNITS CONTINUING_EDUCATION_UNITS, PUV.ENROLLMENT_EXPECTED ENROLLMENT_EXPECTED, PUV.ENROLLMENT_MINIMUM ENROLLMENT_MINIMUM, PUV.ENROLLMENT_MAXIMUM ENROLLMENT_MAXIMUM, PUV.ADVANCE_MAXIMUM ADVANCE_MAXIMUM, PUV.STATE_FINANCIAL_AID STATE_FINANCIAL_AID, PUV.FEDERAL_FINANCIAL_AID FEDERAL_FINANCIAL_AID, PUV.INSTITUTIONAL_FINANCIAL_AID INSTITUTIONAL_FINANCIAL_AID, PUV.SAME_TEACHING_PERIOD SAME_TEACHING_PERIOD, PUV.MAX_REPEATS_FOR_CREDIT MAX_REPEATS_FOR_CREDIT, PUV.MAX_REPEATS_FOR_FUNDING MAX_REPEATS_FOR_FUNDING, PUV.MAX_REPEAT_CREDIT_POINTS MAX_REPEAT_CREDIT_POINTS, PUV.SAME_TEACH_PERIOD_REPEATS_CP SAME_TEACH_PERIOD_REPEATS_CP, PUV.SAME_TEACH_PERIOD_REPEATS SAME_TEACH_PERIOD_REPEATS, PUV.WORK_LOAD_OTHER WORK_LOAD_OTHER , PUV.CONTACT_HRS_LECTURE CONTACT_HRS_LECTURE, PUV.CONTACT_HRS_LAB CONTACT_HRS_LAB, PUV.CONTACT_HRS_OTHER CONTACT_HRS_OTHER, ( PUV.CONTACT_HRS_LECTURE+PUV.CONTACT_HRS_LAB+PUV.CONTACT_HRS_OTHER ) dsp_contact_hrs_total, PUV.BILLING_HRS BILLING_HRS, PUV.NON_SCHD_REQUIRED_HRS NON_SCHD_REQUIRED_HRS, PUV.FIN_AID_CP FIN_AID_CP , PUV.FIN_AID_HRS FIN_AID_HRS, PUV.EXCLUDE_FROM_MAX_CP_LIMIT EXCLUDE_FROM_MAX_CP_LIMIT, PUV.RECORD_EXCLUSION_FLAG RECORD_EXCLUSION_FLAG, PUV.SS_DISPLAY_IND SS_DISPLAY_IND, PUV.CAL_TYPE_ENROL_LOAD_CAL CAL_TYPE_ENROL_LOAD_CAL , PUV.SEQUENCE_NUM_ENROL_LOAD_CAL SEQUENCE_NUM_ENROL_LOAD_CAL , PUV.CAL_TYPE_OFFER_LOAD_CAL CAL_TYPE_OFFER_LOAD_CAL, PUV.SEQUENCE_NUM_OFFER_LOAD_CAL SEQUENCE_NUM_OFFER_LOAD_CAL, SUBSTR (IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(PUV.CAL_TYPE_ENROL_LOAD_CAL, PUV.SEQUENCE_NUM_ENROL_LOAD_CAL),1,10) || '/' || PUV.CAL_TYPE_ENROL_LOAD_CAL dsp_lasT_calendar_enrolled, SUBSTR (IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(PUV.CAL_TYPE_OFFER_LOAD_CAL, PUV.SEQUENCE_NUM_OFFER_LOAD_CAL),1,10) || '/' || PUV.CAL_TYPE_OFFER_LOAD_CAL DSP_LAST_CALENDAR_OFFERED , PUV.CURRICULUM_ID CURRICULUM_ID , PUV.OVERRIDE_ENROLLMENT_MAX OVERRIDE_ENROLLMENT_MAX , PUV.RPT_FMLY_ID RPT_FMLY_ID , PUV.UNIT_TYPE_ID UNIT_TYPE_ID , UTYL.LEVEL_CODE LEVEL_CODE , PUV.SPECIAL_PERMISSION_IND SPECIAL_PERMISSION_IND , PUV.SS_ENROL_IND SS_ENROL_IND , PUV.IVR_ENROL_IND IVR_ENROL_IND, PUV.REV_ACCOUNT_CD, PUV.CLAIMABLE_HOURS, puv.anon_unit_grading_ind, puv.anon_assess_grading_ind, PUV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , PUV.ATTRIBUTE1 ATTRIBUTE1, PUV.ATTRIBUTE2 ATTRIBUTE2, PUV.ATTRIBUTE3 ATTRIBUTE3, PUV.ATTRIBUTE4 ATTRIBUTE4, PUV.ATTRIBUTE5 ATTRIBUTE5 , PUV.ATTRIBUTE6 ATTRIBUTE6, PUV.ATTRIBUTE7 ATTRIBUTE7 , PUV.ATTRIBUTE8 ATTRIBUTE8 , PUV.ATTRIBUTE9 ATTRIBUTE9 , PUV.ATTRIBUTE10 ATTRIBUTE10, PUV.ATTRIBUTE11 ATTRIBUTE11 , PUV.ATTRIBUTE12 ATTRIBUTE12 , PUV.ATTRIBUTE13 ATTRIBUTE13 , PUV.ATTRIBUTE14 ATTRIBUTE14 , PUV.ATTRIBUTE15 ATTRIBUTE15 , PUV.ATTRIBUTE16 ATTRIBUTE16 , PUV.ATTRIBUTE17 ATTRIBUTE17 , PUV.ATTRIBUTE18 ATTRIBUTE18, PUV.ATTRIBUTE19 ATTRIBUTE19 , PUV.ATTRIBUTE20 ATTRIBUTE20, PUV.CREATED_BY CREATED_BY, PUV.CREATION_DATE CREATION_DATE , PUV.LAST_UPDATED_BY LAST_UPDATED_BY , PUV.LAST_UPDATE_DATE LAST_UPDATE_DATE , PUV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PUV.AUDITABLE_IND, PUV.AUDIT_PERMISSION_IND, PUV.MAX_AUDITORS_ALLOWED, PUV.OVRD_WKLD_VAL_FLAG, PUV.WORKLOAD_VAL_CODE FROM IGS_PS_UNIT_VER PUV, HZ_PARTIES PE, igs_lookup_values LK, IGS_PS_UNIT_SUBTITLE UVS, IGS_PS_UNIT_TYPE_LVL UTYL WHERE PUV.COORD_PERSON_ID = PE.PARTY_ID AND PUV.CREDIT_POINT_DESCRIPTOR = LK.LOOKUP_CODE AND LK.LOOKUP_TYPE = 'CREDIT_POINT_DSCR' AND PUV.SUBTITLE_ID = UVS.SUBTITLE_ID(+) AND PUV.UNIT_TYPE_ID = UTYL.UNIT_TYPE_ID

View Text - HTML Formatted

SELECT PUV.ROWID ROW_ID
, PUV.UNIT_CD UNIT_CD
, PUV.VERSION_NUMBER VERSION_NUMBER
, PUV.START_DT START_DT
, PUV.REVIEW_DT REVIEW_DT
, PUV.EXPIRY_DT EXPIRY_DT
, PUV.END_DT END_DT
, PUV.UNIT_STATUS UNIT_STATUS
, PUV.TITLE TITLE
, PUV.SHORT_TITLE SHORT_TITLE
, PUV.TITLE_OVERRIDE_IND TITLE_OVERRIDE_IND
, PUV.ABBREVIATION ABBREVIATION
, PUV.UNIT_LEVEL UNIT_LEVEL
, PUV.CREDIT_POINT_DESCRIPTOR CREDIT_POINT_DESCRIPTOR
, LK.MEANING CPD_DESCRIPTION
, PUV.ENROLLED_CREDIT_POINTS ENROLLED_CREDIT_POINTS
, PUV.POINTS_OVERRIDE_IND POINTS_OVERRIDE_IND
, PUV.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERMITTED_IND
, PUV.COORD_PERSON_ID COORD_PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, PUV.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CD
, PUV.OWNER_OU_START_DT OWNER_OU_START_DT
, PUV.AWARD_COURSE_ONLY_IND AWARD_COURSE_ONLY_IND
, PUV.RESEARCH_UNIT_IND RESEARCH_UNIT_IND
, PUV.SUB_UNIT_ALLOWED_IND SUB_UNIT_ALLOWED_IND
, PUV.SUP_UNIT_ALLOWED_IND SUP_UNIT_ALLOWED_IND
, PUV.INDUSTRIAL_IND INDUSTRIAL_IND
, PUV.PRACTICAL_IND PRACTICAL_IND
, PUV.REPEATABLE_IND REPEATABLE_IND
, PUV.ASSESSABLE_IND ASSESSABLE_IND
, PUV.ACHIEVABLE_CREDIT_POINTS ACHIEVABLE_CREDIT_POINTS
, PUV.POINTS_INCREMENT POINTS_INCREMENT
, PUV.POINTS_MIN POINTS_MIN
, PUV.POINTS_MAX POINTS_MAX
, PUV.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CD
, UVS.SUBTITLE SUBTITLE
, PUV.SUBTITLE_ID SUBTITLE_ID
, PUV.SUBTITLE_MODIFIABLE_FLAG SUBTITLE_MODIFIABLE_FLAG
, PUV.APPROVAL_DATE APPROVAL_DATE
, PUV.LECTURE_CREDIT_POINTS LECTURE_CREDIT_POINTS
, PUV.LAB_CREDIT_POINTS LAB_CREDIT_POINTS
, PUV.OTHER_CREDIT_POINTS OTHER_CREDIT_POINTS
, PUV.CLOCK_HOURS CLOCK_HOURS
, PUV.BILLING_CREDIT_POINTS BILLING_CREDIT_POINTS
, PUV.WORK_LOAD_CP_LECTURE WORK_LOAD_CP_LECTURE
, PUV.WORK_LOAD_CP_LAB WORK_LOAD_CP_LAB
, PUV.CONTINUING_EDUCATION_UNITS CONTINUING_EDUCATION_UNITS
, PUV.ENROLLMENT_EXPECTED ENROLLMENT_EXPECTED
, PUV.ENROLLMENT_MINIMUM ENROLLMENT_MINIMUM
, PUV.ENROLLMENT_MAXIMUM ENROLLMENT_MAXIMUM
, PUV.ADVANCE_MAXIMUM ADVANCE_MAXIMUM
, PUV.STATE_FINANCIAL_AID STATE_FINANCIAL_AID
, PUV.FEDERAL_FINANCIAL_AID FEDERAL_FINANCIAL_AID
, PUV.INSTITUTIONAL_FINANCIAL_AID INSTITUTIONAL_FINANCIAL_AID
, PUV.SAME_TEACHING_PERIOD SAME_TEACHING_PERIOD
, PUV.MAX_REPEATS_FOR_CREDIT MAX_REPEATS_FOR_CREDIT
, PUV.MAX_REPEATS_FOR_FUNDING MAX_REPEATS_FOR_FUNDING
, PUV.MAX_REPEAT_CREDIT_POINTS MAX_REPEAT_CREDIT_POINTS
, PUV.SAME_TEACH_PERIOD_REPEATS_CP SAME_TEACH_PERIOD_REPEATS_CP
, PUV.SAME_TEACH_PERIOD_REPEATS SAME_TEACH_PERIOD_REPEATS
, PUV.WORK_LOAD_OTHER WORK_LOAD_OTHER
, PUV.CONTACT_HRS_LECTURE CONTACT_HRS_LECTURE
, PUV.CONTACT_HRS_LAB CONTACT_HRS_LAB
, PUV.CONTACT_HRS_OTHER CONTACT_HRS_OTHER
, ( PUV.CONTACT_HRS_LECTURE+PUV.CONTACT_HRS_LAB+PUV.CONTACT_HRS_OTHER ) DSP_CONTACT_HRS_TOTAL
, PUV.BILLING_HRS BILLING_HRS
, PUV.NON_SCHD_REQUIRED_HRS NON_SCHD_REQUIRED_HRS
, PUV.FIN_AID_CP FIN_AID_CP
, PUV.FIN_AID_HRS FIN_AID_HRS
, PUV.EXCLUDE_FROM_MAX_CP_LIMIT EXCLUDE_FROM_MAX_CP_LIMIT
, PUV.RECORD_EXCLUSION_FLAG RECORD_EXCLUSION_FLAG
, PUV.SS_DISPLAY_IND SS_DISPLAY_IND
, PUV.CAL_TYPE_ENROL_LOAD_CAL CAL_TYPE_ENROL_LOAD_CAL
, PUV.SEQUENCE_NUM_ENROL_LOAD_CAL SEQUENCE_NUM_ENROL_LOAD_CAL
, PUV.CAL_TYPE_OFFER_LOAD_CAL CAL_TYPE_OFFER_LOAD_CAL
, PUV.SEQUENCE_NUM_OFFER_LOAD_CAL SEQUENCE_NUM_OFFER_LOAD_CAL
, SUBSTR (IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(PUV.CAL_TYPE_ENROL_LOAD_CAL
, PUV.SEQUENCE_NUM_ENROL_LOAD_CAL)
, 1
, 10) || '/' || PUV.CAL_TYPE_ENROL_LOAD_CAL DSP_LAST_CALENDAR_ENROLLED
, SUBSTR (IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(PUV.CAL_TYPE_OFFER_LOAD_CAL
, PUV.SEQUENCE_NUM_OFFER_LOAD_CAL)
, 1
, 10) || '/' || PUV.CAL_TYPE_OFFER_LOAD_CAL DSP_LAST_CALENDAR_OFFERED
, PUV.CURRICULUM_ID CURRICULUM_ID
, PUV.OVERRIDE_ENROLLMENT_MAX OVERRIDE_ENROLLMENT_MAX
, PUV.RPT_FMLY_ID RPT_FMLY_ID
, PUV.UNIT_TYPE_ID UNIT_TYPE_ID
, UTYL.LEVEL_CODE LEVEL_CODE
, PUV.SPECIAL_PERMISSION_IND SPECIAL_PERMISSION_IND
, PUV.SS_ENROL_IND SS_ENROL_IND
, PUV.IVR_ENROL_IND IVR_ENROL_IND
, PUV.REV_ACCOUNT_CD
, PUV.CLAIMABLE_HOURS
, PUV.ANON_UNIT_GRADING_IND
, PUV.ANON_ASSESS_GRADING_IND
, PUV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PUV.ATTRIBUTE1 ATTRIBUTE1
, PUV.ATTRIBUTE2 ATTRIBUTE2
, PUV.ATTRIBUTE3 ATTRIBUTE3
, PUV.ATTRIBUTE4 ATTRIBUTE4
, PUV.ATTRIBUTE5 ATTRIBUTE5
, PUV.ATTRIBUTE6 ATTRIBUTE6
, PUV.ATTRIBUTE7 ATTRIBUTE7
, PUV.ATTRIBUTE8 ATTRIBUTE8
, PUV.ATTRIBUTE9 ATTRIBUTE9
, PUV.ATTRIBUTE10 ATTRIBUTE10
, PUV.ATTRIBUTE11 ATTRIBUTE11
, PUV.ATTRIBUTE12 ATTRIBUTE12
, PUV.ATTRIBUTE13 ATTRIBUTE13
, PUV.ATTRIBUTE14 ATTRIBUTE14
, PUV.ATTRIBUTE15 ATTRIBUTE15
, PUV.ATTRIBUTE16 ATTRIBUTE16
, PUV.ATTRIBUTE17 ATTRIBUTE17
, PUV.ATTRIBUTE18 ATTRIBUTE18
, PUV.ATTRIBUTE19 ATTRIBUTE19
, PUV.ATTRIBUTE20 ATTRIBUTE20
, PUV.CREATED_BY CREATED_BY
, PUV.CREATION_DATE CREATION_DATE
, PUV.LAST_UPDATED_BY LAST_UPDATED_BY
, PUV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PUV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PUV.AUDITABLE_IND
, PUV.AUDIT_PERMISSION_IND
, PUV.MAX_AUDITORS_ALLOWED
, PUV.OVRD_WKLD_VAL_FLAG
, PUV.WORKLOAD_VAL_CODE
FROM IGS_PS_UNIT_VER PUV
, HZ_PARTIES PE
, IGS_LOOKUP_VALUES LK
, IGS_PS_UNIT_SUBTITLE UVS
, IGS_PS_UNIT_TYPE_LVL UTYL
WHERE PUV.COORD_PERSON_ID = PE.PARTY_ID
AND PUV.CREDIT_POINT_DESCRIPTOR = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'CREDIT_POINT_DSCR'
AND PUV.SUBTITLE_ID = UVS.SUBTITLE_ID(+)
AND PUV.UNIT_TYPE_ID = UTYL.UNIT_TYPE_ID