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

VIEW: APPS.ISC_OPI_IND_CR_TAB_BASE_V

Object Details
Object Name: ISC_OPI_IND_CR_TAB_BASE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.ISC_OPI_IND_CR_TAB_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 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
MEASURE_NAME VARCHAR2 (255) Yes Name measure
MEASURE_QTD NUMBER

Quarter-to-date measure
MEASURE_WK NUMBER

Week measure
SORT_ORDER NUMBER

Sort order
Query Text

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


SELECT SOBL_BOOK_FK_KEY
,      MEASURE_NAME
,      MEASURE_QTD
,      MEASURE_WK
,      SORT_ORDER
FROM APPS.ISC_OPI_IND_CR_TAB_BASE_V;

Dependencies

[top of page]

APPS.ISC_OPI_IND_CR_TAB_BASE_V references the following:

SchemaAPPS
ViewBISBV_PERFORMANCE_MEASURES
SynonymEDW_GL_BOOK_M
SynonymFII_AR_OPERATIONS_SUMMARY
PL/SQL PackageFII_TIME_WH_API - show dependent code
SchemaPUBLIC
SynonymDUAL
APPS.ISC_OPI_IND_CR_TAB_BASE_V is referenced by following:

SchemaAPPS
ViewISC_OPI_IND_CR_TAB_S