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

VIEW: APPS.INVFV_DESCRIPTIVE_ELEMENTS

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

View Type

A Business Intelligence System view


This shows descriptive elements which are properties used to describe the catalog group.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DESCRIPTIVE_ELEMENT_NAME VARCHAR2 (30) Yes Descriptive element name
_KF:CATALOG_GROUP_NAME CHAR (15)
Item catalog group name
SEQUENCE_NUMBER NUMBER
Yes Descriptive element sequence number
DESCRIPTION VARCHAR2 (50)
Description of descriptive element
_LA:REQUIRED_FLAG CHAR (55)
Indicates if element is required or not
_LA:DEFAULT_DESCRIPTION_FLAG CHAR (54)
Determines if descriptive element is used to create the catalog description
ITEM_CATALOG_GROUP_ID NUMBER
Yes Item catalog group 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:CATALOG_GROUP_NAME
,      SEQUENCE_NUMBER
,      DESCRIPTION
,      _LA:REQUIRED_FLAG
,      _LA:DEFAULT_DESCRIPTION_FLAG
,      ITEM_CATALOG_GROUP_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_DESCRIPTIVE_ELEMENTS;

Dependencies

[top of page]

APPS.INVFV_DESCRIPTIVE_ELEMENTS references the following:

SchemaAPPS
SynonymMTL_DESCRIPTIVE_ELEMENTS
SynonymMTL_ITEM_CATALOG_GROUPS

APPS.INVFV_DESCRIPTIVE_ELEMENTS is not referenced by any database object