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_AS_USEC_GRADE_ENTRY_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOAD_DESCRIPTION	VARCHAR2	(30)		Load calendar description.
TEACH_DESCRIPTION	VARCHAR2	(30)		Teaching calendar description.
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit class
LOCATION_CD	VARCHAR2	(10)	Yes	Location Code.
LOCATION	VARCHAR2	(60)	Yes	Location
CALL_NUMBER	NUMBER			call Number
TITLE	VARCHAR2	(90)	Yes	Title
GRADING_SCHEMA_CD	VARCHAR2	(10)		Grading Schema
GS_VERSION_NUMBER	NUMBER			Grading Schema version number
INSTRUCTOR_ID	NUMBER	(15)	Yes	Instructor Id
INSTRUCTOR_NAME	VARCHAR2	(363)		Instructor name
UOO_ID	NUMBER	(7)	Yes	Unit section offering option id
LOAD_CAL_TYPE	VARCHAR2	(10)	Yes	Load Calendar Type.
LOAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Load Calendar Sequence Number.
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Term cal type
TEACH_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Teaching sequence number
OWNER_ORG_UNIT_CD	VARCHAR2	(30)
TEACH_ALTERNATE_CODE	VARCHAR2	(10)		Teaching Calendar Alternate Code

Query Text

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


SELECT LOAD_DESCRIPTION
,      TEACH_DESCRIPTION
,      UNIT_CD
,      UNIT_CLASS
,      LOCATION_CD
,      LOCATION
,      CALL_NUMBER
,      TITLE
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      INSTRUCTOR_ID
,      INSTRUCTOR_NAME
,      UOO_ID
,      LOAD_CAL_TYPE
,      LOAD_CI_SEQUENCE_NUMBER
,      TEACH_CAL_TYPE
,      TEACH_CI_SEQUENCE_NUMBER
,      OWNER_ORG_UNIT_CD
,      TEACH_ALTERNATE_CODE
FROM APPS.IGS_AS_USEC_GRADE_ENTRY_V;

Dependencies

[top of page]

APPS.IGS_AS_USEC_GRADE_ENTRY_V references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION_ALL; IGS_CA_TEACH_TO_LOAD_V; IGS_PS_UNIT_GRD_SCHM; IGS_PS_UNIT_OFR_OPT_ALL; IGS_PS_UNIT_VER_ALL; IGS_PS_USEC_GRD_SCHM; IGS_PS_USEC_TCH_RESP

APPS.IGS_AS_USEC_GRADE_ENTRY_V is not referenced by any database object