[Home] [Help] [Dependency Information]
Object Name: | OTA_SUPPLIABLE_RESOURCES |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_SUPPLIABLE_RESOURCES |
Subobject Name: | |
Status: | VALID |
A resource is any facility, person or equipment that you need to book
to run an event. You need to set up a key flexfield structure
during setup for each resource type required. Subsequently, you can
enter specific supplied resources that use the resource key flexfield
structure applicable to the type of resource. You can enter additional
values that are specific to venues and trainers.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_SUPPLIABLE_RESOURCES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SUPPLIED_RESOURCE_ID |
OTA_SUPPLIABLE_RESOURCES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
OTA_SUPPLIABLE_RESOURCES_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RESOURCE_DEFINITION_ID |
OTA_SUPPLIABLE_RESOURCES_N50 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VENDOR_ID |
OTA_SUPPLIABLE_RESOURCES_N51 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRAINING_CENTER_ID |
OTA_SUPPLIABLE_RESOURCES_N52 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOCATION_ID |
OTA_SUPPLIABLE_RESOURCES_N53 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRAINER_ID |
Table | |
Foreign Table | Foreign Key Column | OTA_SUPPLIABLE_RESOURCES | OTA_RESOURCE_DEFINITIONS | OTA_SUPPLIABLE_RESOURCES RESOURCE_DEFINITION_ID | OTA_RESOURCE_BOOKINGS | OTA_SUPPLIABLE_RESOURCES | OTA_RESOURCE_BOOKINGS SUPPLIED_RESOURCE_ID | OTA_RESOURCE_USAGES | OTA_SUPPLIABLE_RESOURCES | OTA_RESOURCE_USAGES SUPPLIED_RESOURCE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLIED_RESOURCE_ID | NUMBER | (9) | Yes | The surrogate key identifying a supplied resource. |
VENDOR_ID | NUMBER | (15) | Foreign key to PO_VENDORS | |
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS |
RESOURCE_DEFINITION_ID | NUMBER | (15) | Yes | Foreign key toOTA_RESOURCE_DEFINITIONS |
CONSUMABLE_FLAG | VARCHAR2 | (30) | Yes | An indication of whether the resource is a consumable |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Version control parameter |
RESOURCE_TYPE | VARCHAR2 | (30) | Yes | The type of resource defined. |
CAPACITY | NUMBER | The capacity of a room, or other resource. | ||
COMMENTS | VARCHAR2 | (2000) | Any special instructions attached to this resource supply. | |
COST | NUMBER | (9) | The normal cost of hiring this resource from this supplier. | |
COST_UNIT | VARCHAR2 | (80) | States the unit paid for by the COST. EG: item, 1 day hire etc. | |
CURRENCY_CODE | VARCHAR2 | (30) | The currency in which the normal cost is defined. | |
END_DATE | DATE | Date after which a resource can no longer be used. | ||
INTERNAL_ADDRESS_LINE | VARCHAR2 | (80) | The further address detail relating to a location | |
LEAD_TIME | NUMBER | (9) | The normal lead time when hiring from this supplier. Days (99.99) | |
NAME | VARCHAR2 | (400) | The name by which this resource is referred to internally. | |
START_DATE | DATE | Date before which a resource can no longer be used. | ||
SUPPLIER_REFERENCE | VARCHAR2 | (80) | The name by which the supplier will recognize this resource. | |
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 | ||
TSR_INFORMATION_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
TSR_INFORMATION1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION16 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION17 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION18 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION19 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TSR_INFORMATION20 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TRAINING_CENTER_ID | NUMBER | (15) | Foriegn key to HR_ALL_ORGANIZATION_UNITS. | |
LOCATION_ID | NUMBER | (15) | Foriegn key to HR_LOCATIONS. | |
TRAINER_ID | NUMBER | (10) | Foriegn key to PER_ALL_PEOPLE_F. | |
SPECIAL_INSTRUCTION | VARCHAR2 | (2000) | Special Instruction. |
Cut, paste (and edit) the following text to query this object:
SELECT SUPPLIED_RESOURCE_ID
, VENDOR_ID
, BUSINESS_GROUP_ID
, RESOURCE_DEFINITION_ID
, CONSUMABLE_FLAG
, OBJECT_VERSION_NUMBER
, RESOURCE_TYPE
, CAPACITY
, COMMENTS
, COST
, COST_UNIT
, CURRENCY_CODE
, END_DATE
, INTERNAL_ADDRESS_LINE
, LEAD_TIME
, NAME
, START_DATE
, SUPPLIER_REFERENCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, TSR_INFORMATION_CATEGORY
, TSR_INFORMATION1
, TSR_INFORMATION2
, TSR_INFORMATION3
, TSR_INFORMATION4
, TSR_INFORMATION5
, TSR_INFORMATION6
, TSR_INFORMATION7
, TSR_INFORMATION8
, TSR_INFORMATION9
, TSR_INFORMATION10
, TSR_INFORMATION11
, TSR_INFORMATION12
, TSR_INFORMATION13
, TSR_INFORMATION14
, TSR_INFORMATION15
, TSR_INFORMATION16
, TSR_INFORMATION17
, TSR_INFORMATION18
, TSR_INFORMATION19
, TSR_INFORMATION20
, TRAINING_CENTER_ID
, LOCATION_ID
, TRAINER_ID
, SPECIAL_INSTRUCTION
FROM OTA.OTA_SUPPLIABLE_RESOURCES;
OTA.OTA_SUPPLIABLE_RESOURCES does not reference any database object
OTA.OTA_SUPPLIABLE_RESOURCES is referenced by following:
|
|
|