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

VIEW: APPS.INVFV_ITEM_RELATIONS

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

View Type

A Business Intelligence System view


This shows the relationships between items. All relationships are defined within the item master organization. Item relationships may be used to search for related and substitute items.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
_KF:ITEM_NAME CHAR (16)
Name of item
_KF:RELATED_ITEM_NAME CHAR (16)
Name of related item
_LA:RELATIONSHIP_TYPE CHAR (70)
Indicates if relationship is a 'Substitute' or 'Related' relationship
_LA:RECIPROCAL_VALID_FLAG CHAR (49)
Indicates whether the relationship is reciprocal
INVENTORY_ITEM_ID NUMBER
Yes Item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
RELATED_ITEM_ID NUMBER
Yes Related 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 ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      _KF:ITEM_NAME
,      _KF:RELATED_ITEM_NAME
,      _LA:RELATIONSHIP_TYPE
,      _LA:RECIPROCAL_VALID_FLAG
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      RELATED_ITEM_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_ITEM_RELATIONS;

Dependencies

[top of page]

APPS.INVFV_ITEM_RELATIONS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_RELATED_ITEMS
SynonymMTL_SYSTEM_ITEMS

APPS.INVFV_ITEM_RELATIONS is not referenced by any database object