[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_PS_TYPE

Object Details

Object Name:	IGS_PS_TYPE
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PS_TYPE
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.

Multi Org view for IGS_PS_TYPE_ALL table, which stores the information about the program types.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      COURSE_TYPE
,      DESCRIPTION
,      GOVT_COURSE_TYPE
,      AWARD_COURSE_IND
,      COURSE_TYPE_GROUP_CD
,      TAC_COURSE_LEVEL
,      RESEARCH_TYPE_IND
,      CLOSED_IND
,      PRIMARY_AUTO_SELECT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      ENROLMENT_CAT
,      FIN_AID_PROGRAM_TYPE
FROM APPS.IGS_PS_TYPE;

Dependencies

[top of page]

APPS

IGS_PS_TYPE_ALL

APPS

IGF_AP_PR_PRG_TYPE_V

IGS_AD_DEPLVL_PRGTY_V

IGS_AD_GEN_002 - show dependent code

IGS_AD_VAL_ACAI - show dependent code

IGS_AD_VAL_ACAI_STATUS - show dependent code

IGS_AD_VAL_CRS_ADMPERD - show dependent code

IGS_AS_GEN_001 - show dependent code

IGS_AS_SS_DOC_REQUEST - show dependent code

IGS_AS_VAL_ACOT - show dependent code

IGS_EN_ADD_UNITS_API - show dependent code

IGS_EN_CAREER_MODEL - show dependent code

IGS_EN_DROP_UNITS_API - show dependent code

IGS_EN_ELGBL_UNIT - show dependent code

IGS_EN_GEN_003 - show dependent code

IGS_EN_GEN_005 - 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_016 - show dependent code

IGS_EN_GEN_LEGACY - show dependent code

IGS_EN_GEN_LEGACY - show dependent code

IGS_EN_NSC_PKG - show dependent code

IGS_EN_PLAN_UTILS - show dependent code

IGS_EN_SPA_LGCY_PUB - show dependent code

IGS_EN_STDNT_PS_ATT_PKG - show dependent code

IGS_EN_TIMESLOTS - show dependent code

IGS_EN_TIMESLOT_PREF_V

IGS_EN_TRANSFER_APIS - show dependent code

IGS_EN_UNIT_SET_COURSE_TYPE_V

IGS_EN_VAL_SCA - show dependent code

IGS_EN_VAL_SCHO - show dependent code

IGS_EN_VAL_SUA - show dependent code

IGS_GE_VAL_PARAM - show dependent code

IGS_HE_IDENTIFY_TARGET_POP - show dependent code

IGS_PR_ACAD_PROGRAM_V

IGS_PR_CS_SCHDL_V

IGS_PR_GET_CLASS_STD - show dependent code

IGS_PS_GEN_002 - show dependent code

IGS_PS_TYPE_HIST_V

IGS_PS_TYPE_V

IGS_PS_VAL_CAW - show dependent code

IGS_PS_VAL_CRV - show dependent code

IGS_PS_VAL_CTY - show dependent code

IGS_PS_VAL_CUL - show dependent code

IGS_PS_VAL_GCT - show dependent code

IGS_PS_VER_HIST_V

IGS_RE_GEN_002 - show dependent code

IGS_RE_VAL_CA - 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