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]

TABLE: OTA.OTA_RESOURCE_DEFINITIONS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_RESOURCE_DEFINITIONS_PK

RESOURCE_DEFINITION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_RESOURCE_DEFINITIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_DEFINITION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_SUPPLIABLE_RESOURCES		OTA_RESOURCE_DEFINITIONS	OTA_SUPPLIABLE_RESOURCES RESOURCE_DEFINITION_ID

Columns

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

Query Text

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;

Dependencies

[top of page]

OTA.OTA_RESOURCE_DEFINITIONS does not reference any database object

OTA.OTA_RESOURCE_DEFINITIONS is referenced by following:

APPS: OTA_RESOURCE_DEFINITIONS; OTA_RESOURCE_DEFINITIONS_WHO