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


VIEW: APPS.OTA_TRAINING_PLAN_BUDGETS_V

Object Details
Object Name: OTA_TRAINING_PLAN_BUDGETS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOTA.OTA_TRAINING_PLAN_BUDGETS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TRAINING_PLAN_ID NUMBER (9)
MEASURE_CODE VARCHAR2 (30)
MEASURE_NAME VARCHAR2 (80)
MEASURE_UNIT VARCHAR2 (30)
MEASURE_UNIT_NAME VARCHAR2 (80)
BUDGET_LEVEL VARCHAR2 (30)
MANY_BUDGET_VALUES_FLAG VARCHAR2 (30)
BUDGET_ID NUMBER (15)
PERIOD_SET_NAME VARCHAR2 (30)
BUSINESS_GROUP_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER (15)
BUDGET_ELEMENT_ID NUMBER (15)
BUDGET_VALUE_ID NUMBER (15)
VALUE NUMBER (22)
MEASURE_BUDGET_LEVEL VARCHAR2 (11)
MEMBER_LEVEL VARCHAR2 (19)
TRAINING_PLAN_MEMBER_ID NUMBER

TRAINING_PLAN_MEMBER_NAME VARCHAR2 (240)
ACTIVITY_DEFINITION_ID NUMBER

ACTIVITY_VERSION_ID NUMBER

EVENT_ID NUMBER

EVENT_NAME VARCHAR2 (80)
COURSE_START_DATE DATE

COURSE_END_DATE DATE

INFORMATION_CATEGORY VARCHAR2 (30)
BUDGET_INFORMATION1 VARCHAR2 (150)
BUDGET_INFORMATION2 VARCHAR2 (150)
BUDGET_INFORMATION3 VARCHAR2 (150)
BUDGET_INFORMATION4 VARCHAR2 (150)
BUDGET_INFORMATION5 VARCHAR2 (150)
BUDGET_INFORMATION6 VARCHAR2 (150)
BUDGET_INFORMATION7 VARCHAR2 (150)
BUDGET_INFORMATION8 VARCHAR2 (150)
BUDGET_INFORMATION9 VARCHAR2 (150)
BUDGET_INFORMATION10 VARCHAR2 (150)
BUDGET_INFORMATION11 VARCHAR2 (150)
BUDGET_INFORMATION12 VARCHAR2 (150)
BUDGET_INFORMATION13 VARCHAR2 (150)
BUDGET_INFORMATION14 VARCHAR2 (150)
BUDGET_INFORMATION15 VARCHAR2 (150)
BUDGET_INFORMATION16 VARCHAR2 (150)
BUDGET_INFORMATION17 VARCHAR2 (150)
BUDGET_INFORMATION18 VARCHAR2 (150)
BUDGET_INFORMATION19 VARCHAR2 (150)
BUDGET_INFORMATION20 VARCHAR2 (150)
BUDGET_INFORMATION21 VARCHAR2 (150)
BUDGET_INFORMATION22 VARCHAR2 (150)
BUDGET_INFORMATION23 VARCHAR2 (150)
BUDGET_INFORMATION24 VARCHAR2 (150)
BUDGET_INFORMATION25 VARCHAR2 (150)
BUDGET_INFORMATION26 VARCHAR2 (150)
BUDGET_INFORMATION27 VARCHAR2 (150)
BUDGET_INFORMATION28 VARCHAR2 (150)
BUDGET_INFORMATION29 VARCHAR2 (150)
BUDGET_INFORMATION30 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT ROW_ID
,      TRAINING_PLAN_ID
,      MEASURE_CODE
,      MEASURE_NAME
,      MEASURE_UNIT
,      MEASURE_UNIT_NAME
,      BUDGET_LEVEL
,      MANY_BUDGET_VALUES_FLAG
,      BUDGET_ID
,      PERIOD_SET_NAME
,      BUSINESS_GROUP_ID
,      BUDGET_VERSION_ID
,      BUDGET_ELEMENT_ID
,      BUDGET_VALUE_ID
,      VALUE
,      MEASURE_BUDGET_LEVEL
,      MEMBER_LEVEL
,      TRAINING_PLAN_MEMBER_ID
,      TRAINING_PLAN_MEMBER_NAME
,      ACTIVITY_DEFINITION_ID
,      ACTIVITY_VERSION_ID
,      EVENT_ID
,      EVENT_NAME
,      COURSE_START_DATE
,      COURSE_END_DATE
,      INFORMATION_CATEGORY
,      BUDGET_INFORMATION1
,      BUDGET_INFORMATION2
,      BUDGET_INFORMATION3
,      BUDGET_INFORMATION4
,      BUDGET_INFORMATION5
,      BUDGET_INFORMATION6
,      BUDGET_INFORMATION7
,      BUDGET_INFORMATION8
,      BUDGET_INFORMATION9
,      BUDGET_INFORMATION10
,      BUDGET_INFORMATION11
,      BUDGET_INFORMATION12
,      BUDGET_INFORMATION13
,      BUDGET_INFORMATION14
,      BUDGET_INFORMATION15
,      BUDGET_INFORMATION16
,      BUDGET_INFORMATION17
,      BUDGET_INFORMATION18
,      BUDGET_INFORMATION19
,      BUDGET_INFORMATION20
,      BUDGET_INFORMATION21
,      BUDGET_INFORMATION22
,      BUDGET_INFORMATION23
,      BUDGET_INFORMATION24
,      BUDGET_INFORMATION25
,      BUDGET_INFORMATION26
,      BUDGET_INFORMATION27
,      BUDGET_INFORMATION28
,      BUDGET_INFORMATION29
,      BUDGET_INFORMATION30
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OTA_TRAINING_PLAN_BUDGETS_V;

Dependencies

[top of page]

APPS.OTA_TRAINING_PLAN_BUDGETS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymOTA_ACTIVITY_DEFINITIONS
SynonymOTA_ACTIVITY_VERSIONS
SynonymOTA_EVENTS
SynonymOTA_TP_MEASUREMENT_TYPES
SynonymOTA_TRAINING_PLAN_MEMBERS
SynonymPER_BUDGETS
SynonymPER_BUDGET_ELEMENTS
SynonymPER_BUDGET_VALUES
SynonymPER_BUDGET_VERSIONS
APPS.OTA_TRAINING_PLAN_BUDGETS_V is referenced by following:

SchemaPUBLIC
SynonymOTA_TRAINING_PLAN_BUDGETS_V