DBA Data[Home] [Help] [Dependency Information]

TABLE: OTA.OTA_TRAINING_PLAN_COSTS

Object Details
Object Name: OTA_TRAINING_PLAN_COSTS
Object Type: TABLE
Owner: OTA
FND Design Data: TableOTA.OTA_TRAINING_PLAN_COSTS
Subobject Name:
Status: VALID


A plan cost is a recorded measure against the training plan.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: OTA_TRAINING_PLAN_COSTS_PK
  1. ColumnTRAINING_PLAN_COST_ID
Unique Key: OTA_TRAINING_PLAN_COSTS_UK2
  1. ColumnBOOKING_ID
  2. ColumnTRAINING_PLAN_ID
  3. ColumnTP_MEASUREMENT_TYPE_ID
  4. ColumnEVENT_ID
Indexes
Index Type Uniqueness Tablespace Column
OTA_TRAINING_PLAN_COSTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRAINING_PLAN_COST_ID
OTA_TRAINING_PLAN_COSTS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOOKING_ID
ColumnTRAINING_PLAN_ID
ColumnTP_MEASUREMENT_TYPE_ID
ColumnEVENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OTA_TRAINING_PLAN_COSTS OTA_TRAINING_PLAN_COSTS_FK3 TableOTA_DELEGATE_BOOKINGS OTA_TRAINING_PLAN_COSTS BOOKING_ID
OTA_TRAINING_PLAN_COSTS OTA_TRAINING_PLAN_COSTS_FK4 TableOTA_EVENTS OTA_TRAINING_PLAN_COSTS EVENT_ID
OTA_TRAINING_PLAN_COSTS OTA_TRAINING_PLAN_COSTS_FK1 TableOTA_TP_MEASUREMENT_TYPES OTA_TRAINING_PLAN_COSTS TP_MEASUREMENT_TYPE_ID
OTA_TRAINING_PLAN_COSTS OTA_TRAINING_PLAN_COSTS_FK2 TableOTA_TRAINING_PLANS OTA_TRAINING_PLAN_COSTS TRAINING_PLAN_ID
Columns
Name Datatype Length Mandatory Comments
TRAINING_PLAN_COST_ID NUMBER (9) Yes The system generated primary key for this module.
TP_MEASUREMENT_TYPE_ID NUMBER (9) Yes Foreign key to OTA_TP_MEASUREMENT_TYPES.
TRAINING_PLAN_ID NUMBER (9) Yes Foreign key to OTA_TRAINING_PLANS.
BOOKING_ID NUMBER (9)
Foreign key to OTA_DELEGATE_BOOKINGS
EVENT_ID NUMBER (9)
Foreign key to OTA_EVENTS.
AMOUNT NUMBER (15) Yes The value of the measured item.
CURRENCY_CODE VARCHAR2 (15)
The currency of the monetary value.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATIONS.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Version number of the row. Increments by one with each update.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
INFORMATION_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
TP_COST_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION21 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION22 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION23 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION24 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION25 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION26 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION27 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION28 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION29 VARCHAR2 (150)
Developer descriptive flexfield column.
TP_COST_INFORMATION30 VARCHAR2 (150)
Developer descriptive flexfield column.
CREATED_BY NUMBER (15) Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRAINING_PLAN_COST_ID
,      TP_MEASUREMENT_TYPE_ID
,      TRAINING_PLAN_ID
,      BOOKING_ID
,      EVENT_ID
,      AMOUNT
,      CURRENCY_CODE
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      INFORMATION_CATEGORY
,      TP_COST_INFORMATION1
,      TP_COST_INFORMATION2
,      TP_COST_INFORMATION3
,      TP_COST_INFORMATION4
,      TP_COST_INFORMATION5
,      TP_COST_INFORMATION6
,      TP_COST_INFORMATION7
,      TP_COST_INFORMATION8
,      TP_COST_INFORMATION9
,      TP_COST_INFORMATION10
,      TP_COST_INFORMATION11
,      TP_COST_INFORMATION12
,      TP_COST_INFORMATION13
,      TP_COST_INFORMATION14
,      TP_COST_INFORMATION15
,      TP_COST_INFORMATION16
,      TP_COST_INFORMATION17
,      TP_COST_INFORMATION18
,      TP_COST_INFORMATION19
,      TP_COST_INFORMATION20
,      TP_COST_INFORMATION21
,      TP_COST_INFORMATION22
,      TP_COST_INFORMATION23
,      TP_COST_INFORMATION24
,      TP_COST_INFORMATION25
,      TP_COST_INFORMATION26
,      TP_COST_INFORMATION27
,      TP_COST_INFORMATION28
,      TP_COST_INFORMATION29
,      TP_COST_INFORMATION30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OTA.OTA_TRAINING_PLAN_COSTS;

Dependencies

[top of page]

OTA.OTA_TRAINING_PLAN_COSTS does not reference any database object

OTA.OTA_TRAINING_PLAN_COSTS is referenced by following:

SchemaAPPS
SynonymOTA_TRAINING_PLAN_COSTS
TriggerOTA_TRAINING_PLAN_COSTS_WHO