[Home] [Help]
View: XNC_QUOTE_CHARGES_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | XNC_QUOTE_CHARGES_V retrieves total recurring and non-recurring charges for a quote. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AQL.QUOTE_HEADER_ID
, AQL.CURRENCY_CODE
, SUM(DECODE(XIT.ITEM_TYPE
, 'RECURRING'
, AQL.QUANTITY*AQL.LINE_QUOTE_PRICE
, 0)) RECURRING_CHARGE
, SUM(DECODE(XIT.ITEM_TYPE
, 'NON-RECURRING'
, AQL.QUANTITY*AQL.LINE_QUOTE_PRICE
, 0)) NON_RECURRING_CHARGE
FROM XNC_ITEM_TYPE_V XIT
, ASO_QUOTE_LINES_ALL_V AQL
WHERE AQL.INVENTORY_ITEM_ID = XIT.INVENTORY_ITEM_ID
AND AQL.ORGANIZATION_ID = XIT.ORGANIZATION_ID GROUP BY AQL.QUOTE_HEADER_ID
, AQL.CURRENCY_CODE
Columns
Name |
QUOTE_HEADER_ID |
CURRENCY_CODE |
RECURRING_CHARGE |
NON_RECURRING_CHARGE |