View: ICX_PANEL_SUMMARY_V

Product:	ICX - Oracle iProcurement
Description:	Latest Customer Summary View
Implementation/DBA Data:	APPS.ICX_PANEL_SUMMARY_V

View Text

SELECT CUSTOMER_ID
, DATA_AS_OF_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, SAME_SUPPLY_CHAIN_FLAG
, CURRENCY_CODE
, LAST_ORDER_HEADER_ID
, TO_CHAR(ORDERS_AMOUNT_LAST_WEEK
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_WEEK
, TO_CHAR(ORDERS_AMOUNT_LAST_MONTH
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_MONTH
, TO_CHAR(ORDERS_AMOUNT_LAST_3_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_3_MONTHS
, TO_CHAR(ORDERS_AMOUNT_LAST_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_6_MONTHS
, TO_CHAR(ORDERS_AMOUNT_LAST_12_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_12_MONTHS
, CANCELLED_ORDERS_3_MONTHS
, TO_CHAR(CANCELLED_AMOUNT_3_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, CANCELLED_ORDERS_6_MONTHS
, TO_CHAR(CANCELLED_AMOUNT_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, RMA_3_MONTHS
, TO_CHAR(RMA_AMOUNT_3_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, RMA_6_MONTHS
, TO_CHAR(RMA_AMOUNT_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, LAST_ORDER_DATE
, LAST_ORDER_NUMBER
, SHIPMENTS_OPEN
, SHIPMENTS_LATE
, CREDIT_RATING
, RISK_CODE
, TO_CHAR(LATE_PAYMENTS_3_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, TO_CHAR(LATE_PAYMENTS_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, TO_CHAR(AMOUNT_DUE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SERVICE_CALLS_3_MONTHS
, DATE_OF_LAST_SERVICE_CALL
, SITE_ID_LAST_SERVICE_CALL
, TO_CHAR(SERVICE_AMOUNT_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SERVICE_ORDERS_6_MONTHS
, TO_CHAR(SERVICE_AMOUNT_12_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SERVICE_ORDERS_12_MONTHS
, LAST_SERVICE_CALL_CONTACT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
FROM ICX_PANEL_SUMMARY
WHERE DATA_AS_OF_DATE = ( SELECT MAX( DATA_AS_OF_DATE )
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) )
AND 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)

Columns