Product: | ICX - Oracle iProcurement |
---|---|
Description: | Total Summary View for All Customers |
Implementation/DBA Data: | APPS.ICX_PANEL_TOTALS_V |
SELECT DATA_AS_OF_DATE
, TO_CHAR(SUM( ORDERS_AMOUNT_LAST_WEEK )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( ORDERS_LAST_WEEK )
, TO_CHAR(SUM( ORDERS_AMOUNT_LAST_MONTH )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( ORDERS_LAST_MONTH )
, TO_CHAR(SUM( ORDERS_AMOUNT_LAST_3_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( ORDERS_LAST_3_MONTHS )
, TO_CHAR(SUM( ORDERS_AMOUNT_LAST_6_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( ORDERS_LAST_6_MONTHS )
, TO_CHAR(SUM( ORDERS_AMOUNT_LAST_12_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( ORDERS_LAST_12_MONTHS )
, SUM( CANCELLED_ORDERS_3_MONTHS )
, TO_CHAR(SUM( CANCELLED_AMOUNT_3_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( CANCELLED_ORDERS_6_MONTHS )
, TO_CHAR(SUM( CANCELLED_AMOUNT_6_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( RMA_3_MONTHS )
, TO_CHAR(SUM( RMA_AMOUNT_3_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( RMA_6_MONTHS )
, TO_CHAR(SUM( RMA_AMOUNT_6_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, MAX( LAST_ORDER_DATE )
, MAX( LAST_ORDER_NUMBER )
, SUM( SHIPMENTS_OPEN )
, SUM( SHIPMENTS_LATE )
, TO_CHAR(SUM( LATE_PAYMENTS_3_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, TO_CHAR(SUM( LATE_PAYMENTS_6_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, TO_CHAR(SUM( AMOUNT_DUE )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( SERVICE_CALLS_3_MONTHS )
, MAX( DATE_OF_LAST_SERVICE_CALL )
, TO_CHAR(SUM( SERVICE_AMOUNT_6_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( SERVICE_ORDERS_6_MONTHS )
, TO_CHAR(SUM( SERVICE_AMOUNT_12_MONTHS )
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SUM( SERVICE_ORDERS_12_MONTHS )
, SUM( LAST_SERVICE_CALL_CONTACT )
, CURRENCY_CODE
FROM ICX_PANEL_SUMMARY
WHERE NVL( ORG_ID
, NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)) = NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99) GROUP BY DATA_AS_OF_DATE
, CURRENCY_CODE