[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OTA_EVENT_SEARCH_V2 |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OTA.OTA_EVENT_SEARCH_V2
|
| Subobject Name: | |
| Status: | VALID |
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| EVENT_ID | NUMBER | (9) | Yes | |
| OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
| TITLE | VARCHAR2 | (80) | Yes | |
| COURSE_START_DATE | DATE | |||
| COURSE_START_TIME | VARCHAR2 | (5) | ||
| COURSE_END_DATE | DATE | |||
| COURSE_END_TIME | VARCHAR2 | (5) | ||
| WEEK_NUMBER | VARCHAR2 | (2) | ||
| DURATION | NUMBER | |||
| ENROLMENT_START_DATE | DATE | |||
| ENROLMENT_END_DATE | DATE | |||
| PUBLIC_EVENT_FLAG | VARCHAR2 | (30) | ||
| MINIMUM_ATTENDEES | NUMBER | (9) | ||
| MAXIMUM_ATTENDEES | NUMBER | (9) | ||
| MAXIMUM_INTERNAL_ATTENDEES | NUMBER | (9) | ||
| STANDARD_PRICE | NUMBER | |||
| PARENT_EVENT_ID | NUMBER | (9) | ||
| BOOK_INDEPENDENT_FLAG | VARCHAR2 | (30) | ||
| ACTUAL_COST | NUMBER | |||
| BUDGET_COST | NUMBER | |||
| BUDGET_CURRENCY_CODE | VARCHAR2 | (30) | ||
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| LAST_UPDATE_DATE | DATE | |||
| COMMENTS | VARCHAR2 | (2000) | ||
| SECURE_EVENT_FLAG | VARCHAR2 | (30) | ||
| EVT_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
| EVT_INFORMATION1 | VARCHAR2 | (150) | ||
| EVT_INFORMATION2 | VARCHAR2 | (150) | ||
| EVT_INFORMATION3 | VARCHAR2 | (150) | ||
| EVT_INFORMATION4 | VARCHAR2 | (150) | ||
| EVT_INFORMATION5 | VARCHAR2 | (150) | ||
| EVT_INFORMATION6 | VARCHAR2 | (150) | ||
| EVT_INFORMATION7 | VARCHAR2 | (150) | ||
| EVT_INFORMATION8 | VARCHAR2 | (150) | ||
| EVT_INFORMATION9 | VARCHAR2 | (150) | ||
| EVT_INFORMATION10 | VARCHAR2 | (150) | ||
| EVT_INFORMATION11 | VARCHAR2 | (150) | ||
| EVT_INFORMATION12 | VARCHAR2 | (150) | ||
| EVT_INFORMATION13 | VARCHAR2 | (150) | ||
| EVT_INFORMATION14 | VARCHAR2 | (150) | ||
| EVT_INFORMATION15 | VARCHAR2 | (150) | ||
| EVT_INFORMATION16 | VARCHAR2 | (150) | ||
| EVT_INFORMATION17 | VARCHAR2 | (150) | ||
| EVT_INFORMATION18 | VARCHAR2 | (150) | ||
| EVT_INFORMATION19 | VARCHAR2 | (150) | ||
| EVT_INFORMATION20 | VARCHAR2 | (150) | ||
| ORGANIZATION_ID | NUMBER | (15) | ||
| ORGANIZATION_NAME | VARCHAR2 | (240) | ||
| CENTRE | VARCHAR2 | (30) | ||
| CENTRE_MEANING | VARCHAR2 | (4000) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| CURRENCY_NAME | VARCHAR2 | (80) | ||
| DEVELOPMENT_EVENT_TYPE | VARCHAR2 | (30) | ||
| DEVELOPMENT_EVENT_TYPE_MEANING | VARCHAR2 | (4000) | ||
| DURATION_UNITS | VARCHAR2 | (30) | ||
| DURATION_UNITS_MEANING | VARCHAR2 | (4000) | ||
| LANGUAGE_CODE | VARCHAR2 | (30) | ||
| LANGUAGE_DESCRIPTION | VARCHAR2 | (4000) | ||
| PRICE_BASIS | VARCHAR2 | (30) | ||
| PRICE_BASIS_MEANING | VARCHAR2 | (4000) | ||
| PROGRAMME_CODE | VARCHAR2 | (30) | ||
| PROGRAMME_CODE_MEANING | VARCHAR2 | (4000) | ||
| EVENT_STATUS | VARCHAR2 | (30) | ||
| EVENT_STATUS_MEANING | VARCHAR2 | (4000) | ||
| ACTIVITY_VERSION_ID | NUMBER | (9) | Yes | |
| ACTIVITY_VERSION_NAME | VARCHAR2 | (80) | Yes | |
| EVENT_TYPE | VARCHAR2 | (30) | Yes | |
| EVENT_TYPE_MEANING | VARCHAR2 | (4000) | ||
| INVOICED_AMOUNT | NUMBER | |||
| USER_STATUS | VARCHAR2 | (80) | ||
| USER_STATUS_MEANING | VARCHAR2 | (4000) | ||
| VENDOR_ID | NUMBER | |||
| VENDOR_NAME | VARCHAR2 | (240) | ||
| PARENT_EVENT_TITLE | VARCHAR2 | (80) | ||
| PRIMARY_VENUE | VARCHAR2 | (400) | ||
| PROGRAM_TITLE | VARCHAR2 | (80) | ||
| SEARCH_FIELD | CHAR | (1) | ||
| REQUIRED_FLAG | VARCHAR2 | (30) | ||
| INVENTORY_ITEM_ID | NUMBER | (10) | ||
| INV_ORGANIZATION_ID | NUMBER | (15) | ||
| LINE_ID | NUMBER | (15) | ||
| ORG_ID | NUMBER | (15) | ||
| OWNER_ID | NUMBER | (10) | ||
| TRAINING_CENTER_ID | NUMBER | (15) | ||
| LOCATION_ID | NUMBER | (15) | ||
| PARENT_OFFERING_ID | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, EVENT_ID
, OBJECT_VERSION_NUMBER
, BUSINESS_GROUP_ID
, TITLE
, COURSE_START_DATE
, COURSE_START_TIME
, COURSE_END_DATE
, COURSE_END_TIME
, WEEK_NUMBER
, DURATION
, ENROLMENT_START_DATE
, ENROLMENT_END_DATE
, PUBLIC_EVENT_FLAG
, MINIMUM_ATTENDEES
, MAXIMUM_ATTENDEES
, MAXIMUM_INTERNAL_ATTENDEES
, STANDARD_PRICE
, PARENT_EVENT_ID
, BOOK_INDEPENDENT_FLAG
, ACTUAL_COST
, BUDGET_COST
, BUDGET_CURRENCY_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, COMMENTS
, SECURE_EVENT_FLAG
, EVT_INFORMATION_CATEGORY
, EVT_INFORMATION1
, EVT_INFORMATION2
, EVT_INFORMATION3
, EVT_INFORMATION4
, EVT_INFORMATION5
, EVT_INFORMATION6
, EVT_INFORMATION7
, EVT_INFORMATION8
, EVT_INFORMATION9
, EVT_INFORMATION10
, EVT_INFORMATION11
, EVT_INFORMATION12
, EVT_INFORMATION13
, EVT_INFORMATION14
, EVT_INFORMATION15
, EVT_INFORMATION16
, EVT_INFORMATION17
, EVT_INFORMATION18
, EVT_INFORMATION19
, EVT_INFORMATION20
, ORGANIZATION_ID
, ORGANIZATION_NAME
, CENTRE
, CENTRE_MEANING
, CURRENCY_CODE
, CURRENCY_NAME
, DEVELOPMENT_EVENT_TYPE
, DEVELOPMENT_EVENT_TYPE_MEANING
, DURATION_UNITS
, DURATION_UNITS_MEANING
, LANGUAGE_CODE
, LANGUAGE_DESCRIPTION
, PRICE_BASIS
, PRICE_BASIS_MEANING
, PROGRAMME_CODE
, PROGRAMME_CODE_MEANING
, EVENT_STATUS
, EVENT_STATUS_MEANING
, ACTIVITY_VERSION_ID
, ACTIVITY_VERSION_NAME
, EVENT_TYPE
, EVENT_TYPE_MEANING
, INVOICED_AMOUNT
, USER_STATUS
, USER_STATUS_MEANING
, VENDOR_ID
, VENDOR_NAME
, PARENT_EVENT_TITLE
, PRIMARY_VENUE
, PROGRAM_TITLE
, SEARCH_FIELD
, REQUIRED_FLAG
, INVENTORY_ITEM_ID
, INV_ORGANIZATION_ID
, LINE_ID
, ORG_ID
, OWNER_ID
, TRAINING_CENTER_ID
, LOCATION_ID
, PARENT_OFFERING_ID
FROM APPS.OTA_EVENT_SEARCH_V2;
APPS
FND_CURRENCIES_VL
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
OTA_ACTIVITY_VERSIONS
OTA_ACTIVITY_VERSIONS_TL
OTA_EVENTS
OTA_EVENTS_TL
OTA_EVT_SHD
- show dependent code
OTA_OFFERINGS_VL
OTA_PROGRAM_MEMBERSHIPS
OTA_RESOURCE_BOOKINGS
OTA_SUPPLIABLE_RESOURCES_TL
OTA_UTILITY
- show dependent code
PO_VENDORS
APPS.OTA_EVENT_SEARCH_V2 is not referenced by any database object
|
|
|
|