[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_PS_VER

Object Details

Object Name:	IGS_PS_VER
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PS_VER
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

This view would be used in form

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      COURSE_CD
,      VERSION_NUMBER
,      START_DT
,      REVIEW_DT
,      EXPIRY_DT
,      END_DT
,      COURSE_STATUS
,      TITLE
,      SHORT_TITLE
,      ABBREVIATION
,      SUPP_EXAM_PERMITTED_IND
,      GENERIC_COURSE_IND
,      GRADUATE_STUDENTS_IND
,      COUNT_INTRMSN_IN_TIME_IND
,      INTRMSN_ALLOWED_IND
,      COURSE_TYPE
,      RESPONSIBLE_ORG_UNIT_CD
,      RESPONSIBLE_OU_START_DT
,      GOVT_SPECIAL_COURSE_TYPE
,      QUALIFICATION_RECENCY
,      EXTERNAL_ADV_STND_LIMIT
,      INTERNAL_ADV_STND_LIMIT
,      CONTACT_HOURS
,      CREDIT_POINTS_REQUIRED
,      GOVT_COURSE_LOAD
,      STD_ANNUAL_LOAD
,      ANNUAL_INSTRUCTION_TIME
,      COURSE_TOTAL_EFTSU
,      STD_FT_COMPLETION_TIME
,      STD_PT_COMPLETION_TIME
,      MAX_INTRMSN_DURATION
,      NUM_OF_UNITS_BEFORE_INTRMSN
,      MIN_SBMSN_PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MAX_CP_PER_TEACHING_PERIOD
,      APPROVAL_DATE
,      EXTERNAL_APPROVAL_DATE
,      RESIDENCY_CP_REQUIRED
,      STATE_FINANCIAL_AID
,      FEDERAL_FINANCIAL_AID
,      INSTITUTIONAL_FINANCIAL_AID
,      MIN_CP_PER_CALENDAR
,      REV_ACCOUNT_CD
,      PRIMARY_PROGRAM_RANK
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ORG_ID
,      MAX_WLST_PER_STUD
FROM APPS.IGS_PS_VER;

Dependencies

[top of page]

APPS

IGS_PS_VER_ALL

APPS

IGF_AP_GEN_001 - show dependent code

IGF_AP_IA_LOOKUP_V

IGF_AP_OSS_INTEGR - show dependent code

IGF_AP_OSS_INTR_DTLS - show dependent code

IGF_AW_ANTICIPATED_DATA - show dependent code

IGF_AW_COA_GEN - show dependent code

IGF_AW_COA_GEN - show dependent code

IGF_AW_FISAP_PKG - show dependent code

IGF_AW_FUND_PRG_V

IGF_AW_PACKAGING - show dependent code

IGF_GR_PELL_CALC - show dependent code

IGF_GR_PELL_SETUP_V

IGF_SL_DL_VALIDATION - show dependent code

IGF_SP_GEN_001 - show dependent code

IGF_SP_GEN_001 - show dependent code

IGF_SP_PRG_V

IGF_SP_STD_PRG_V

IGS_AD_ACAD_HISTORY_V

IGS_AD_DEPLVL_PRG_V

IGS_AD_GEN_002 - show dependent code

IGS_AD_GEN_004 - show dependent code

IGS_AD_GEN_010 - show dependent code

IGS_AD_GEN_011 - show dependent code

IGS_AD_GEN_013 - show dependent code

IGS_AD_GEN_014 - show dependent code

IGS_AD_KEY_ACAD_IND_V

IGS_AD_MKADM_DES_INT_V

IGS_AD_PANEL_DTLS_V

IGS_AD_PRC_TAC_OFFER - show dependent code

IGS_AD_PS_APL_INST_CNTX_V

IGS_AD_PS_APPL_APLCNTX_V

IGS_AD_PS_APPL_INST_APLINST_V

IGS_AD_PS_APPL_INST_APLSUMR_V

IGS_AD_PS_APPL_INST_CONTEXT_V

IGS_AD_PS_APPL_INST_PKG - show dependent code

IGS_AD_PS_APPL_PKG - show dependent code

IGS_AD_RVGR_PROG_CD_V

IGS_AD_VAL_ACA - show dependent code

IGS_AD_VAL_ACAI - show dependent code

IGS_AD_VAL_ACAI_STATUS - show dependent code

IGS_AD_VAL_CEPI - show dependent code

IGS_AD_VAL_COOAC - show dependent code

IGS_AD_VAL_CRS_ADMPERD - show dependent code

IGS_AS_ADI_UPLD_PR_PKG - show dependent code

IGS_AS_CALC_AWARD_MARK - show dependent code

IGS_AS_GEN_001 - show dependent code

IGS_AS_GEN_003 - show dependent code

IGS_AS_GEN_004 - show dependent code

IGS_AS_GEN_005 - show dependent code

IGS_AS_GEN_006 - show dependent code

IGS_AS_GPC_PROGRAMS_V

IGS_AS_PRC_TRANSCRPT - show dependent code

IGS_AS_SS_DOC_REQUEST - show dependent code

IGS_AS_SS_DOC_REQUEST - show dependent code

IGS_AS_SU_STMPTOUT_MID

IGS_AS_SU_STMPTOUT_V

IGS_AS_UAI_ETISTD_EXAM_V

IGS_AS_VAL_UAI - show dependent code

IGS_AV_ADV_STANDING_PKG - show dependent code

IGS_AV_GEN_001 - show dependent code

IGS_AV_LVL_LGCY_PUB - show dependent code

IGS_AV_UNT_LGCY_PUB - show dependent code

IGS_AV_VAL_ASU - show dependent code

IGS_AV_VAL_ASULEB - show dependent code

IGS_DA_CNFG_REQ_TYP_V

IGS_DA_REQ_STDNTS_V

IGS_DA_REQ_WIF_V

IGS_DA_TRNS_IMP - show dependent code

IGS_DA_XML_ACADEMICPROGRAM_V

IGS_DA_XML_PKG - show dependent code

IGS_EN_CAREER_MODEL - show dependent code

IGS_EN_ELGBL_OVERRIDE - show dependent code

IGS_EN_ELGBL_PROGRAM - show dependent code

IGS_EN_ELGBL_UNIT - show dependent code

IGS_EN_FUTURE_DT_TRANS - show dependent code

IGS_EN_GEN_002 - show dependent code

IGS_EN_GEN_003 - show dependent code

IGS_EN_GEN_005 - show dependent code

IGS_EN_GEN_006 - show dependent code

IGS_EN_GEN_008 - show dependent code

IGS_EN_GEN_010 - show dependent code

IGS_EN_GEN_011 - show dependent code

IGS_EN_GEN_012 - show dependent code

IGS_EN_GEN_015 - show dependent code

IGS_EN_GEN_016 - show dependent code

IGS_EN_GEN_017 - show dependent code

IGS_EN_GEN_LEGACY - show dependent code

IGS_EN_GEN_LEGACY - show dependent code

IGS_EN_IVR_PUB - show dependent code

IGS_EN_NSC_PKG - show dependent code

IGS_EN_OR_UNIT_WLST_PRF_V

IGS_EN_PE_PRG_CTXT_V

IGS_EN_PRC_LOAD - show dependent code

IGS_EN_PS_ATT_CH_OPT_V

IGS_EN_SCA_V

IGS_EN_SPAT_LGCY_PUB - show dependent code

IGS_EN_SPA_LGCY_PUB - show dependent code

IGS_EN_SPA_TERMS_API - show dependent code

IGS_EN_SPA_TERMS_V

IGS_EN_SS_SCHEDULE_DISP_V

IGS_EN_SS_STUD_CONTEXT_V

IGS_EN_STDNT_COURSE_ATTEMPT_V

IGS_EN_STDNT_PS_ATT_CRV_V

IGS_EN_STDNT_PS_ATT_PKG - show dependent code

IGS_EN_ST_SNAPSHOT_WARNING_V

IGS_EN_SUA_API - show dependent code

IGS_EN_SUA_LGCY_PUB - show dependent code

IGS_EN_SUA_WLST_V

IGS_EN_SU_ATTEMPT_PKG - show dependent code

IGS_EN_TIMESLOTS - show dependent code

IGS_EN_TIMESLOT_PREF_V

IGS_EN_TRANSFER_APIS - show dependent code

IGS_EN_VAL_SCA - show dependent code

IGS_EN_VAL_SCHO - show dependent code

IGS_EN_VAL_SCI - show dependent code

IGS_EN_VAL_SCT - show dependent code

IGS_EN_WLST_GEN_PROC - show dependent code

IGS_EN_WORKFLOW - show dependent code

IGS_FI_1098T_EXTRACT_DATA - show dependent code

IGS_FI_ACCT_STP_CNV - show dependent code

IGS_FI_CHARGES_API_PVT - show dependent code

IGS_FI_COM_REC_INTERFACE - show dependent code

IGS_FI_FD_SRC_RSTN_H_V

IGS_FI_FEE_AS_RATE_V

IGS_FI_FEE_TRG_GRP_V

IGS_FI_GEN_001 - show dependent code

IGS_FI_GEN_004 - show dependent code

IGS_FI_GEN_004 - show dependent code

IGS_FI_GEN_005 - show dependent code

IGS_FI_GEN_008 - show dependent code

IGS_FI_GEN_008 - show dependent code

IGS_FI_PRC_FEE_ASS - show dependent code

IGS_FI_PRC_SP_FEES - show dependent code

IGS_FI_PRC_STDNT_DPSTS - show dependent code

IGS_FI_VAL_CFT - show dependent code

IGS_GE_VAL_PARAM - show dependent code

IGS_GR_GEN_002 - show dependent code

IGS_GR_VAL_GR - show dependent code

IGS_HE_EXTRACT2_PKG - show dependent code

IGS_HE_EXTRACT_FIELDS_PKG - show dependent code

IGS_HE_EXTRACT_FIELDS_PKG - show dependent code

IGS_HE_EXTRACT_PKG - show dependent code

IGS_HE_FTE_CALC_PKG - show dependent code

IGS_HE_IDENTIFY_TARGET_POP - show dependent code

IGS_HE_IMPORT_DATA - show dependent code

IGS_HE_POOUS_DTLS_V

IGS_HE_POO_DTLS_V

IGS_HE_ST_PRG_DTLS_V

IGS_IN_GEN_001 - show dependent code

IGS_PE_PRG_ATP_V

IGS_PR_ACAD_LOAD_V

IGS_PR_ACAD_UNIT_V

IGS_PR_COHORT_INST_RANK_V

IGS_PR_CP_GPA - show dependent code

IGS_PR_GEN_001 - show dependent code

IGS_PR_GEN_004 - show dependent code

IGS_PR_GEN_005 - show dependent code

IGS_PR_GEN_006 - show dependent code

IGS_PR_GET_CLASS_STD - show dependent code

IGS_PR_PROG_OUT_WF_PKG - show dependent code

IGS_PR_SCA_PRG_RULE_APPL_V

IGS_PR_STDNT_PR_OU_V

IGS_PR_STD_PRG_AWD_AIM_V

IGS_PR_STU_ACAD_V

IGS_PR_UPLOAD_EXT_RESULTS - show dependent code

IGS_PR_VAL_POC - show dependent code

IGS_PR_VAL_PRA - show dependent code

IGS_PS_ENT_PT_REF_CD_PKG - show dependent code

IGS_PS_FLD_STUDY_HIST_V

IGS_PS_GEN_001 - show dependent code

IGS_PS_GEN_002 - show dependent code

IGS_PS_GEN_003 - show dependent code

IGS_PS_GEN_004 - show dependent code

IGS_PS_GEN_007 - show dependent code

IGS_PS_OCCUP_TITLES_V

IGS_PS_OFR_INST_PKG - show dependent code

IGS_PS_OFR_OPT_PKG - show dependent code

IGS_PS_OFR_PAT_APCOOD_PAT_V

IGS_PS_OFR_PAT_OFERPAT_V

IGS_PS_OFR_PAT_PKG - show dependent code

IGS_PS_OFR_PAT_V

IGS_PS_OFR_PKG - show dependent code

IGS_PS_OFR_VERSION_V

IGS_PS_OWN_HIST_V

IGS_PS_REF_CD_HIST_V

IGS_PS_RSV_ORGUN_PRF_V

IGS_PS_RSV_UOP_PRF_V

IGS_PS_RSV_USEC_PRF_V

IGS_PS_UOFR_WLST_PRF_V

IGS_PS_USEC_WLST_PRF_V

IGS_PS_VALIDATE_GENERIC_PKG - show dependent code

IGS_PS_VAL_CAO - show dependent code

IGS_PS_VAL_CAW - show dependent code

IGS_PS_VAL_CFOS - show dependent code

IGS_PS_VAL_COUS - show dependent code

IGS_PS_VAL_COW - show dependent code

IGS_PS_VAL_CRS - show dependent code

IGS_PS_VAL_CRV - show dependent code

IGS_PS_VAL_CTY - show dependent code

IGS_PS_VER_HIST_V

IGS_PS_VER_PKG - show dependent code

IGS_PS_VER_RU_V

IGS_PS_VER_TITLE_V

IGS_PS_VER_V

IGS_PT_GEN_PKG - show dependent code

IGS_RE_GEN_001 - show dependent code

IGS_RE_GEN_002 - show dependent code

IGS_RE_VAL_CA - show dependent code

IGS_RE_WORKFLOW - show dependent code

IGS_RU_GEN_001 - show dependent code

IGS_RU_GEN_002 - show dependent code

IGS_SS_ENROLL_PKG - show dependent code

IGS_SS_ENR_DETAILS - show dependent code

IGS_ST_GEN_001 - show dependent code

IGS_ST_GEN_002 - show dependent code

IGS_ST_GEN_003 - show dependent code

IGS_ST_GEN_004 - show dependent code

IGS_UC_EXPORT_TO_OSS - show dependent code

IGS_UC_UCAPCH_OSSAPPL_V