[Home] [Help]
View: AS_DOSSIER_PRODTOTALS_V
Product: | AS - Sales Foundation |
Description: | Order history product totals view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HEADER_ID
, NVL( SUM( SELLING_PRICE * ( ORDERED_QUANTITY - NVL(CANCELLED_QUANTITY
, 0) ) )
, 0)
, NVL( SUM( LIST_PRICE * (ORDERED_QUANTITY - NVL(CANCELLED_QUANTITY
, 0) ) )
, 0)
FROM SO_LINES
WHERE (LINE_TYPE_CODE = 'DETAIL' OR LINE_TYPE_CODE = 'REGULAR')
AND (ITEM_TYPE_CODE = 'MODEL' OR (ITEM_TYPE_CODE = 'STANDARD') OR (ITEM_TYPE_CODE = 'KIT') ) GROUP BY HEADER_ID
Columns
Name |
HEADER_ID |
TOTAL_PRODUCT_VALUE |
TOTAL_LIST_VALUE |