[Home] [Help] [Dependency Information]
Object Name: | OTFV_RESOURCES_BOOKED |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_RESOURCES_BOOKED |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows the data of Booked Resources for an Event
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
BOOKING_STATUS | VARCHAR2 | (4000) | ||
BOOKING_DATE | DATE | Yes | ||
DELIVERY_CONTACT | VARCHAR2 | (80) | ||
DELIVERY_TELEPHONE | VARCHAR2 | (80) | ||
DELIVERY_LOCATION | VARCHAR2 | (2000) | ||
MAXIMUM_USAGE | NUMBER | (9) | ||
QUANTITY | NUMBER | (9) | ||
REQUIRED_FROM | DATE | |||
REQUIRED_TO | DATE | |||
SESSION_TIME_FROM | VARCHAR2 | (5) | ||
SESSION_TIME_TO | VARCHAR2 | (5) | ||
PRIMARY_VENUE | VARCHAR2 | (4000) | ||
TRAINER_ROLE | VARCHAR2 | (4000) | ||
RESOURCE_BOOKING_COMMENTS | VARCHAR2 | (2000) | A free text field for any special instructions | |
BOOKED_BY | VARCHAR2 | (100) | ||
RESOURCE_TYPE | VARCHAR2 | (4000) | ||
CAPACITY | NUMBER | |||
RESOURCE_NAME | VARCHAR2 | (400) | ||
CONSUMABLE | VARCHAR2 | (4000) | ||
COST_AMOUNT | NUMBER | (9) | ||
COST_UNIT | VARCHAR2 | (80) | ||
COST_CURRENCY | VARCHAR2 | (4000) | ||
LEAD_TIME | NUMBER | (9) | ||
RESOURCE_AVAILABLE_FROM | DATE | |||
RESOURCE_AVAILABLE_TO | DATE | |||
INTERNAL_ADDRESS | VARCHAR2 | (80) | ||
SUPPLIER_REFERENCE | VARCHAR2 | (80) | ||
SUPPLIABLE_RESOURCE_COMMENTS | VARCHAR2 | (2000) | Any special instructions attached to this resource supply. | |
SUPPLIER_NAME | VARCHAR2 | (240) | ||
EVENT_TITLE | VARCHAR2 | (80) | ||
EVENT_FROM | DATE | |||
EVENT_TO | DATE | |||
EVENT_CENTER | VARCHAR2 | (240) | ||
ACTIVITY_NAME | VARCHAR2 | (80) | ||
ACTIVITY_TYPE | VARCHAR2 | (240) | ||
CATEGORY_NAME | VARCHAR2 | (240) | ||
INVOICE_AMOUNT | NUMBER | |||
INVOICE_CURRENCY | VARCHAR2 | (4000) | ||
FINANCE_LINE | NUMBER | (9) | ||
FINANCE_HEADER | NUMBER | (9) | ||
_KF:RESOURCE_DEFINITION | CHAR | (15) | ||
_DF | CHAR | (33) | ||
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
VENDOR_ID | NUMBER | |||
EVENT_ID | NUMBER | (9) | ||
ACTIVITY_VERSION_ID | NUMBER | (9) | ||
ACTIVITY_ID | NUMBER | (9) | ||
BOOKING_PERSON_ID | NUMBER | (10) | ||
SUPPLIED_RESOURCE_ID | NUMBER | (9) | Yes | |
RESOURCE_BOOKING_ID | NUMBER | (9) | Yes | |
TRAINING_CENTER_ID | NUMBER | (15) | ||
RCO_ID | NUMBER | |||
OFFERING_ID | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, BOOKING_STATUS
, BOOKING_DATE
, DELIVERY_CONTACT
, DELIVERY_TELEPHONE
, DELIVERY_LOCATION
, MAXIMUM_USAGE
, QUANTITY
, REQUIRED_FROM
, REQUIRED_TO
, SESSION_TIME_FROM
, SESSION_TIME_TO
, PRIMARY_VENUE
, TRAINER_ROLE
, RESOURCE_BOOKING_COMMENTS
, BOOKED_BY
, RESOURCE_TYPE
, CAPACITY
, RESOURCE_NAME
, CONSUMABLE
, COST_AMOUNT
, COST_UNIT
, COST_CURRENCY
, LEAD_TIME
, RESOURCE_AVAILABLE_FROM
, RESOURCE_AVAILABLE_TO
, INTERNAL_ADDRESS
, SUPPLIER_REFERENCE
, SUPPLIABLE_RESOURCE_COMMENTS
, SUPPLIER_NAME
, EVENT_TITLE
, EVENT_FROM
, EVENT_TO
, EVENT_CENTER
, ACTIVITY_NAME
, ACTIVITY_TYPE
, CATEGORY_NAME
, INVOICE_AMOUNT
, INVOICE_CURRENCY
, FINANCE_LINE
, FINANCE_HEADER
, _KF:RESOURCE_DEFINITION
, _DF
, BUSINESS_GROUP_ID
, VENDOR_ID
, EVENT_ID
, ACTIVITY_VERSION_ID
, ACTIVITY_ID
, BOOKING_PERSON_ID
, SUPPLIED_RESOURCE_ID
, RESOURCE_BOOKING_ID
, TRAINING_CENTER_ID
, RCO_ID
, OFFERING_ID
FROM APPS.OTFV_RESOURCES_BOOKED;
APPS.OTFV_RESOURCES_BOOKED is not referenced by any database object
|
|
|