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.ISC_OPI_TOP_ORD_WK_BASE_V

Object Details

Object Name:	ISC_OPI_TOP_ORD_WK_BASE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ISC.ISC_OPI_TOP_ORD_WK_BASE_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Booking Summary table.

[View Source]

Columns

Name	Datatype	Length	Comments
SOBL_BOOK_FK_KEY	NUMBER		Foreign key to the Set of Books dimension, Set of Books level
OPER_UNIT_FK_KEY	NUMBER		Foreign key to the Internal Organization dimension, Operating Unit level
CAL_DAY_FK_KEY	NUMBER		Foreign key to the Time dimension, Calendar Day level
TPRT_FK_KEY	NUMBER		Foreign key to the Trade Partner dimension, Trade Partner level
ORDER_NUMBER	VARCHAR2	(80)	Order number
CUSTOMER_NAME	VARCHAR2	(480)	Customer name
ORDERED_DATE	DATE		Ordered date
NET_BOOKED_VALUE	NUMBER		Net booked value
BOOKED_DATE	DATE		Booked date
SHIPPED_VALUE	NUMBER		Shipped value
LATEST_SHIP_DATE	DATE		Latest ship date
FULFILLED_VALUE	NUMBER		Fulfilled value
FULFILLED_DATE	DATE		Date fulfilled
INVOICED_VALUE	NUMBER		Invoiced value
HEADER_ID	VARCHAR2	(80)	Unique identifier of the Header of an order
NUM_OF_ORDERS	NUMBER		Number of orders
RANK	NUMBER		Ranking by Net Order Value

Query Text

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


SELECT SOBL_BOOK_FK_KEY
,      OPER_UNIT_FK_KEY
,      CAL_DAY_FK_KEY
,      TPRT_FK_KEY
,      ORDER_NUMBER
,      CUSTOMER_NAME
,      ORDERED_DATE
,      NET_BOOKED_VALUE
,      BOOKED_DATE
,      SHIPPED_VALUE
,      LATEST_SHIP_DATE
,      FULFILLED_VALUE
,      FULFILLED_DATE
,      INVOICED_VALUE
,      HEADER_ID
,      NUM_OF_ORDERS
,      RANK
FROM APPS.ISC_OPI_TOP_ORD_WK_BASE_V;

Dependencies

[top of page]

APPS.ISC_OPI_TOP_ORD_WK_BASE_V references the following:

APPS: EDW_GL_BOOK_M; EDW_ORGANIZATION_M; EDW_TIME_M; EDW_TRD_PARTNER_M; FII_TIME_WH_API - show dependent code; ISC_EDW_BOOK_SUM1_F

APPS.ISC_OPI_TOP_ORD_WK_BASE_V is referenced by following:

APPS: ISC_OPI_TOP_ORD_WK_S