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_ALLOCATIONS

Object Details

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

A resource allocation records supplied resources to a student on an
event.
NOTE: This functionality is not currently implemented.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_RESOURCE_ALLOCATIONS_PK

RESOURCE_ALLOCATION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_RESOURCE_ALLOCATIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_ALLOCATION_ID
OTA_RESOURCE_ALLOCATIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRAINER_RESOURCE_BOOKING_ID
OTA_RESOURCE_ALLOCATIONS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOKING_ID
OTA_RESOURCE_ALLOCATIONS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EQUIPMENT_RESOURCE_BOOKING_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OTA_RESOURCE_ALLOCATIONS	OTA_DELEGATE_BOOKINGS	OTA_RESOURCE_ALLOCATIONS BOOKING_ID
OTA_RESOURCE_ALLOCATIONS	OTA_RESOURCE_BOOKINGS	OTA_RESOURCE_ALLOCATIONS EQUIPMENT_RESOURCE_BOOKING_ID
OTA_RESOURCE_ALLOCATIONS	OTA_RESOURCE_BOOKINGS	OTA_RESOURCE_ALLOCATIONS TRAINER_RESOURCE_BOOKING_ID
OTA_FINANCE_LINES	OTA_RESOURCE_ALLOCATIONS	OTA_FINANCE_LINES RESOURCE_ALLOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ALLOCATION_ID	NUMBER	(9)	Yes	The Primary Key of the Table
TRAINER_RESOURCE_BOOKING_ID	NUMBER	(9)	Yes	Foreign key to OTA_RESOURCE_BOOKINGS
BOOKING_ID	NUMBER	(9)	Yes	Foreign key to OTA_DELEGATE_BOOKINGS
EQUIPMENT_RESOURCE_BOOKING_ID	NUMBER	(9)	Yes	Foreign key to OTA_RESOURCE_BOOKINGS
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter
START_DATE	DATE		Yes	The start date of the allocation
AGENDA_ITEM_ID	NUMBER	(9)		Dummy item because relationship has been suppressed
CHARGE_DELEGATE_FLAG	VARCHAR2	(30)		Should Price of Res Booking be passed on to Delegate
COMMENTS	VARCHAR2	(2000)		Any text based comments
END_DATE	DATE			The end date of the allocation
END_TIME	VARCHAR2	(5)		The end time of the allocation
START_TIME	VARCHAR2	(5)		The start time of allocation
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
TRA_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
TRA_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
TRA_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column

Query Text

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


SELECT RESOURCE_ALLOCATION_ID
,      TRAINER_RESOURCE_BOOKING_ID
,      BOOKING_ID
,      EQUIPMENT_RESOURCE_BOOKING_ID
,      OBJECT_VERSION_NUMBER
,      START_DATE
,      AGENDA_ITEM_ID
,      CHARGE_DELEGATE_FLAG
,      COMMENTS
,      END_DATE
,      END_TIME
,      START_TIME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TRA_INFORMATION_CATEGORY
,      TRA_INFORMATION1
,      TRA_INFORMATION2
,      TRA_INFORMATION3
,      TRA_INFORMATION4
,      TRA_INFORMATION5
,      TRA_INFORMATION6
,      TRA_INFORMATION7
,      TRA_INFORMATION8
,      TRA_INFORMATION9
,      TRA_INFORMATION10
,      TRA_INFORMATION11
,      TRA_INFORMATION12
,      TRA_INFORMATION13
,      TRA_INFORMATION14
,      TRA_INFORMATION15
,      TRA_INFORMATION16
,      TRA_INFORMATION17
,      TRA_INFORMATION18
,      TRA_INFORMATION19
,      TRA_INFORMATION20
FROM OTA.OTA_RESOURCE_ALLOCATIONS;

Dependencies

[top of page]

OTA.OTA_RESOURCE_ALLOCATIONS does not reference any database object

OTA.OTA_RESOURCE_ALLOCATIONS is referenced by following:

APPS: OTA_RESOURCE_ALLOCATIONS; OTA_RESOURCE_ALLOCATIONS_WHO