Product: | AS - Sales Foundation |
---|---|
Description: | Quote items view |
Implementation/DBA Data: | Not implemented in this database |
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