eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: ICX.ICX_PANEL_SUMMARY#

Object Details

Object Name:	ICX_PANEL_SUMMARY#
Object Type:	VIEW
Owner:	ICX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORG_ID	NUMBER		Yes
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	NUMBER
ORDERS_LAST_WEEK	NUMBER
ORDERS_AMOUNT_LAST_MONTH	NUMBER
ORDERS_LAST_MONTH	NUMBER
ORDERS_AMOUNT_LAST_3_MONTHS	NUMBER
ORDERS_LAST_3_MONTHS	NUMBER
ORDERS_AMOUNT_LAST_6_MONTHS	NUMBER
ORDERS_LAST_6_MONTHS	NUMBER
ORDERS_AMOUNT_LAST_12_MONTHS	NUMBER
ORDERS_LAST_12_MONTHS	NUMBER
CANCELLED_ORDERS_3_MONTHS	NUMBER
CANCELLED_AMOUNT_3_MONTHS	NUMBER
CANCELLED_ORDERS_6_MONTHS	NUMBER
CANCELLED_AMOUNT_6_MONTHS	NUMBER
RMA_3_MONTHS	NUMBER
RMA_AMOUNT_3_MONTHS	NUMBER
RMA_6_MONTHS	NUMBER
RMA_AMOUNT_6_MONTHS	NUMBER
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	NUMBER
LATE_PAYMENTS_6_MONTHS	NUMBER
AMOUNT_DUE	NUMBER
SERVICE_CALLS_3_MONTHS	NUMBER
DATE_OF_LAST_SERVICE_CALL	DATE
SITE_ID_LAST_SERVICE_CALL	NUMBER
SERVICE_AMOUNT_6_MONTHS	NUMBER
SERVICE_ORDERS_6_MONTHS	NUMBER
SERVICE_AMOUNT_12_MONTHS	NUMBER
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)

Query Text

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#;

Dependencies

[top of page]

ICX.ICX_PANEL_SUMMARY# references the following:

ICX: ICX_PANEL_SUMMARY

ICX.ICX_PANEL_SUMMARY# is referenced by following:

APPS: ICX_PANEL_SUMMARY