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.IGSFV_HIGHER_EDU_PROGRAMS

Object Details

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

View Type

A Business Intelligence System view

This is the full view which describes the programs that are offered by the university, covering both award and non-award programs.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_CODE	VARCHAR2	(6)	Yes	The unique identifier for a program of study
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 PROGRAM_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_HIGHER_EDU_PROGRAMS;

Dependencies

[top of page]

APPS.IGSFV_HIGHER_EDU_PROGRAMS references the following:

APPS: IGS_PS_COURSE

APPS.IGSFV_HIGHER_EDU_PROGRAMS is not referenced by any database object