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_ITEM_TYPE_CHARGES_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	This view gives Total One Time and Total Recurring Charges for an Order .
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AIOV.HEADER_ID
, SUM(DECODE(XTV.ITEM_TYPE
, 'NON-RECURRING'
, (AIOV.UNIT_SELLING_PRICE * AIOV.ORDERED_QUANTITY )))ONE_TIME
, SUM(DECODE(XTV.ITEM_TYPE
, 'RECURRING'
, (AIOV.UNIT_SELLING_PRICE * AIOV.ORDERED_QUANTITY ))) RECURRING
FROM ASO_I_OE_ORDER_LINES_V AIOV
, XNC_ITEM_TYPE_V XTV
WHERE AIOV.INVENTORY_ITEM_ID = XTV.INVENTORY_ITEM_ID (+)
AND AIOV.ORG_ID = XTV.ORGANIZATION_ID (+) GROUP BY HEADER_ID

Columns

Name
HEADER_ID
ONE_TIME
RECURRING