[Home] [Help]
View: ICX_PANEL_SO_SUMMARY_V
| Product: | ICX - Oracle iProcurement |
|---|
| Description: | Obsolete |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CUST.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, H.CURRENCY_CODE
, MAX(H.DATE_ORDERED)
, MAX(H.DATE_REQUESTED_CURRENT)
, TO_CHAR(SUM(OE_QUERY.ORDER_TOTAL(H.HEADER_ID))
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(H.CURRENCY_CODE
, 30)) ORDER_TOTAL
, COUNT(H.ORDER_NUMBER)
FROM RA_CUSTOMERS CUST
, SO_HEADERS H
WHERE H.CUSTOMER_ID = CUST.CUSTOMER_ID(+)
AND H.DATE_ORDERED >= SYSDATE - 30 GROUP BY CUST.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, CURRENCY_CODE
Columns
| Name |
| CUSTOMER_ID |
| CUSTOMER_NAME |
| CURRENCY_CODE |
| LAST_DATE_ORDERED |
| LAST_DATE_REQUESTED |
| ORDER_TOTAL |
| TOTAL_SO_NUMBERS |