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_LISTS#

Source

View Text - Preformatted


select PRICE_LIST_ID PRICE_LIST_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CURRENCY_CODE CURRENCY_CODE, DEFAULT_FLAG DEFAULT_FLAG, NAME NAME, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PRICE_LIST_TYPE PRICE_LIST_TYPE, START_DATE START_DATE, COMMENTS COMMENTS, DESCRIPTION DESCRIPTION, END_DATE END_DATE, SINGLE_UNIT_PRICE SINGLE_UNIT_PRICE, TRAINING_UNIT_TYPE TRAINING_UNIT_TYPE, 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, TPL_INFORMATION_CATEGORY TPL_INFORMATION_CATEGORY, TPL_INFORMATION1 TPL_INFORMATION1, TPL_INFORMATION2 TPL_INFORMATION2, TPL_INFORMATION3 TPL_INFORMATION3, TPL_INFORMATION4 TPL_INFORMATION4, TPL_INFORMATION5 TPL_INFORMATION5, TPL_INFORMATION6 TPL_INFORMATION6, TPL_INFORMATION7 TPL_INFORMATION7, TPL_INFORMATION8 TPL_INFORMATION8, TPL_INFORMATION9 TPL_INFORMATION9, TPL_INFORMATION10 TPL_INFORMATION10, TPL_INFORMATION11 TPL_INFORMATION11, TPL_INFORMATION12 TPL_INFORMATION12, TPL_INFORMATION13 TPL_INFORMATION13, TPL_INFORMATION14 TPL_INFORMATION14, TPL_INFORMATION15 TPL_INFORMATION15, TPL_INFORMATION16 TPL_INFORMATION16, TPL_INFORMATION17 TPL_INFORMATION17, TPL_INFORMATION18 TPL_INFORMATION18, TPL_INFORMATION19 TPL_INFORMATION19, TPL_INFORMATION20 TPL_INFORMATION20 from "OTA"."OTA_PRICE_LISTS"

View Text - HTML Formatted

SELECT PRICE_LIST_ID PRICE_LIST_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CURRENCY_CODE CURRENCY_CODE
, DEFAULT_FLAG DEFAULT_FLAG
, NAME NAME
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRICE_LIST_TYPE PRICE_LIST_TYPE
, START_DATE START_DATE
, COMMENTS COMMENTS
, DESCRIPTION DESCRIPTION
, END_DATE END_DATE
, SINGLE_UNIT_PRICE SINGLE_UNIT_PRICE
, TRAINING_UNIT_TYPE TRAINING_UNIT_TYPE
, 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
, TPL_INFORMATION_CATEGORY TPL_INFORMATION_CATEGORY
, TPL_INFORMATION1 TPL_INFORMATION1
, TPL_INFORMATION2 TPL_INFORMATION2
, TPL_INFORMATION3 TPL_INFORMATION3
, TPL_INFORMATION4 TPL_INFORMATION4
, TPL_INFORMATION5 TPL_INFORMATION5
, TPL_INFORMATION6 TPL_INFORMATION6
, TPL_INFORMATION7 TPL_INFORMATION7
, TPL_INFORMATION8 TPL_INFORMATION8
, TPL_INFORMATION9 TPL_INFORMATION9
, TPL_INFORMATION10 TPL_INFORMATION10
, TPL_INFORMATION11 TPL_INFORMATION11
, TPL_INFORMATION12 TPL_INFORMATION12
, TPL_INFORMATION13 TPL_INFORMATION13
, TPL_INFORMATION14 TPL_INFORMATION14
, TPL_INFORMATION15 TPL_INFORMATION15
, TPL_INFORMATION16 TPL_INFORMATION16
, TPL_INFORMATION17 TPL_INFORMATION17
, TPL_INFORMATION18 TPL_INFORMATION18
, TPL_INFORMATION19 TPL_INFORMATION19
, TPL_INFORMATION20 TPL_INFORMATION20
FROM "OTA"."OTA_PRICE_LISTS"