[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_X_USEC_CLASSLIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_X_USEC_CLASSLIST_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
Describes Cross Listed Unit Sections for Class List
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 |
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;
|
|
|