[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_ESE_EXMVNUS_UNAVLBL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_ESE_EXMVNUS_UNAVLBL_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view selects all venues which are unavailable for each
examination session. This is the reverse of the data structure which
stores the 'availability'.
The view will contain a record for each examination session for each
open venue where no availability records exists for the combination.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VENUE_CD | VARCHAR2 | (10) | Yes | The code that describes the examination venue if an examination can be held. |
EXAM_CAL_TYPE | VARCHAR2 | (10) | Yes | The examination session calendar type |
EXAM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The examination session calendar type sequence number |
DT_ALIAS | VARCHAR2 | (10) | Yes | The examination session date alias |
DAI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The examination session date alias sequence number |
EXAM_SESSION_NUMBER | NUMBER | (2) | Yes | The start time of the examination |
ALIAS_VAL | DATE | The date of the examination session | ||
START_TIME | DATE | Yes | The start time of the examination | |
END_TIME | DATE | Yes | The end time of the examination | |
ESE_ID | NUMBER | (6) | Yes | The examination session ID |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT VENUE_CD
, EXAM_CAL_TYPE
, EXAM_CI_SEQUENCE_NUMBER
, DT_ALIAS
, DAI_SEQUENCE_NUMBER
, EXAM_SESSION_NUMBER
, ALIAS_VAL
, START_TIME
, END_TIME
, ESE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_AS_ESE_EXMVNUS_UNAVLBL_V;
APPS.IGS_AS_ESE_EXMVNUS_UNAVLBL_V is not referenced by any database object
|
|
|