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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

From 2004, offer information will be held in different Hercules views for different systems. This View selects the Offer information belonging to all the systems.

[View Source]

Columns

Name	Datatype	Length	Comments
APPNO	NUMBER	(22)	Application Number
CHOICENO	NUMBER	(22)	Choice Number
TIMESTAMP	DATE		Timestamp
OFFERCOURSE	VARCHAR2	(6)	Change Course
OFFERCAMPUS	VARCHAR2	(1)	Change Campus
OFFERCOURSELENGTH	NUMBER	(22)	Change Duration
OFFERENTRYMONTH	VARCHAR2	(2)	Change Entry Month
OFFERENTRYYEAR	VARCHAR2	(2)	Change Entry Year
OFFERENTRYPOINT	VARCHAR2	(1)	Change entry point
OFFERTEXT	VARCHAR2	(2000)	Semi-expanded offer letter

Query Text

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


SELECT APPNO
,      CHOICENO
,      TIMESTAMP
,      OFFERCOURSE
,      OFFERCAMPUS
,      OFFERCOURSELENGTH
,      OFFERENTRYMONTH
,      OFFERENTRYYEAR
,      OFFERENTRYPOINT
,      OFFERTEXT
FROM APPS.IGS_UC_IVOFFER_2003_V;

Dependencies

[top of page]

APPS.IGS_UC_IVOFFER_2003_V references the following:

APPS: IGS_UC_U_IVOFFER_2003

APPS.IGS_UC_IVOFFER_2003_V is referenced by following:

APPS: IGS_UC_LOAD_HERCULES_DATA - show dependent code