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


VIEW: APPS.INVBV_CYCLE_COUNT_CLASSES

Object Details
Object Name: INVBV_CYCLE_COUNT_CLASSES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.INVBV_CYCLE_COUNT_CLASSES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about all defined cycle count classes.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CYCLE_COUNT_ID NUMBER
Yes
ABC_ASSIGNMENT_GROUP_ID NUMBER


ABC_CLASS_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
NUMBER_OF_COUNTS_PER_YEAR NUMBER


POSITIVE_APPROVAL_TOLERANCE NUMBER


NEGATIVE_APPROVAL_TOLERANCE NUMBER


POSITIVE_COST_TOLERANCE NUMBER


NEGATIVE_COST_TOLERANCE NUMBER


POSITIVE_HIT_MISS_TOLERANCE NUMBER


NEGATIVE_HIT_MISS_TOLERANCE NUMBER


CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
Query Text

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


SELECT CYCLE_COUNT_ID
,      ABC_ASSIGNMENT_GROUP_ID
,      ABC_CLASS_ID
,      ORGANIZATION_ID
,      NUMBER_OF_COUNTS_PER_YEAR
,      POSITIVE_APPROVAL_TOLERANCE
,      NEGATIVE_APPROVAL_TOLERANCE
,      POSITIVE_COST_TOLERANCE
,      NEGATIVE_COST_TOLERANCE
,      POSITIVE_HIT_MISS_TOLERANCE
,      NEGATIVE_HIT_MISS_TOLERANCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.INVBV_CYCLE_COUNT_CLASSES;

Dependencies

[top of page]

APPS.INVBV_CYCLE_COUNT_CLASSES references the following:

SchemaAPPS
SynonymMTL_CYCLE_COUNT_CLASSES

APPS.INVBV_CYCLE_COUNT_CLASSES is not referenced by any database object