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: APPS.ICX_PANEL_SUMMARY_V

Object Details

Object Name:	ICX_PANEL_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.ICX_PANEL_SUMMARY_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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)

Query Text

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;

Dependencies

[top of page]

APPS.ICX_PANEL_SUMMARY_V references the following:

APPS: FND_CURRENCY - show dependent code; ICX_PANEL_SUMMARY

APPS.ICX_PANEL_SUMMARY_V is not referenced by any database object