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]

VIEW: APPS.OTA_RESOURCE_BOOKINGS_V

Object Details

Object Name:	OTA_RESOURCE_BOOKINGS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTA_RESOURCE_BOOKINGS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
BUSINESS_GROUP_ID	NUMBER	(9)	Yes
RESOURCE_BOOKING_ID	NUMBER	(9)	Yes
SUPPLIED_RESOURCE_ID	NUMBER	(9)	Yes
RESOURCE_DEFINITION_ID	NUMBER	(15)	Yes
RESOURCE_VENDOR_ID	NUMBER	(15)
RESOURCE_VENDOR_NAME	VARCHAR2	(240)
RESOURCE_TYPE	VARCHAR2	(30)	Yes
RESOURCE_TYPE_MEANING	VARCHAR2	(80)	Yes
RESOURCE_NAME	VARCHAR2	(400)
RESOURCE_CONSUMABLE_FLAG	VARCHAR2	(30)	Yes
RESOURCE_CURRENCY_CODE	VARCHAR2	(30)
RESOURCE_NORMAL_COST	NUMBER	(9)
RESOURCE_COST_UNIT	VARCHAR2	(80)
EVENT_ID	NUMBER	(9)
EVENT_TITLE	VARCHAR2	(80)
EVENT_START_DATE	DATE
EVENT_END_DATE	DATE
EVENT_START_TIME	VARCHAR2	(5)
EVENT_END_TIME	VARCHAR2	(5)
EVENT_CURRENCY_CODE	VARCHAR2	(30)
EVENT_CENTRE	VARCHAR2	(30)
EVENT_CENTRE_MEANING	VARCHAR2	(4000)
ACTIVITY_VERSION_ID	NUMBER	(9)
ACTIVITY_VERSION_NAME	VARCHAR2	(80)
DATE_BOOKING_PLACED	DATE		Yes
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes
STATUS	VARCHAR2	(30)	Yes
STATUS_MEANING	VARCHAR2	(80)	Yes
ABSOLUTE_PRICE	NUMBER	(9)
BOOKING_PERSON_ID	NUMBER	(10)
BOOKING_PLACED_BY	VARCHAR2	(100)
COMMENTS	VARCHAR2	(2000)
CONTACT_NAME	VARCHAR2	(80)
CONTACT_PHONE_NUMBER	VARCHAR2	(80)
DELEGATES_PER_UNIT	NUMBER	(9)
QUANTITY	NUMBER	(9)
REQUIRED_DATE_FROM	DATE
REQUIRED_DATE_TO	DATE
REQUIRED_END_TIME	VARCHAR2	(5)
REQUIRED_START_TIME	VARCHAR2	(5)
DELIVER_TO	VARCHAR2	(2000)
PRIMARY_VENUE_FLAG	VARCHAR2	(30)
ROLE_TO_PLAY	VARCHAR2	(30)
ROLE_TO_PLAY_MEANING	VARCHAR2	(4000)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
TRB_INFORMATION_CATEGORY	VARCHAR2	(30)
TRB_INFORMATION1	VARCHAR2	(150)
TRB_INFORMATION2	VARCHAR2	(150)
TRB_INFORMATION3	VARCHAR2	(150)
TRB_INFORMATION4	VARCHAR2	(150)
TRB_INFORMATION5	VARCHAR2	(150)
TRB_INFORMATION6	VARCHAR2	(150)
TRB_INFORMATION7	VARCHAR2	(150)
TRB_INFORMATION8	VARCHAR2	(150)
TRB_INFORMATION9	VARCHAR2	(150)
TRB_INFORMATION10	VARCHAR2	(150)
TRB_INFORMATION11	VARCHAR2	(150)
TRB_INFORMATION12	VARCHAR2	(150)
TRB_INFORMATION13	VARCHAR2	(150)
TRB_INFORMATION14	VARCHAR2	(150)
TRB_INFORMATION15	VARCHAR2	(150)
TRB_INFORMATION16	VARCHAR2	(150)
TRB_INFORMATION17	VARCHAR2	(150)
TRB_INFORMATION18	VARCHAR2	(150)
TRB_INFORMATION19	VARCHAR2	(150)
TRB_INFORMATION20	VARCHAR2	(150)
INVOICE_CURRENCY_CODE	VARCHAR2	(30)
INVOICE_MONEY_AMOUNT	NUMBER
FINANCE_HEADER_ID	NUMBER	(9)
FINANCE_LINE_ID	NUMBER	(9)
FINANCE_LINE_TRANSFER	VARCHAR2	(30)
FINANCE_LINE_OVN	NUMBER	(9)
EVT_TRAINING_CENTER_ID	NUMBER	(15)
EVT_LOCATION_ID	NUMBER	(15)
OFF_LANGUAGE_CODE	VARCHAR2	(30)
RES_TRAINING_CENTER_ID	NUMBER	(15)
RES_LOCATION_ID	NUMBER	(15)
RES_TRAINER_ID	NUMBER	(10)
DISPLAY_TO_LEARNER_FLAG	VARCHAR2	(1)
BOOK_ENTIRE_PERIOD_FLAG	VARCHAR2	(1)
FORUM_ID	NUMBER	(15)
CHAT_ID	NUMBER	(15)
TIMEZONE_CODE	VARCHAR2	(50)		Time Zone Code

Query Text

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


SELECT ROW_ID
,      BUSINESS_GROUP_ID
,      RESOURCE_BOOKING_ID
,      SUPPLIED_RESOURCE_ID
,      RESOURCE_DEFINITION_ID
,      RESOURCE_VENDOR_ID
,      RESOURCE_VENDOR_NAME
,      RESOURCE_TYPE
,      RESOURCE_TYPE_MEANING
,      RESOURCE_NAME
,      RESOURCE_CONSUMABLE_FLAG
,      RESOURCE_CURRENCY_CODE
,      RESOURCE_NORMAL_COST
,      RESOURCE_COST_UNIT
,      EVENT_ID
,      EVENT_TITLE
,      EVENT_START_DATE
,      EVENT_END_DATE
,      EVENT_START_TIME
,      EVENT_END_TIME
,      EVENT_CURRENCY_CODE
,      EVENT_CENTRE
,      EVENT_CENTRE_MEANING
,      ACTIVITY_VERSION_ID
,      ACTIVITY_VERSION_NAME
,      DATE_BOOKING_PLACED
,      OBJECT_VERSION_NUMBER
,      STATUS
,      STATUS_MEANING
,      ABSOLUTE_PRICE
,      BOOKING_PERSON_ID
,      BOOKING_PLACED_BY
,      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
,      ROLE_TO_PLAY_MEANING
,      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
,      INVOICE_CURRENCY_CODE
,      INVOICE_MONEY_AMOUNT
,      FINANCE_HEADER_ID
,      FINANCE_LINE_ID
,      FINANCE_LINE_TRANSFER
,      FINANCE_LINE_OVN
,      EVT_TRAINING_CENTER_ID
,      EVT_LOCATION_ID
,      OFF_LANGUAGE_CODE
,      RES_TRAINING_CENTER_ID
,      RES_LOCATION_ID
,      RES_TRAINER_ID
,      DISPLAY_TO_LEARNER_FLAG
,      BOOK_ENTIRE_PERIOD_FLAG
,      FORUM_ID
,      CHAT_ID
,      TIMEZONE_CODE
FROM APPS.OTA_RESOURCE_BOOKINGS_V;

Dependencies

[top of page]

APPS.OTA_RESOURCE_BOOKINGS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_USER; HR_API - show dependent code; HR_GENERAL - show dependent code; HR_LOOKUPS; OTA_ACTIVITY_VERSIONS_TL; OTA_EVENTS; OTA_EVENTS_TL; OTA_FINANCE_LINES; OTA_OFFERINGS; OTA_RESOURCE_BOOKINGS; OTA_SUPPLIABLE_RESOURCES; OTA_SUPPLIABLE_RESOURCES_TL; PO_VENDORS

APPS.OTA_RESOURCE_BOOKINGS_V is referenced by following:

PUBLIC: OTA_RESOURCE_BOOKINGS_V