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: AS_QUOTE_ITEMS_V

Product:	AS - Sales Foundation
Description:	Quote items view
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PL.PRICE_LIST_ID
, PL.SECONDARY_PRICE_LIST_ID
, PLL.INVENTORY_ITEM_ID
, PLL.UNIT_CODE
, PLL.PRICING_ATTRIBUTE1
, PLL.PRICING_ATTRIBUTE2
, PLL.PRICING_ATTRIBUTE3
, PLL.PRICING_ATTRIBUTE4
, PLL.PRICING_ATTRIBUTE5
, PLL.PRICING_ATTRIBUTE6
, PLL.PRICING_ATTRIBUTE7
, PLL.PRICING_ATTRIBUTE8
, PLL.PRICING_ATTRIBUTE9
, PLL.PRICING_ATTRIBUTE10
, PLL.PRICING_ATTRIBUTE11
, PLL.PRICING_ATTRIBUTE12
, PLL.PRICING_ATTRIBUTE13
, PLL.PRICING_ATTRIBUTE14
, PLL.PRICING_ATTRIBUTE15
FROM SO_PRICE_LIST_LINES PLL
, SO_PRICE_LISTS PL
WHERE PLL.PRICE_LIST_ID = PL.PRICE_LIST_ID UNION SELECT PL.PRICE_LIST_ID
, PL.SECONDARY_PRICE_LIST_ID
, PLL.INVENTORY_ITEM_ID
, PLL.UNIT_CODE
, PLL.PRICING_ATTRIBUTE1
, PLL.PRICING_ATTRIBUTE2
, PLL.PRICING_ATTRIBUTE3
, PLL.PRICING_ATTRIBUTE4
, PLL.PRICING_ATTRIBUTE5
, PLL.PRICING_ATTRIBUTE6
, PLL.PRICING_ATTRIBUTE7
, PLL.PRICING_ATTRIBUTE8
, PLL.PRICING_ATTRIBUTE9
, PLL.PRICING_ATTRIBUTE10
, PLL.PRICING_ATTRIBUTE11
, PLL.PRICING_ATTRIBUTE12
, PLL.PRICING_ATTRIBUTE13
, PLL.PRICING_ATTRIBUTE14
, PLL.PRICING_ATTRIBUTE15
FROM SO_PRICE_LIST_LINES PLL
, SO_PRICE_LISTS PL
WHERE PLL.PRICE_LIST_ID = PL.SECONDARY_PRICE_LIST_ID

Columns

Name
PRICE_LIST_ID
SECONDARY_PRICE_LIST_ID
INVENTORY_ITEM_ID
UNIT_CODE
PRICING_ATTRIBUTE1
PRICING_ATTRIBUTE2
PRICING_ATTRIBUTE3
PRICING_ATTRIBUTE4
PRICING_ATTRIBUTE5
PRICING_ATTRIBUTE6
PRICING_ATTRIBUTE7
PRICING_ATTRIBUTE8
PRICING_ATTRIBUTE9
PRICING_ATTRIBUTE10
PRICING_ATTRIBUTE11
PRICING_ATTRIBUTE12
PRICING_ATTRIBUTE13
PRICING_ATTRIBUTE14
PRICING_ATTRIBUTE15