[Home] [Help]
[Dependency Information]
VIEW: APPS.IGS_PS_FLD_OF_STUDY
Object Details
Object Name: | IGS_PS_FLD_OF_STUDY |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_FLD_OF_STUDY
|
---|
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.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ROW_ID |
ROWID |
(10) |
|
|
FOS_TYPE_CODE |
VARCHAR2 |
(30) |
Yes |
Field of Study type Code |
FOS_TYPE_CODE_DESC |
VARCHAR2 |
(80) |
Yes |
Description for Field of Study type code |
FIELD_OF_STUDY |
VARCHAR2 |
(10) |
Yes |
|
DESCRIPTION |
VARCHAR2 |
(80) |
Yes |
|
GOVT_FIELD_OF_STUDY |
VARCHAR2 |
(10) |
|
|
CLOSED_IND |
VARCHAR2 |
(1) |
Yes |
|
CREATED_BY |
NUMBER |
(15) |
Yes |
|
CREATION_DATE |
DATE |
|
Yes |
|
LAST_UPDATED_BY |
NUMBER |
(15) |
Yes |
|
LAST_UPDATE_DATE |
DATE |
|
Yes |
|
LAST_UPDATE_LOGIN |
NUMBER |
(15) |
|
|
ORG_ID |
NUMBER |
(15) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, FOS_TYPE_CODE
, FOS_TYPE_CODE_DESC
, FIELD_OF_STUDY
, DESCRIPTION
, GOVT_FIELD_OF_STUDY
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM APPS.IGS_PS_FLD_OF_STUDY;
Dependencies
[top of page]
APPS.IGS_PS_FLD_OF_STUDY references the following:
-
APPS
-
IGS_LOOKUP_VALUES
-
IGS_PS_FLD_OF_STUDY_ALL
APPS.IGS_PS_FLD_OF_STUDY is referenced by following:
-
APPS
-
IGSBV_UNIT_SET_FLD_OF_STUDIES
-
IGSFV_ORG_HESA_COST_CENTRES
-
IGSFV_POOUS_HESA_COST_CENTRES
-
IGSFV_PROG_HESA_COST_CENTRES
-
IGSFV_UNIT_HESA_COST_CENTRES
-
IGSFV_UNIT_SET_FLD_OF_STUDIES
-
IGS_AD_ACAD_INTEREST_V
-
IGS_AD_GEN_002
- show dependent code
-
IGS_AD_PRC_TAC_OFFER
- show dependent code
-
IGS_HE_EXTRACT2_PKG
- show dependent code
-
IGS_HE_EXTRACT_FIELDS_PKG
- show dependent code
-
IGS_HE_IMPORT_DATA
- show dependent code
-
IGS_HE_OU_CC_V
-
IGS_HE_POOUS_OU_CC_V
-
IGS_HE_POUS_CC_DTL_V
-
IGS_HE_PROG_OU_CC_V
-
IGS_HE_ST_SPA_DTLS_V
-
IGS_HE_ST_UNC_DTLS_V
-
IGS_HE_UNT_OU_CC_V
-
IGS_HE_UT_EXCL_QALS_V
-
IGS_PS_FACLTY_DISP_V
-
IGS_PS_FIELD_STUDY_V
-
IGS_PS_FLD_STDY_HIST_V
-
IGS_PS_UNIT_FLD_STDY_V
-
IGS_PS_US_FLD_STUDY_V
-
IGS_PS_VAL_CFOS
- show dependent code
-
IGS_PS_VAL_GFOS
- show dependent code
-
IGS_RE_CDT_FLD_OF_SY_V
-
IGS_RE_VAL_CAFOS
- show dependent code
-
IGS_ST_GEN_003
- show dependent code
-
IGS_ST_GEN_004
- show dependent code
-
IGS_UC_QUAL_DETS_IMP_PKG
- show dependent code