eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OTA.OTA_RESOURCE_BOOKINGS

Object Details

Object Name:	OTA_RESOURCE_BOOKINGS
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_RESOURCE_BOOKINGS
Subobject Name:
Status:	VALID

You book a resource (person, facilities or equipment) for a scheduled
or develoment event, or for sessions. You can book a resource for a
specific event, or for a number of events. Each resource booking can
have a start and end dates, as well a start and end times. You
can enter start and end times to support resource bookings that are
not required for the full duration of an event.
A resource booking can be one of the following:
1. Planned
2. Confirmed
You can double- book supplied resources if the booking is Planned, but
you cannot double-book for Confirmed bookings.
You can add finance information for resource bookings to indicate that
the booking has incurred a cost.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_RESOURCE_BOOKINGS_PK

RESOURCE_BOOKING_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_RESOURCE_BOOKINGS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_BOOKING_ID
OTA_RESOURCE_BOOKINGS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIED_RESOURCE_ID
OTA_RESOURCE_BOOKINGS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID
OTA_RESOURCE_BOOKINGS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORUM_ID
OTA_RESOURCE_BOOKINGS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OTA_RESOURCE_BOOKINGS	OTA_EVENTS	OTA_RESOURCE_BOOKINGS EVENT_ID
OTA_RESOURCE_BOOKINGS	OTA_SUPPLIABLE_RESOURCES	OTA_RESOURCE_BOOKINGS SUPPLIED_RESOURCE_ID
OTA_FINANCE_LINES	OTA_RESOURCE_BOOKINGS	OTA_FINANCE_LINES RESOURCE_BOOKING_ID
OTA_RESOURCE_ALLOCATIONS	OTA_RESOURCE_BOOKINGS	OTA_RESOURCE_ALLOCATIONS TRAINER_RESOURCE_BOOKING_ID
OTA_RESOURCE_ALLOCATIONS	OTA_RESOURCE_BOOKINGS	OTA_RESOURCE_ALLOCATIONS EQUIPMENT_RESOURCE_BOOKING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_BOOKING_ID	NUMBER	(9)	Yes	The system generated surrogate key for this booking
SUPPLIED_RESOURCE_ID	NUMBER	(9)	Yes	Foreign key to OTA_SUPPLIABLE_RESOURCES
EVENT_ID	NUMBER	(9)		Foreign key to OTA_EVENTS
DATE_BOOKING_PLACED	DATE		Yes	The date on which this booking was made
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter
STATUS	VARCHAR2	(30)	Yes	The current status of this resource booking.
ABSOLUTE_PRICE	NUMBER	(9)		The absolute price this resource is to be charged at.
BOOKING_PERSON_ID	NUMBER	(10)		Foreign key to FND_USER
COMMENTS	VARCHAR2	(2000)		A free text field for any special instructions
CONTACT_NAME	VARCHAR2	(80)		The contact name for this booking
CONTACT_PHONE_NUMBER	VARCHAR2	(80)		The phone number on which the contact may be reached.
DELEGATES_PER_UNIT	NUMBER	(9)		The max number of delegates that can use the resource
QUANTITY	NUMBER	(9)		The quantity of the resource booked.
REQUIRED_DATE_FROM	DATE			The date this resource is required.
REQUIRED_DATE_TO	DATE			The last day on which this resource is required.
REQUIRED_END_TIME	VARCHAR2	(5)		The time this resource is required till.
REQUIRED_START_TIME	VARCHAR2	(5)		The start time this resource is required.
DELIVER_TO	VARCHAR2	(2000)		The delivery details if different from the main venue
PRIMARY_VENUE_FLAG	VARCHAR2	(30)		Describes if this is the primary venue for the event.
ROLE_TO_PLAY	VARCHAR2	(30)		The role this trainer will play in the booking.
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
TRB_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
TRB_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
TRB_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column
DISPLAY_TO_LEARNER_FLAG	VARCHAR2	(1)		Determine showing the resources to Learner.
BOOK_ENTIRE_PERIOD_FLAG	VARCHAR2	(1)		Determine whether booking for entire period
FORUM_ID	NUMBER	(15)		Foreign Key to OTA_FORUMS_B
CHAT_ID	NUMBER	(15)		Foreign Key to OTA_CHATS_B
TIMEZONE_CODE	VARCHAR2	(50)		Time Zone Code

Query Text

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


SELECT RESOURCE_BOOKING_ID
,      SUPPLIED_RESOURCE_ID
,      EVENT_ID
,      DATE_BOOKING_PLACED
,      OBJECT_VERSION_NUMBER
,      STATUS
,      ABSOLUTE_PRICE
,      BOOKING_PERSON_ID
,      COMMENTS
,      CONTACT_NAME
,      CONTACT_PHONE_NUMBER
,      DELEGATES_PER_UNIT
,      QUANTITY
,      REQUIRED_DATE_FROM
,      REQUIRED_DATE_TO
,      REQUIRED_END_TIME
,      REQUIRED_START_TIME
,      DELIVER_TO
,      PRIMARY_VENUE_FLAG
,      ROLE_TO_PLAY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TRB_INFORMATION_CATEGORY
,      TRB_INFORMATION1
,      TRB_INFORMATION2
,      TRB_INFORMATION3
,      TRB_INFORMATION4
,      TRB_INFORMATION5
,      TRB_INFORMATION6
,      TRB_INFORMATION7
,      TRB_INFORMATION8
,      TRB_INFORMATION9
,      TRB_INFORMATION10
,      TRB_INFORMATION11
,      TRB_INFORMATION12
,      TRB_INFORMATION13
,      TRB_INFORMATION14
,      TRB_INFORMATION15
,      TRB_INFORMATION16
,      TRB_INFORMATION17
,      TRB_INFORMATION18
,      TRB_INFORMATION19
,      TRB_INFORMATION20
,      DISPLAY_TO_LEARNER_FLAG
,      BOOK_ENTIRE_PERIOD_FLAG
,      FORUM_ID
,      CHAT_ID
,      TIMEZONE_CODE
FROM OTA.OTA_RESOURCE_BOOKINGS;

Dependencies

[top of page]

OTA.OTA_RESOURCE_BOOKINGS does not reference any database object

OTA.OTA_RESOURCE_BOOKINGS is referenced by following:

APPS: OTA_RESOURCE_BOOKINGS; OTA_RESOURCE_BOOKINGS_WHO