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

VIEW: APPS.ICX_PANEL_TOTALS_V

Object Details
Object Name: ICX_PANEL_TOTALS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_PANEL_TOTALS_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
DATA_AS_OF_DATE DATE
Yes
ORDERS_AMOUNT_LAST_WEEK VARCHAR2 (4000)
Total amount of orders placed last week for all customers
ORDERS_LAST_WEEK NUMBER

Number of orders placed last week for all customers
ORDERS_AMOUNT_LAST_MONTH VARCHAR2 (4000)
Total amount of orders placed last month for all customers
ORDERS_LAST_MONTH NUMBER

Number of orders placed last month for all customers
ORDERS_AMOUNT_LAST_3_MONTHS VARCHAR2 (4000)
Total amount of orders placed in last 3 months for all customers
ORDERS_LAST_3_MONTHS NUMBER

Number of orders placed in last 3 months for all customers
ORDERS_AMOUNT_LAST_6_MONTHS VARCHAR2 (4000)
Total amount of orders placed in last 6 months for all customers
ORDERS_LAST_6_MONTHS NUMBER

Number of orders placed in last 6 months for all customers
ORDERS_AMOUNT_LAST_12_MONTHS VARCHAR2 (4000)
Total amount of orders placed in last 12 months for all customers
ORDERS_LAST_12_MONTHS NUMBER

Number of orders placed in last 12 months for all customers
CANCELLED_ORDERS_3_MONTHS NUMBER

Number of orders cancelled within last 3 months for all customers
CANCELLED_AMOUNT_3_MONTHS VARCHAR2 (4000)
Total amount of orders cancelled within last 3 months for all customers
CANCELLED_ORDERS_6_MONTHS NUMBER

Number of orders cancelled within last 6 months for all customers
CANCELLED_AMOUNT_6_MONTHS VARCHAR2 (4000)
Total amount of orders cancelled within last 6 months for all customers
RMA_3_MONTHS NUMBER

Number of returns within last 3 months for all customers
RMA_AMOUNT_3_MONTHS VARCHAR2 (4000)
Total amount of returns within last 3 months for all customers
RMA_6_MONTHS NUMBER

Number of returns within last 6 months for all customers
RMA_AMOUNT_6_MONTHS VARCHAR2 (4000)
Total amount of returns within last 6 months for all customers
LAST_ORDER_DATE DATE


LAST_ORDER_NUMBER NUMBER


SHIPMENTS_OPEN NUMBER


SHIPMENTS_LATE NUMBER


LATE_PAYMENTS_3_MONTHS VARCHAR2 (4000)
Total amount of late payments within last 3 months for all customers
LATE_PAYMENTS_6_MONTHS VARCHAR2 (4000)
Total amount of late payments within last 6 months for all customers
AMOUNT_DUE VARCHAR2 (4000)
Current amount due for all customers
SERVICE_CALLS_3_MONTHS NUMBER

Number of service calls within last 3 months for all customers
DATE_OF_LAST_SERVICE_CALL DATE


SERVICE_AMOUNT_6_MONTHS VARCHAR2 (4000)
Total amount of service order requests within last 6 months for all customers
SERVICE_ORDERS_6_MONTHS NUMBER

Total number of service order requests within last 6 months for all customers
SERVICE_AMOUNT_12_MONTHS VARCHAR2 (4000)
Total amount of service order requests within last 12 months for all customers
SERVICE_ORDERS_12_MONTHS NUMBER

Total number of service order requests within last 12 months for all customers
LAST_SERVICE_CALL_CONTACT NUMBER


ATTRIBUTE7 VARCHAR2 (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DATA_AS_OF_DATE
,      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
,      LATE_PAYMENTS_3_MONTHS
,      LATE_PAYMENTS_6_MONTHS
,      AMOUNT_DUE
,      SERVICE_CALLS_3_MONTHS
,      DATE_OF_LAST_SERVICE_CALL
,      SERVICE_AMOUNT_6_MONTHS
,      SERVICE_ORDERS_6_MONTHS
,      SERVICE_AMOUNT_12_MONTHS
,      SERVICE_ORDERS_12_MONTHS
,      LAST_SERVICE_CALL_CONTACT
,      ATTRIBUTE7
FROM APPS.ICX_PANEL_TOTALS_V;

Dependencies

[top of page]

APPS.ICX_PANEL_TOTALS_V references the following:

SchemaAPPS
PL/SQL PackageFND_CURRENCY - show dependent code
SynonymICX_PANEL_SUMMARY

APPS.ICX_PANEL_TOTALS_V is not referenced by any database object