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

VIEW: APPS.ISC_OPI_IND_WK_S

Object Details
Object Name: ISC_OPI_IND_WK_S
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.ISC_OPI_IND_WK_S
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 AR Operations Summary table.


[View Source]

Columns
Name Datatype Length Mandatory 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
OPER_UNIT_NAME VARCHAR2 (500)
Operating Unit name
NUM_OF_ORDERS NUMBER

Number of orders
BOOKED_VALUE NUMBER

Booked value
SHIPPED_VALUE NUMBER

Shipped value
INVOICED_AR_VALUE NUMBER

Invoiced Accounts Receivable value
INVOICED_OE_VALUE NUMBER

Invoiced Order Entry value
EARNED_REVENUE NUMBER

Earned revenue
CASH_COLLECTED NUMBER

Cash collected
Query Text

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


SELECT SOBL_BOOK_FK_KEY
,      OPER_UNIT_FK_KEY
,      OPER_UNIT_NAME
,      NUM_OF_ORDERS
,      BOOKED_VALUE
,      SHIPPED_VALUE
,      INVOICED_AR_VALUE
,      INVOICED_OE_VALUE
,      EARNED_REVENUE
,      CASH_COLLECTED
FROM APPS.ISC_OPI_IND_WK_S;

Dependencies

[top of page]

APPS.ISC_OPI_IND_WK_S references the following:

SchemaAPPS
SynonymEDW_GL_BOOK_M
SynonymEDW_ORGANIZATION_M
SynonymFII_AR_OPERATIONS_SUMMARY
PL/SQL PackageFII_TIME_WH_API - show dependent code

APPS.ISC_OPI_IND_WK_S is not referenced by any database object