VIEW: APPS.IGS_PS_VER

Source

View Text - Preformatted

SELECT tab.ROWID ROW_ID, tab.course_cd, tab.version_number, tab.start_dt, tab.review_dt, tab.expiry_dt, tab.end_dt, tab.course_status, tab.title title, tab.short_title, tab.abbreviation, tab.supp_exam_permitted_ind, tab.generic_course_ind, tab.graduate_students_ind, tab.count_intrmsn_in_time_ind, tab.intrmsn_allowed_ind, tab.course_type course_type, tab.responsible_org_unit_cd, tab.responsible_ou_start_dt, tab.govt_special_course_type, tab.qualification_recency, tab.external_adv_stnd_limit, tab.internal_adv_stnd_limit, tab.contact_hours, tab.credit_points_required, tab.govt_course_load, tab.std_annual_load, tab.annual_instruction_time, tab.course_total_eftsu, TAB.STD_FT_COMPLETION_TIME, TAB.STD_PT_COMPLETION_TIME, tab.max_intrmsn_duration, tab.num_of_units_before_intrmsn, tab.min_sbmsn_percentage, tab.created_by, tab.creation_date, tab.last_updated_by, tab.last_update_date, tab.last_update_login, tab.max_cp_per_teaching_period, tab.approval_date, tab.external_approval_date, tab.residency_cp_required, tab.state_financial_aid, tab.federal_financial_aid, tab.institutional_financial_aid, tab.MIN_CP_PER_CALENDAR, tab.rev_account_Cd, tab.primary_program_rank, tab.attribute_category, tab.attribute1, tab.attribute2, tab.attribute3, tab.attribute4, tab.attribute5, tab.attribute6, tab.attribute7, tab.attribute8, tab.attribute9, tab.attribute10, tab.attribute11, tab.attribute12, tab.attribute13, tab.attribute14, tab.attribute15, tab.attribute16, tab.attribute17, tab.attribute18, tab.attribute19, tab.attribute20, tab.org_id, tab.MAX_WLST_PER_STUD FROM igs_ps_ver_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
, TAB.VERSION_NUMBER
, TAB.START_DT
, TAB.REVIEW_DT
, TAB.EXPIRY_DT
, TAB.END_DT
, TAB.COURSE_STATUS
, TAB.TITLE TITLE
, TAB.SHORT_TITLE
, TAB.ABBREVIATION
, TAB.SUPP_EXAM_PERMITTED_IND
, TAB.GENERIC_COURSE_IND
, TAB.GRADUATE_STUDENTS_IND
, TAB.COUNT_INTRMSN_IN_TIME_IND
, TAB.INTRMSN_ALLOWED_IND
, TAB.COURSE_TYPE COURSE_TYPE
, TAB.RESPONSIBLE_ORG_UNIT_CD
, TAB.RESPONSIBLE_OU_START_DT
, TAB.GOVT_SPECIAL_COURSE_TYPE
, TAB.QUALIFICATION_RECENCY
, TAB.EXTERNAL_ADV_STND_LIMIT
, TAB.INTERNAL_ADV_STND_LIMIT
, TAB.CONTACT_HOURS
, TAB.CREDIT_POINTS_REQUIRED
, TAB.GOVT_COURSE_LOAD
, TAB.STD_ANNUAL_LOAD
, TAB.ANNUAL_INSTRUCTION_TIME
, TAB.COURSE_TOTAL_EFTSU
, TAB.STD_FT_COMPLETION_TIME
, TAB.STD_PT_COMPLETION_TIME
, TAB.MAX_INTRMSN_DURATION
, TAB.NUM_OF_UNITS_BEFORE_INTRMSN
, TAB.MIN_SBMSN_PERCENTAGE
, TAB.CREATED_BY
, TAB.CREATION_DATE
, TAB.LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN
, TAB.MAX_CP_PER_TEACHING_PERIOD
, TAB.APPROVAL_DATE
, TAB.EXTERNAL_APPROVAL_DATE
, TAB.RESIDENCY_CP_REQUIRED
, TAB.STATE_FINANCIAL_AID
, TAB.FEDERAL_FINANCIAL_AID
, TAB.INSTITUTIONAL_FINANCIAL_AID
, TAB.MIN_CP_PER_CALENDAR
, TAB.REV_ACCOUNT_CD
, TAB.PRIMARY_PROGRAM_RANK
, TAB.ATTRIBUTE_CATEGORY
, TAB.ATTRIBUTE1
, TAB.ATTRIBUTE2
, TAB.ATTRIBUTE3
, TAB.ATTRIBUTE4
, TAB.ATTRIBUTE5
, TAB.ATTRIBUTE6
, TAB.ATTRIBUTE7
, TAB.ATTRIBUTE8
, TAB.ATTRIBUTE9
, TAB.ATTRIBUTE10
, TAB.ATTRIBUTE11
, TAB.ATTRIBUTE12
, TAB.ATTRIBUTE13
, TAB.ATTRIBUTE14
, TAB.ATTRIBUTE15
, TAB.ATTRIBUTE16
, TAB.ATTRIBUTE17
, TAB.ATTRIBUTE18
, TAB.ATTRIBUTE19
, TAB.ATTRIBUTE20
, TAB.ORG_ID
, TAB.MAX_WLST_PER_STUD
FROM IGS_PS_VER_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)