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


VIEW: APPS.OPI_INV_CC_CLS_V

Object Details
Object Name: OPI_INV_CC_CLS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


Cycle Count Class Dimension level view for DBI.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (122)
Cycle Count Class unique ID (concatenated key of organization id, cycle count header id and class id)
VALUE VARCHAR2 (90)
Cycle Count Class value (Concatenated key of organization, cycle count header and class for display)
DESCRIPTION VARCHAR2 (240)
Cycle Count Class description
CC_FK_KEY VARCHAR2 (81)
Surrogate key to parent cycle count in the cycle count dimension view
Query Text

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


SELECT ID
,      VALUE
,      DESCRIPTION
,      CC_FK_KEY
FROM APPS.OPI_INV_CC_CLS_V;

Dependencies

[top of page]

APPS.OPI_INV_CC_CLS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymIC_RANK_MST
SynonymIC_WHSE_MST
SynonymMTL_ABC_CLASSES
SynonymMTL_CYCLE_COUNT_CLASSES
SynonymMTL_CYCLE_COUNT_HEADERS
SynonymMTL_PARAMETERS

APPS.OPI_INV_CC_CLS_V is not referenced by any database object