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