[Home] [Help] [Dependency Information]
Object Name: | ICX_PANEL_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_PANEL_SUMMARY_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_ID | NUMBER | Yes | ||
DATA_AS_OF_DATE | DATE | Yes | ||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
SAME_SUPPLY_CHAIN_FLAG | VARCHAR2 | (1) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
LAST_ORDER_HEADER_ID | NUMBER | |||
ORDERS_AMOUNT_LAST_WEEK | VARCHAR2 | (4000) | Formatted total amount of orders placed last week | |
ORDERS_LAST_WEEK | NUMBER | |||
ORDERS_AMOUNT_LAST_MONTH | VARCHAR2 | (4000) | Formatted total amount of orders placed last month | |
ORDERS_LAST_MONTH | NUMBER | |||
ORDERS_AMOUNT_LAST_3_MONTHS | VARCHAR2 | (4000) | Formatted total amount of orders placed in last 3 months | |
ORDERS_LAST_3_MONTHS | NUMBER | |||
ORDERS_AMOUNT_LAST_6_MONTHS | VARCHAR2 | (4000) | Formatted total amount of orders placed in last 6 months | |
ORDERS_LAST_6_MONTHS | NUMBER | |||
ORDERS_AMOUNT_LAST_12_MONTHS | VARCHAR2 | (4000) | Formatted total amount of orders placed in last 12 months | |
ORDERS_LAST_12_MONTHS | NUMBER | |||
CANCELLED_ORDERS_3_MONTHS | NUMBER | |||
CANCELLED_AMOUNT_3_MONTHS | VARCHAR2 | (4000) | Formatted total amount of orders cancelled within last 3 months | |
CANCELLED_ORDERS_6_MONTHS | NUMBER | |||
CANCELLED_AMOUNT_6_MONTHS | VARCHAR2 | (4000) | Formatted total amount of orders cancelled within last 6 months | |
RMA_3_MONTHS | NUMBER | |||
RMA_AMOUNT_3_MONTHS | VARCHAR2 | (4000) | Formatted total amount of returns within last 3 months | |
RMA_6_MONTHS | NUMBER | |||
RMA_AMOUNT_6_MONTHS | VARCHAR2 | (4000) | Formatted total amount of returns within last 6 months | |
LAST_ORDER_DATE | DATE | |||
LAST_ORDER_NUMBER | NUMBER | |||
SHIPMENTS_OPEN | NUMBER | |||
SHIPMENTS_LATE | NUMBER | |||
CREDIT_RATING | VARCHAR2 | (30) | ||
RISK_CODE | VARCHAR2 | (30) | ||
LATE_PAYMENTS_3_MONTHS | VARCHAR2 | (4000) | Formatted total amount of late payments within last 3 months | |
LATE_PAYMENTS_6_MONTHS | VARCHAR2 | (4000) | Formatted total amount of late payments within last 6 months | |
AMOUNT_DUE | VARCHAR2 | (4000) | Formatted current amount due | |
SERVICE_CALLS_3_MONTHS | NUMBER | |||
DATE_OF_LAST_SERVICE_CALL | DATE | |||
SITE_ID_LAST_SERVICE_CALL | NUMBER | |||
SERVICE_AMOUNT_6_MONTHS | VARCHAR2 | (4000) | Formatted total amount of service order requests within last 6 months | |
SERVICE_ORDERS_6_MONTHS | NUMBER | |||
SERVICE_AMOUNT_12_MONTHS | VARCHAR2 | (4000) | Formatted total amount of service order requests within last 12 months | |
SERVICE_ORDERS_12_MONTHS | NUMBER | |||
LAST_SERVICE_CALL_CONTACT | VARCHAR2 | (100) | ||
ATTRIBUTE1 | NUMBER | |||
ATTRIBUTE2 | NUMBER | |||
ATTRIBUTE3 | NUMBER | |||
ATTRIBUTE4 | NUMBER | |||
ATTRIBUTE5 | NUMBER | |||
ATTRIBUTE6 | NUMBER | |||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT 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 APPS.ICX_PANEL_SUMMARY_V;
APPS.ICX_PANEL_SUMMARY_V is not referenced by any database object
|
|
|