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

VIEW: APPS.INVFV_ITEM_CATEGORY_TYPES

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

View Type

A Business Intelligence System view


It is categorization of a group of items. Items may be assigned to diff categories in different category types to represent the different groupings of items used for diff purposes.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CATEGORY_SET_ID NUMBER
Yes Category type identifier
CATEGORY_TYPE_NAME VARCHAR2 (30) Yes Category type name
DESCRIPTION VARCHAR2 (240)
Description of category type
CATEGORY_FLEX_STRUCTURE VARCHAR2 (30) Yes Category flexfield structure name
_KF:DEFAULT_CATEGORY_NAME CHAR (15)
Default category name
_LA:ENFORCE_CATEGORIES_FLAG CHAR (50)
Can assign an item only to categories defined as valid for this category type
_LA:CONTROL_LEVEL CHAR (74)
Determins if category value is same or different across organizations
STRUCTURE_ID NUMBER
Yes Category flexfield structure identifier
DEFAULT_CATEGORY_ID NUMBER

Default category identifier
LAST_UPDATED_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATED_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
Query Text

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


SELECT CATEGORY_SET_ID
,      CATEGORY_TYPE_NAME
,      DESCRIPTION
,      CATEGORY_FLEX_STRUCTURE
,      _KF:DEFAULT_CATEGORY_NAME
,      _LA:ENFORCE_CATEGORIES_FLAG
,      _LA:CONTROL_LEVEL
,      STRUCTURE_ID
,      DEFAULT_CATEGORY_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_ITEM_CATEGORY_TYPES;

Dependencies

[top of page]

APPS.INVFV_ITEM_CATEGORY_TYPES references the following:

SchemaAPPS
ViewFND_ID_FLEX_STRUCTURES_VL
SynonymMTL_CATEGORIES
SynonymMTL_CATEGORY_SETS

APPS.INVFV_ITEM_CATEGORY_TYPES is not referenced by any database object