[Home] [Help] [Dependency Information]
Object Name: | OTA_PRICE_LISTS |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_PRICE_LISTS |
Subobject Name: | |
Status: | VALID |
A price list contains entries that identify pricing information for
activities, between two dates. The price list can have dates
associated with it to indicate when it is valid. You can specify one
price list as the default price list at any point in time. These
default prices then appear when you create a scheduled event, or when
you enroll students for unpriced events.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_PRICE_LISTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PRICE_LIST_ID |
OTA_PRICE_LISTS_UK2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
BUSINESS_GROUP_ID |
OTA_PRICE_LISTS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Table | |
Foreign Table | Foreign Key Column | OTA_BOOKING_DEALS | OTA_PRICE_LISTS | OTA_BOOKING_DEALS PRICE_LIST_ID | OTA_PRICE_LIST_ENTRIES | OTA_PRICE_LISTS | OTA_PRICE_LIST_ENTRIES PRICE_LIST_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRICE_LIST_ID | NUMBER | (9) | Yes | The system generated key for this price list |
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS |
CURRENCY_CODE | VARCHAR2 | (30) | Yes | The currency in which the price list is defined |
DEFAULT_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the Price List is the default |
NAME | VARCHAR2 | (80) | Yes | The name of the price list |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Version control parameter |
PRICE_LIST_TYPE | VARCHAR2 | (30) | Yes | The type of Price List, T(raining Unit), or M(oney) |
START_DATE | DATE | Yes | The date on which this price list is valid | |
COMMENTS | VARCHAR2 | (2000) | Free text comments | |
DESCRIPTION | VARCHAR2 | (240) | The description of the price list | |
END_DATE | DATE | The date on which this price list becomes invalid | ||
SINGLE_UNIT_PRICE | NUMBER | (9) | The price of a single unit in the specified currency | |
TRAINING_UNIT_TYPE | VARCHAR2 | (30) | The type of unit being specified for the Prices | |
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 | ||
TPL_INFORMATION_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
TPL_INFORMATION1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION16 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION17 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION18 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION19 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
TPL_INFORMATION20 | VARCHAR2 | (150) | Descriptive flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_LIST_ID
, BUSINESS_GROUP_ID
, CURRENCY_CODE
, DEFAULT_FLAG
, NAME
, OBJECT_VERSION_NUMBER
, PRICE_LIST_TYPE
, START_DATE
, COMMENTS
, DESCRIPTION
, END_DATE
, SINGLE_UNIT_PRICE
, TRAINING_UNIT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, TPL_INFORMATION_CATEGORY
, TPL_INFORMATION1
, TPL_INFORMATION2
, TPL_INFORMATION3
, TPL_INFORMATION4
, TPL_INFORMATION5
, TPL_INFORMATION6
, TPL_INFORMATION7
, TPL_INFORMATION8
, TPL_INFORMATION9
, TPL_INFORMATION10
, TPL_INFORMATION11
, TPL_INFORMATION12
, TPL_INFORMATION13
, TPL_INFORMATION14
, TPL_INFORMATION15
, TPL_INFORMATION16
, TPL_INFORMATION17
, TPL_INFORMATION18
, TPL_INFORMATION19
, TPL_INFORMATION20
FROM OTA.OTA_PRICE_LISTS;
OTA.OTA_PRICE_LISTS does not reference any database object
OTA.OTA_PRICE_LISTS is referenced by following:
|
|
|