[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ICX_PANEL_SUMMARY |
|---|---|
| Object Type: | TABLE |
| Owner: | ICX |
| FND Design Data: |  ICX.ICX_PANEL_SUMMARY
|
| Subobject Name: | |
| Status: | VALID |
ICX_PANEL_SUMMARY contains summary information about the
customers. For each customer, it contains status of sales
orders, customer credit status and service request information.
.
A procedure has been designed to populate the ICX_PANEL_SUMMARY table
with calculated information such as Sales Order Amount Last Week, Last
Month, and so on. The procedure is run at various intervals and the
information stored in the table is kept up to the fifth interval.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ICX_PANEL_SUMMARY_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORG_ID
CUSTOMER_ID
DATA_AS_OF_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORG_ID | NUMBER | Yes | Organization unique identifier | |
| CUSTOMER_ID | NUMBER | Yes | Customer identifier | |
| DATA_AS_OF_DATE | DATE | Yes | Record creation date | |
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
| SAME_SUPPLY_CHAIN_FLAG | VARCHAR2 | (1) | Is the customer a supplier as well? | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency for all amounts | |
| LAST_ORDER_HEADER_ID | NUMBER | Identifier of the last order | ||
| ORDERS_AMOUNT_LAST_WEEK | NUMBER | Total amount of orders placed last week | ||
| ORDERS_LAST_WEEK | NUMBER | Number of orders placed last week | ||
| ORDERS_AMOUNT_LAST_MONTH | NUMBER | Total amount of orders placed last month | ||
| ORDERS_LAST_MONTH | NUMBER | Number of orders placed last month | ||
| ORDERS_AMOUNT_LAST_3_MONTHS | NUMBER | Total amount of orders placed in last 3 months | ||
| ORDERS_LAST_3_MONTHS | NUMBER | Number of placed in last 3 months | ||
| ORDERS_AMOUNT_LAST_6_MONTHS | NUMBER | Total amount of orders placed in last 6 months | ||
| ORDERS_LAST_6_MONTHS | NUMBER | Number of orders placed in last 6 months | ||
| ORDERS_AMOUNT_LAST_12_MONTHS | NUMBER | Total amount of orders placed in last 12 months | ||
| ORDERS_LAST_12_MONTHS | NUMBER | Number of orders placed in last 12 months | ||
| CANCELLED_ORDERS_3_MONTHS | NUMBER | Number of orders cancelled within last 3 months | ||
| CANCELLED_AMOUNT_3_MONTHS | NUMBER | Total amount of orders cancelled within last 3 months | ||
| CANCELLED_ORDERS_6_MONTHS | NUMBER | Number of orders cancelled within last 6 months | ||
| CANCELLED_AMOUNT_6_MONTHS | NUMBER | Total amount of orders cancelled within last 6 months | ||
| RMA_3_MONTHS | NUMBER | Number of returns within last 3 months | ||
| RMA_AMOUNT_3_MONTHS | NUMBER | Total amount of returns within last 3 months | ||
| RMA_6_MONTHS | NUMBER | Number of returns within last 6 months | ||
| RMA_AMOUNT_6_MONTHS | NUMBER | Total amount of returns within last 6 months | ||
| LAST_ORDER_DATE | DATE | Date of the last order | ||
| LAST_ORDER_NUMBER | NUMBER | User-visible number of the last order | ||
| SHIPMENTS_OPEN | NUMBER | Not used | ||
| SHIPMENTS_LATE | NUMBER | Not used | ||
| CREDIT_RATING | VARCHAR2 | (30) | Credit rating for the customer | |
| RISK_CODE | VARCHAR2 | (30) | Risk code for the customer | |
| LATE_PAYMENTS_3_MONTHS | NUMBER | Total amount of late payments within last 3 months | ||
| LATE_PAYMENTS_6_MONTHS | NUMBER | Total amount of late payments within last 6 months | ||
| AMOUNT_DUE | NUMBER | Current amount due | ||
| SERVICE_CALLS_3_MONTHS | NUMBER | Number of service calls within last 3 months | ||
| DATE_OF_LAST_SERVICE_CALL | DATE | Date of last service call | ||
| SITE_ID_LAST_SERVICE_CALL | NUMBER | Site id from which the last service call was made | ||
| SERVICE_AMOUNT_6_MONTHS | NUMBER | Total amount of service order requests within last 6 months | ||
| SERVICE_ORDERS_6_MONTHS | NUMBER | Total number of service order requests within last 6 months | ||
| SERVICE_AMOUNT_12_MONTHS | NUMBER | Total amount of service order requests within last 12 months | ||
| SERVICE_ORDERS_12_MONTHS | NUMBER | Total number of service order requests within last 12 months | ||
| LAST_SERVICE_CALL_CONTACT | VARCHAR2 | (100) | Customer contact for the last service call | |
| ATTRIBUTE1 | NUMBER | Descriptive flexfield segment column | ||
| ATTRIBUTE2 | NUMBER | Descriptive flexfield segment column | ||
| ATTRIBUTE3 | NUMBER | Descriptive flexfield segment column | ||
| ATTRIBUTE4 | NUMBER | Descriptive flexfield segment column | ||
| ATTRIBUTE5 | NUMBER | Descriptive flexfield segment column | ||
| ATTRIBUTE6 | NUMBER | Descriptive flexfield segment column | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, CUSTOMER_ID
, DATA_AS_OF_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, SAME_SUPPLY_CHAIN_FLAG
, CURRENCY_CODE
, LAST_ORDER_HEADER_ID
, ORDERS_AMOUNT_LAST_WEEK
, ORDERS_LAST_WEEK
, ORDERS_AMOUNT_LAST_MONTH
, ORDERS_LAST_MONTH
, ORDERS_AMOUNT_LAST_3_MONTHS
, ORDERS_LAST_3_MONTHS
, ORDERS_AMOUNT_LAST_6_MONTHS
, ORDERS_LAST_6_MONTHS
, ORDERS_AMOUNT_LAST_12_MONTHS
, ORDERS_LAST_12_MONTHS
, CANCELLED_ORDERS_3_MONTHS
, CANCELLED_AMOUNT_3_MONTHS
, CANCELLED_ORDERS_6_MONTHS
, CANCELLED_AMOUNT_6_MONTHS
, RMA_3_MONTHS
, RMA_AMOUNT_3_MONTHS
, RMA_6_MONTHS
, RMA_AMOUNT_6_MONTHS
, LAST_ORDER_DATE
, LAST_ORDER_NUMBER
, SHIPMENTS_OPEN
, SHIPMENTS_LATE
, CREDIT_RATING
, RISK_CODE
, LATE_PAYMENTS_3_MONTHS
, LATE_PAYMENTS_6_MONTHS
, AMOUNT_DUE
, SERVICE_CALLS_3_MONTHS
, DATE_OF_LAST_SERVICE_CALL
, SITE_ID_LAST_SERVICE_CALL
, SERVICE_AMOUNT_6_MONTHS
, SERVICE_ORDERS_6_MONTHS
, SERVICE_AMOUNT_12_MONTHS
, SERVICE_ORDERS_12_MONTHS
, LAST_SERVICE_CALL_CONTACT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
FROM ICX.ICX_PANEL_SUMMARY;
ICX.ICX_PANEL_SUMMARY does not reference any database object
ICX.ICX_PANEL_SUMMARY is referenced by following:
APPS
ICX_PANEL_SUMMARY
|
|
|
|