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

VIEW: APPS.IGS_AS_USEC_SESSNS_V

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

View Type

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


This view defines the details of the placement sessions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID of the Table IGS_AS_USEC_SESSNS
SESSION_NAME VARCHAR2 (90) Yes Session for what the attendance is captured.
SESSION_DESCRIPTION VARCHAR2 (240)
Description of the session.
UOO_ID NUMBER (7) Yes Unit section ID for what the session is used.
UNIT_SECTION_OCCURRENCE_ID NUMBER (10)
Occurrence of the unit section.
OCCURENCE_DESC VARCHAR2 (4000)
Description of the unit section occurrence, if used for the session.
SESSION_START_DATE_TIME DATE
Yes Start date time of the session.
SESSION_END_DATE_TIME DATE

End date time of the session.
SESSION_LOCATION_DESC VARCHAR2 (240)
Location where the session is being held.
CREATED_BY NUMBER (15) Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
Query Text

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


SELECT ROW_ID
,      SESSION_NAME
,      SESSION_DESCRIPTION
,      UOO_ID
,      UNIT_SECTION_OCCURRENCE_ID
,      OCCURENCE_DESC
,      SESSION_START_DATE_TIME
,      SESSION_END_DATE_TIME
,      SESSION_LOCATION_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_AS_USEC_SESSNS_V;

Dependencies

[top of page]

APPS.IGS_AS_USEC_SESSNS_V references the following:

SchemaAPPS
PL/SQL PackageIGS_AS_GEN_008 - show dependent code
SynonymIGS_AS_USEC_SESSNS

APPS.IGS_AS_USEC_SESSNS_V is not referenced by any database object