[Home] [Help]
| Product: | ICX - Oracle iProcurement |
|---|---|
| Description: | Historical Customer Summary View |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PS.CUSTOMER_ID
, CUSTOMER_NAME
, DATA_AS_OF_DATE
, PS.PROGRAM_APPLICATION_ID
, PS.PROGRAM_UPDATE_DATE
, SAME_SUPPLY_CHAIN_FLAG
, PS.CURRENCY_CODE
, PS.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
, PS.ATTRIBUTE1
, PS.ATTRIBUTE2
, PS.ATTRIBUTE3
, PS.ATTRIBUTE4
, PS.ATTRIBUTE5
, PS.ATTRIBUTE6
, PS.ATTRIBUTE7
, PS.ATTRIBUTE8
, PS.ATTRIBUTE9
, PS.ATTRIBUTE10
, PS.ATTRIBUTE11
, PS.ATTRIBUTE12
FROM ICX_PANEL_SUMMARY PS
, RA_CUSTOMERS CUST
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 PS.CUSTOMER_ID = CUST.CUSTOMER_ID