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


VIEW: APPS.INVBV_ITEM_CATALOG_GROUPS

Object Details
Object Name: INVBV_ITEM_CATALOG_GROUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.INVBV_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)
END_EFFECTIVE_DATE DATE


DESCRIPTION VARCHAR2 (240)

ITEM_CATALOG_GROUP_ID NUMBER
Yes
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 _KF:CATALOG_GROUP_NAME
,      END_EFFECTIVE_DATE
,      DESCRIPTION
,      ITEM_CATALOG_GROUP_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVBV_ITEM_CATALOG_GROUPS;

Dependencies

[top of page]

APPS.INVBV_ITEM_CATALOG_GROUPS references the following:

SchemaAPPS
SynonymMTL_ITEM_CATALOG_GROUPS

APPS.INVBV_ITEM_CATALOG_GROUPS is not referenced by any database object