[Home] [Help]
[Dependency Information]
VIEW: APPS.OTFV_OVERBOOKED_RESOURCES
Object Details
Object Name: | OTFV_OVERBOOKED_RESOURCES |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_OVERBOOKED_RESOURCES
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A Business Intelligence System view
This view shows those resources which have been booked for more than one event at the same time.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
RESOURCE_NAME |
VARCHAR2 |
(400) |
|
|
RESOURCE_BOOKING_ID |
NUMBER |
(9) |
|
|
SUPPLIED_RESOURCE_ID |
NUMBER |
(9) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_NAME
, RESOURCE_BOOKING_ID
, SUPPLIED_RESOURCE_ID
FROM APPS.OTFV_OVERBOOKED_RESOURCES;
Dependencies
[top of page]
APPS.OTFV_OVERBOOKED_RESOURCES references the following:
-
APPS
-
OTA_GENERAL
- show dependent code
-
OTA_RESOURCE_BOOKINGS
-
OTA_SUPPLIABLE_RESOURCES
-
OTA_SUPPLIABLE_RESOURCES_TL
APPS.OTFV_OVERBOOKED_RESOURCES is referenced by following:
-
PUBLIC
-
OTFV_OVERBOOKED_RESOURCES