VIEW: APPS.IGS_PS_USEC_CPS_V

Source

View Text - Preformatted

SELECT puv.rowid row_id, puv.UNIT_SEC_CREDIT_POINTS_ID, puv.UOO_ID, puv.MINIMUM_CREDIT_POINTS, puv.MAXIMUM_CREDIT_POINTS, puv.VARIABLE_INCREMENT, puv.LECTURE_CREDIT_POINTS, puv.LAB_CREDIT_POINTS, puv.OTHER_CREDIT_POINTS, puv.CLOCK_HOURS, puv.BILLING_CREDIT_POINTS, puv.WORK_LOAD_CP_LECTURE, puv.WORK_LOAD_CP_LAB, puv.CONTINUING_EDUCATION_UNITS, puv.ACHIEVABLE_CREDIT_POINTS, puv.ENROLLED_CREDIT_POINTS, puv.WORK_LOAD_OTHER, puv.CONTACT_HRS_LECTURE, puv.contact_hrs_lab, puv.contact_hrs_other, (puv. contact_hrs_lecture + puv.contact_hrs_lab + puv.contact_hrs_other ) DSP_CONTACT_HRS_TOTAL, puv.billing_hrs, puv.non_schd_required_hrs, puv.fin_aid_cp, puv.fin_aid_hrs, puv.exclude_from_max_cp_limit, puv.CLAIMABLE_HOURS, puv.CREATED_BY, puv.CREATION_DATE, puv.LAST_UPDATED_BY, puv.LAST_UPDATE_DATE, puv.LAST_UPDATE_LOGIN from IGS_PS_USEC_CPS puv , IGS_PS_UNIT_VER unt, IGS_PS_UNIT_OFR_OPT uoo WHERE puv.uoo_id = uoo.uoo_id and uoo.unit_cd = unt.unit_cd and uoo.version_number = unt.version_number

View Text - HTML Formatted

SELECT PUV.ROWID ROW_ID
, PUV.UNIT_SEC_CREDIT_POINTS_ID
, PUV.UOO_ID
, PUV.MINIMUM_CREDIT_POINTS
, PUV.MAXIMUM_CREDIT_POINTS
, PUV.VARIABLE_INCREMENT
, PUV.LECTURE_CREDIT_POINTS
, PUV.LAB_CREDIT_POINTS
, PUV.OTHER_CREDIT_POINTS
, PUV.CLOCK_HOURS
, PUV.BILLING_CREDIT_POINTS
, PUV.WORK_LOAD_CP_LECTURE
, PUV.WORK_LOAD_CP_LAB
, PUV.CONTINUING_EDUCATION_UNITS
, PUV.ACHIEVABLE_CREDIT_POINTS
, PUV.ENROLLED_CREDIT_POINTS
, PUV.WORK_LOAD_OTHER
, PUV.CONTACT_HRS_LECTURE
, PUV.CONTACT_HRS_LAB
, PUV.CONTACT_HRS_OTHER
, (PUV. CONTACT_HRS_LECTURE + PUV.CONTACT_HRS_LAB + PUV.CONTACT_HRS_OTHER ) DSP_CONTACT_HRS_TOTAL
, PUV.BILLING_HRS
, PUV.NON_SCHD_REQUIRED_HRS
, PUV.FIN_AID_CP
, PUV.FIN_AID_HRS
, PUV.EXCLUDE_FROM_MAX_CP_LIMIT
, PUV.CLAIMABLE_HOURS
, PUV.CREATED_BY
, PUV.CREATION_DATE
, PUV.LAST_UPDATED_BY
, PUV.LAST_UPDATE_DATE
, PUV.LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_CPS PUV
, IGS_PS_UNIT_VER UNT
, IGS_PS_UNIT_OFR_OPT UOO
WHERE PUV.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UNT.UNIT_CD
AND UOO.VERSION_NUMBER = UNT.VERSION_NUMBER