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

VIEW: APPS.INVFV_ITEM_CATEGORIES

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

View Type

A Business Intelligence System view


This shows items that are grouped into categories within the context of a category set. This provides flexible grouping schemes.


[View Source]

Columns
Name Datatype Length Mandatory Comments
_KF:CATEGORY_NAME CHAR (15)
Item category name
DESCRIPTION VARCHAR2 (240)
Item category description
END_EFFECTIVE_DATE DATE

Disable date
CATEGORY_FLEX_STRUCTURE VARCHAR2 (30) Yes Category flexfield structure
_DF CHAR (25)
Descriptive flexfield
CATEGORY_ID NUMBER
Yes Item category identifier
STRUCTURE_ID NUMBER
Yes Category flexfield structure 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 _KF:CATEGORY_NAME
,      DESCRIPTION
,      END_EFFECTIVE_DATE
,      CATEGORY_FLEX_STRUCTURE
,      _DF
,      CATEGORY_ID
,      STRUCTURE_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_ITEM_CATEGORIES;

Dependencies

[top of page]

APPS.INVFV_ITEM_CATEGORIES references the following:

SchemaAPPS
ViewFND_ID_FLEX_STRUCTURES_VL
SynonymMTL_CATEGORIES

APPS.INVFV_ITEM_CATEGORIES is not referenced by any database object