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

VIEW: APPS.INVBV_ITEM_CATEGORY_TYPES

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

View Type

A Business Intelligence System view


This shows Item Category Types which allow the categorization of a group of items. Items may be assigned to different categories in different category types to represent the different groupings of items used for different purposes.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CATEGORY_TYPE_NAME VARCHAR2 (30) Yes
DESCRIPTION VARCHAR2 (240)

_LA:ENFORCE_CATEGORIES_FLAG CHAR (47)
Can assign an item only to categories defined as valid for this category type
_LA:CONTROL_LEVEL CHAR (71)
Determins if category value is same or different across organizations
CATEGORY_SET_ID NUMBER
Yes
STRUCTURE_ID NUMBER
Yes
DEFAULT_CATEGORY_ID NUMBER


LAST_UPDATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATED_DATE DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT CATEGORY_TYPE_NAME
,      DESCRIPTION
,      _LA:ENFORCE_CATEGORIES_FLAG
,      _LA:CONTROL_LEVEL
,      CATEGORY_SET_ID
,      STRUCTURE_ID
,      DEFAULT_CATEGORY_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVBV_ITEM_CATEGORY_TYPES;

Dependencies

[top of page]

APPS.INVBV_ITEM_CATEGORY_TYPES references the following:

SchemaAPPS
SynonymMTL_CATEGORY_SETS

APPS.INVBV_ITEM_CATEGORY_TYPES is not referenced by any database object