eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSBV_UNIT_FIELD_OF_STUDIES

Object Details

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

View Type

A Business Intelligence System view

This is the base view, which describes the Unit Field Of Study with details unit code, version number and field of study

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_FIELD_OF_STUDY_ID	NUMBER	(10)	Yes	Unique Identifier for Unit Field of Study
UNIT_CODE	VARCHAR2	(10)	Yes	The unique identifier of the unit.
VERSION_NUMBER	NUMBER	(3)	Yes	The version number of the unit.
FIELD_OF_STUDY	VARCHAR2	(10)	Yes	The area or field to which the unit belongs.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.

Query Text

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


SELECT UNIT_FIELD_OF_STUDY_ID
,      UNIT_CODE
,      VERSION_NUMBER
,      FIELD_OF_STUDY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_UNIT_FIELD_OF_STUDIES;

Dependencies

[top of page]

APPS.IGSBV_UNIT_FIELD_OF_STUDIES references the following:

APPS: IGS_PS_UNIT_FLD_STDY

APPS.IGSBV_UNIT_FIELD_OF_STUDIES is not referenced by any database object