[Home] [Help] [Dependency Information]
Object Name: | OTA_PRICE_LIST_ENTRIES |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_PRICE_LIST_ENTRIES |
Subobject Name: | |
Status: | VALID |
You can define a price list as a per student price. If you do, the
amount is the charge made for each student who enrolls on the event.
Alternatively, you can define the price list as a per customer price.
Then, the amount is the charge made to the customer if they enroll any
number of students within the student range.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_PRICE_LIST_ENTRIES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PRICE_LIST_ENTRY_ID |
OTA_PRICE_LIST_ENTRIES_UK2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ACTIVITY_VERSION_ID
START_DATE PRICE_LIST_ID VENDOR_SUPPLY_ID PRICE_BASIS MINIMUM_ATTENDEES |
OTA_PRICE_LIST_ENTRIES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VENDOR_SUPPLY_ID |
OTA_PRICE_LIST_ENTRIES_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRICE_LIST_ID |
Table | |
Foreign Table | Foreign Key Column | OTA_PRICE_LIST_ENTRIES | OTA_ACTIVITY_VERSIONS | OTA_PRICE_LIST_ENTRIES ACTIVITY_VERSION_ID | OTA_PRICE_LIST_ENTRIES | OTA_PRICE_LISTS | OTA_PRICE_LIST_ENTRIES PRICE_LIST_ID | OTA_PRICE_LIST_ENTRIES | OTA_VENDOR_SUPPLIES | OTA_PRICE_LIST_ENTRIES VENDOR_SUPPLY_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRICE_LIST_ENTRY_ID | NUMBER | (9) | Yes | System generated surrogate key |
VENDOR_SUPPLY_ID | NUMBER | (9) | Foreign key to OTA_VENDOR_SUPPLIES | |
ACTIVITY_VERSION_ID | NUMBER | (9) | Foreign key to OTA_ACTIVITY_VERSIONS | |
PRICE_LIST_ID | NUMBER | (9) | Yes | Foreign key to OTA_PRICE_LISTS |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Version control parameter |
PRICE | NUMBER | Yes | The standard price per delegate | |
PRICE_BASIS | VARCHAR2 | (30) | Yes | Defines whether the entry is for a delegate or customer |
START_DATE | DATE | Yes | The date this price detail becomes valid | |
COMMENTS | VARCHAR2 | (2000) | Comments about the price list entry | |
END_DATE | DATE | The last day on which this price detail is valid | ||
MAXIMUM_ATTENDEES | NUMBER | (9) | The max number of delegates for the price on a basis of Customer. | |
MINIMUM_ATTENDEES | NUMBER | (9) | The min number of delegates for the price on a basis of Customer. | |
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 | ||
PLE_INFORMATION_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
PLE_INFORMATION1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION16 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION17 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION18 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION19 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PLE_INFORMATION20 | VARCHAR2 | (150) | Descriptive flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_LIST_ENTRY_ID
, VENDOR_SUPPLY_ID
, ACTIVITY_VERSION_ID
, PRICE_LIST_ID
, OBJECT_VERSION_NUMBER
, PRICE
, PRICE_BASIS
, START_DATE
, COMMENTS
, END_DATE
, MAXIMUM_ATTENDEES
, MINIMUM_ATTENDEES
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, PLE_INFORMATION_CATEGORY
, PLE_INFORMATION1
, PLE_INFORMATION2
, PLE_INFORMATION3
, PLE_INFORMATION4
, PLE_INFORMATION5
, PLE_INFORMATION6
, PLE_INFORMATION7
, PLE_INFORMATION8
, PLE_INFORMATION9
, PLE_INFORMATION10
, PLE_INFORMATION11
, PLE_INFORMATION12
, PLE_INFORMATION13
, PLE_INFORMATION14
, PLE_INFORMATION15
, PLE_INFORMATION16
, PLE_INFORMATION17
, PLE_INFORMATION18
, PLE_INFORMATION19
, PLE_INFORMATION20
FROM OTA.OTA_PRICE_LIST_ENTRIES;
OTA.OTA_PRICE_LIST_ENTRIES does not reference any database object
OTA.OTA_PRICE_LIST_ENTRIES is referenced by following:
|
|
|