eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OTA.OTA_PRICE_LIST_ENTRIES#

Source

View Text - Preformatted


select PRICE_LIST_ENTRY_ID PRICE_LIST_ENTRY_ID, VENDOR_SUPPLY_ID VENDOR_SUPPLY_ID, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID, PRICE_LIST_ID PRICE_LIST_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PRICE PRICE, PRICE_BASIS PRICE_BASIS, START_DATE START_DATE, COMMENTS COMMENTS, END_DATE END_DATE, MAXIMUM_ATTENDEES MAXIMUM_ATTENDEES, MINIMUM_ATTENDEES MINIMUM_ATTENDEES, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, PLE_INFORMATION_CATEGORY PLE_INFORMATION_CATEGORY, PLE_INFORMATION1 PLE_INFORMATION1, PLE_INFORMATION2 PLE_INFORMATION2, PLE_INFORMATION3 PLE_INFORMATION3, PLE_INFORMATION4 PLE_INFORMATION4, PLE_INFORMATION5 PLE_INFORMATION5, PLE_INFORMATION6 PLE_INFORMATION6, PLE_INFORMATION7 PLE_INFORMATION7, PLE_INFORMATION8 PLE_INFORMATION8, PLE_INFORMATION9 PLE_INFORMATION9, PLE_INFORMATION10 PLE_INFORMATION10, PLE_INFORMATION11 PLE_INFORMATION11, PLE_INFORMATION12 PLE_INFORMATION12, PLE_INFORMATION13 PLE_INFORMATION13, PLE_INFORMATION14 PLE_INFORMATION14, PLE_INFORMATION15 PLE_INFORMATION15, PLE_INFORMATION16 PLE_INFORMATION16, PLE_INFORMATION17 PLE_INFORMATION17, PLE_INFORMATION18 PLE_INFORMATION18, PLE_INFORMATION19 PLE_INFORMATION19, PLE_INFORMATION20 PLE_INFORMATION20 from "OTA"."OTA_PRICE_LIST_ENTRIES"

View Text - HTML Formatted

SELECT PRICE_LIST_ENTRY_ID PRICE_LIST_ENTRY_ID
, VENDOR_SUPPLY_ID VENDOR_SUPPLY_ID
, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, PRICE_LIST_ID PRICE_LIST_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRICE PRICE
, PRICE_BASIS PRICE_BASIS
, START_DATE START_DATE
, COMMENTS COMMENTS
, END_DATE END_DATE
, MAXIMUM_ATTENDEES MAXIMUM_ATTENDEES
, MINIMUM_ATTENDEES MINIMUM_ATTENDEES
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, PLE_INFORMATION_CATEGORY PLE_INFORMATION_CATEGORY
, PLE_INFORMATION1 PLE_INFORMATION1
, PLE_INFORMATION2 PLE_INFORMATION2
, PLE_INFORMATION3 PLE_INFORMATION3
, PLE_INFORMATION4 PLE_INFORMATION4
, PLE_INFORMATION5 PLE_INFORMATION5
, PLE_INFORMATION6 PLE_INFORMATION6
, PLE_INFORMATION7 PLE_INFORMATION7
, PLE_INFORMATION8 PLE_INFORMATION8
, PLE_INFORMATION9 PLE_INFORMATION9
, PLE_INFORMATION10 PLE_INFORMATION10
, PLE_INFORMATION11 PLE_INFORMATION11
, PLE_INFORMATION12 PLE_INFORMATION12
, PLE_INFORMATION13 PLE_INFORMATION13
, PLE_INFORMATION14 PLE_INFORMATION14
, PLE_INFORMATION15 PLE_INFORMATION15
, PLE_INFORMATION16 PLE_INFORMATION16
, PLE_INFORMATION17 PLE_INFORMATION17
, PLE_INFORMATION18 PLE_INFORMATION18
, PLE_INFORMATION19 PLE_INFORMATION19
, PLE_INFORMATION20 PLE_INFORMATION20
FROM "OTA"."OTA_PRICE_LIST_ENTRIES"