[Home] [Help]
View: AS_DOSSIER_SERVTOTALS_V
Product: | AS - Sales Foundation |
Description: | Order history service totals view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HEADER_ID
, NVL (SUM (NVL(SELLING_PRICE
, 0) * NVL(SERVICE_DURATION
, 1) * (NVL(ORDERED_QUANTITY - NVL(CANCELLED_QUANTITY
, 0)
, 0) ) )
, 0)
FROM SO_LINES
WHERE (LINE_TYPE_CODE = 'DETAIL' OR LINE_TYPE_CODE = 'REGULAR')
AND ITEM_TYPE_CODE = 'SERVICE' GROUP BY HEADER_ID
Columns
Name |
HEADER_ID |
TOTAL_SERVICE_VALUE |