[Home] [Help] [Dependency Information]
Object Name: | OTA_RESOURCE_DEFINITIONS |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_RESOURCE_DEFINITIONS |
Subobject Name: | |
Status: | VALID |
Resource definitions hold the unique key flexfield combinations for
supplied resources. During setup, each resource type is associated
with a key flexfield structure that defines the combination of
segments used to uniquely identify each resource using the appropriate
key flexfield structure.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_RESOURCE_DEFINITIONS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | RESOURCE_DEFINITION_ID |
Table | |
Foreign Table | Foreign Key Column | OTA_SUPPLIABLE_RESOURCES | OTA_RESOURCE_DEFINITIONS | OTA_SUPPLIABLE_RESOURCES RESOURCE_DEFINITION_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_DEFINITION_ID | NUMBER | (15) | Yes | Key flexfield combination defining column |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Key flexfield enabled flag |
ID_FLEX_NUM | NUMBER | (15) | Yes | Identifier of flexfield structure |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Summary account flag |
END_DATE_ACTIVE | DATE | End date of the resource definition | ||
RESOURCE_NAME | VARCHAR2 | (400) | Resource name | |
SEGMENT1 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT10 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT11 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT12 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT13 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT14 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT15 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT16 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT17 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT18 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT19 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT2 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT20 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT3 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT4 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT5 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT6 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT7 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT8 | VARCHAR2 | (80) | Key flexfield segment | |
SEGMENT9 | VARCHAR2 | (80) | Key flexfield segment | |
START_DATE_ACTIVE | DATE | Start Date of the resource definition | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_DEFINITION_ID
, ENABLED_FLAG
, ID_FLEX_NUM
, SUMMARY_FLAG
, END_DATE_ACTIVE
, RESOURCE_NAME
, SEGMENT1
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT2
, SEGMENT20
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, START_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM OTA.OTA_RESOURCE_DEFINITIONS;
OTA.OTA_RESOURCE_DEFINITIONS does not reference any database object
OTA.OTA_RESOURCE_DEFINITIONS is referenced by following:
|
|
|