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

VIEW: APPS.INVFV_ITEM_DESC_ELEMENT_VALUES

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

View Type

A Business Intelligence System view


This shows the Item Descriptive Element Values which are stored for a specific item. When an item is associated with a particular item catalog group, one row per descriptive element (for that catalog group) is created.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DESCRIPTIVE_ELEMENT_NAME VARCHAR2 (30) Yes Name of descriptive element
_KF:ITEM_NAME CHAR (15)
Name of item
DESCRIPTIVE_ELEMENT_VALUE VARCHAR2 (30)
Value for descriptive element
SEQUENCE_NUMBER NUMBER
Yes Descriptive element sequence number
_LA:DEFAULT_DESCRIPTION_FLAG CHAR (55)
Determines if descriptive element included in a catalog-derived item description
INVENTORY_ITEM_ID NUMBER
Yes Item 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 DESCRIPTIVE_ELEMENT_NAME
,      _KF:ITEM_NAME
,      DESCRIPTIVE_ELEMENT_VALUE
,      SEQUENCE_NUMBER
,      _LA:DEFAULT_DESCRIPTION_FLAG
,      INVENTORY_ITEM_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_ITEM_DESC_ELEMENT_VALUES;

Dependencies

[top of page]

APPS.INVFV_ITEM_DESC_ELEMENT_VALUES references the following:

SchemaAPPS
SynonymMTL_DESCR_ELEMENT_VALUES
SynonymMTL_SYSTEM_ITEMS

APPS.INVFV_ITEM_DESC_ELEMENT_VALUES is not referenced by any database object