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

VIEW: APPS.ISC_OPI_IND_CR_TAB_S

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

Quarter-to-date measure
MEASURE_WK NUMBER

Week measure
MEASURE_Q_W NUMBER

Quarter-to-date measure without weekends
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
,      MEASURE_Q_W
,      SORT_ORDER
FROM APPS.ISC_OPI_IND_CR_TAB_S;

Dependencies

[top of page]

APPS.ISC_OPI_IND_CR_TAB_S references the following:

SchemaAPPS
PL/SQL PackageFII_TIME_WH_API - show dependent code
ViewISC_OPI_IND_CR_TAB_BASE_V

APPS.ISC_OPI_IND_CR_TAB_S is not referenced by any database object