[Home] [Help] [Dependency Information]
Object Name: | OTA_RESOURCE_USAGES |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_RESOURCE_USAGES |
Subobject Name: | |
Status: | VALID |
A record usage holds the requirement of an activity version for a
specific supplied version, or for a resource type. In addition, it is
possible to specify whether the resource is required (the activity
cannot run without it), or optional. You canalso identify the nature
of the role for a trainer, for example, primary trainer.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_RESOURCE_USAGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | RESOURCE_USAGE_ID |
OTA_RESOURCE_USAGES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SUPPLIED_RESOURCE_ID |
OTA_RESOURCE_USAGES_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OFFERING_ID |
Table | |
Foreign Table | Foreign Key Column | OTA_RESOURCE_USAGES | OTA_SUPPLIABLE_RESOURCES | OTA_RESOURCE_USAGES SUPPLIED_RESOURCE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_USAGE_ID | NUMBER | (9) | Yes | Primary Key of RESOURCE USAGES DEFINITION |
SUPPLIED_RESOURCE_ID | NUMBER | (9) | Foreign key to OTA_SUPPLIABLE_RESOURCES | |
ACTIVITY_VERSION_ID | NUMBER | (9) | Not being used anymore | |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Version control parameter |
REQUIRED_FLAG | VARCHAR2 | (30) | Yes | Whether the Resource is required or not |
START_DATE | DATE | Yes | The date the association is valid from | |
COMMENTS | VARCHAR2 | (2000) | Free text comments | |
END_DATE | DATE | The date the association is valid to | ||
QUANTITY | NUMBER | The Quantity required for the activity | ||
RESOURCE_TYPE | VARCHAR2 | (30) | The type of resource referenced in this usage. | |
ROLE_TO_PLAY | VARCHAR2 | (30) | The associated role for a person | |
USAGE_REASON | VARCHAR2 | (30) | The Reason why the resource has been specified | |
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 | ||
RUD_INFORMATION_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
RUD_INFORMATION1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION16 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION17 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION18 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION19 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
RUD_INFORMATION20 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
OFFERING_ID | NUMBER | (9) | Foreign Key to OTA_OFFERINGS |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_USAGE_ID
, SUPPLIED_RESOURCE_ID
, ACTIVITY_VERSION_ID
, OBJECT_VERSION_NUMBER
, REQUIRED_FLAG
, START_DATE
, COMMENTS
, END_DATE
, QUANTITY
, RESOURCE_TYPE
, ROLE_TO_PLAY
, USAGE_REASON
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, RUD_INFORMATION_CATEGORY
, RUD_INFORMATION1
, RUD_INFORMATION2
, RUD_INFORMATION3
, RUD_INFORMATION4
, RUD_INFORMATION5
, RUD_INFORMATION6
, RUD_INFORMATION7
, RUD_INFORMATION8
, RUD_INFORMATION9
, RUD_INFORMATION10
, RUD_INFORMATION11
, RUD_INFORMATION12
, RUD_INFORMATION13
, RUD_INFORMATION14
, RUD_INFORMATION15
, RUD_INFORMATION16
, RUD_INFORMATION17
, RUD_INFORMATION18
, RUD_INFORMATION19
, RUD_INFORMATION20
, OFFERING_ID
FROM OTA.OTA_RESOURCE_USAGES;
OTA.OTA_RESOURCE_USAGES does not reference any database object
OTA.OTA_RESOURCE_USAGES is referenced by following:
|
|
|