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

VIEW: APPS.INVFV_ITEM_CATALOG_GROUPS

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

View Type

A Business Intelligence System view


This shows item catalog groups which include items that have the same set of descriptive elements or item properties. An item associated with a catalog group inherits the descriptive elements for that group which behave like additional item attributes.


[View Source]

Columns
Name Datatype Length Mandatory Comments
_KF:CATALOG_GROUP_NAME CHAR (15)
Item catalog group name
END_EFFECTIVE_DATE DATE

Disable date
DESCRIPTION VARCHAR2 (240)
Description of item catalog group
_DF CHAR (34)
Descriptive flexfield
ITEM_CATALOG_GROUP_ID NUMBER
Yes Item catalog group identifier
CREATED_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATED_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
Query Text

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


SELECT _KF:CATALOG_GROUP_NAME
,      END_EFFECTIVE_DATE
,      DESCRIPTION
,      _DF
,      ITEM_CATALOG_GROUP_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.INVFV_ITEM_CATALOG_GROUPS;

Dependencies

[top of page]

APPS.INVFV_ITEM_CATALOG_GROUPS references the following:

SchemaAPPS
SynonymMTL_ITEM_CATALOG_GROUPS

APPS.INVFV_ITEM_CATALOG_GROUPS is not referenced by any database object