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

VIEW: APPS.IGS_AS_X_USEC_CLASSLIST_V

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

View Type

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


Describes Cross Listed 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
GROUP_NAME VARCHAR2 (80) Yes Cross Listed Group Name
LOCATION VARCHAR2 (60) Yes Location
INSTRUCTOR_NAME VARCHAR2 (363)
Instructor Name
INSTRUCTOR_ID NUMBER (15) Yes Instructor ID
GROUP_ID NUMBER (10) Yes Group 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
,      GROUP_NAME
,      LOCATION
,      INSTRUCTOR_NAME
,      INSTRUCTOR_ID
,      GROUP_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_X_USEC_CLASSLIST_V;

Dependencies

[top of page]

APPS.IGS_AS_X_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
SynonymIGS_PS_USEC_X_GRP
SynonymIGS_PS_USEC_X_GRPMEM
APPS.IGS_AS_X_USEC_CLASSLIST_V is referenced by following:

SchemaAPPS
Package BodyIGS_AS_ADI_UPLD_AIO_PKG - show dependent code