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

VIEW: APPS.IGS_SS_USEC_OCCURENCES_V

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

View Type

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


This view stores Unit Section Occurrences.


[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIT_SECTION_OCCURRENCE_ID NUMBER (10) Yes Identifier for unit section occurences
UOO_ID NUMBER (7) Yes Unit Offering Options Identifer
CLASS_DAY VARCHAR2 (21)
Class Day
CLASS_TIME VARCHAR2 (15)
Class Time
LOCATION_CD VARCHAR2 (10)
Location Code
LOCATION_DESCRIPTION VARCHAR2 (60)
Location description
BUILDING_ID NUMBER (10)
Building Identifier
BUILDING_CD VARCHAR2 (10)
Building Code
BUILDING_DESCRIPTION VARCHAR2 (80)
Building description
ROOM_ID NUMBER (10)
Room Identifier
ROOM_CD VARCHAR2 (10)
Room code
ROOM_DESCRIPTION VARCHAR2 (80)
Room description
INSTRUCTOR_ID NUMBER (15)
Instructor identifier
SURNAME VARCHAR2 (150)
Surname
GIVEN_NAMES VARCHAR2 (150)
Names given
PERSON_TITLE VARCHAR2 (60)
Person Title
INSTRUCTOR_NAME VARCHAR2 (365)
Instructor Name
START_DATE DATE

Start Date
END_DATE DATE

End Date
Query Text

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


SELECT UNIT_SECTION_OCCURRENCE_ID
,      UOO_ID
,      CLASS_DAY
,      CLASS_TIME
,      LOCATION_CD
,      LOCATION_DESCRIPTION
,      BUILDING_ID
,      BUILDING_CD
,      BUILDING_DESCRIPTION
,      ROOM_ID
,      ROOM_CD
,      ROOM_DESCRIPTION
,      INSTRUCTOR_ID
,      SURNAME
,      GIVEN_NAMES
,      PERSON_TITLE
,      INSTRUCTOR_NAME
,      START_DATE
,      END_DATE
FROM APPS.IGS_SS_USEC_OCCURENCES_V;

Dependencies

[top of page]

APPS.IGS_SS_USEC_OCCURENCES_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_AD_BUILDING
ViewIGS_AD_LOCATION
ViewIGS_AD_ROOM
ViewIGS_PS_USEC_OCCURS

APPS.IGS_SS_USEC_OCCURENCES_V is not referenced by any database object