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

VIEW: APPS.IGS_AS_USEC_CLASSLIST_V

Object Details
Object Name: IGS_AS_USEC_CLASSLIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AS_USEC_CLASSLIST_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


Describes Unit Sections for Class List


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOAD_DESCRIPTION VARCHAR2 (30)
Load Description
TEACH_DESCRIPTION VARCHAR2 (30)
Teaching Description
UNIT_CD VARCHAR2 (10) Yes Unit Code
UNIT_CLASS VARCHAR2 (10) Yes Unit Class
LOCATION VARCHAR2 (60) Yes Location
CALL_NUMBER NUMBER

Call Number
TITLE VARCHAR2 (90) Yes Unit Title
INSTRUCTOR_NAME VARCHAR2 (363)
Instructor Name
UOO_ID NUMBER (7) Yes Unit Ofering Option ID
INSTRUCTOR_ID NUMBER (15) Yes Instructor ID
LOAD_CAL_TYPE VARCHAR2 (10) Yes Load Calendar Type
LOAD_CI_SEQUENCE_NUMBER NUMBER (6) Yes Load Calendar Instance Sequence Number
LOAD_START_DT DATE
Yes Load Calendar Start Date
LOAD_END_DT DATE
Yes Load Calendar End Date
TEACH_CAL_TYPE VARCHAR2 (10) Yes Teaching Calendar Type
TEACH_CI_SEQUENCE_NUMBER NUMBER (6) Yes Teaching Calendar Instance Sequence Number
Query Text

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


SELECT LOAD_DESCRIPTION
,      TEACH_DESCRIPTION
,      UNIT_CD
,      UNIT_CLASS
,      LOCATION
,      CALL_NUMBER
,      TITLE
,      INSTRUCTOR_NAME
,      UOO_ID
,      INSTRUCTOR_ID
,      LOAD_CAL_TYPE
,      LOAD_CI_SEQUENCE_NUMBER
,      LOAD_START_DT
,      LOAD_END_DT
,      TEACH_CAL_TYPE
,      TEACH_CI_SEQUENCE_NUMBER
FROM APPS.IGS_AS_USEC_CLASSLIST_V;

Dependencies

[top of page]

APPS.IGS_AS_USEC_CLASSLIST_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_CA_TEACH_TO_LOAD_V
ViewIGS_PS_UNIT_OFR_OPT_V
SynonymIGS_PS_USEC_TCH_RESP

APPS.IGS_AS_USEC_CLASSLIST_V is not referenced by any database object