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

VIEW: APPS.INVFV_EXTERNAL_ITEM_XREFS

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

View Type

A Business Intelligence System view


This shows External Item Cross-References which assign cross-references to items. The cross-reference type identifies the cross-referencing identification method being used.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_NAME VARCHAR2 (240)
Name of organization
CROSS_REFERENCE_TYPE VARCHAR2 (25) Yes Cross reference type
CROSS_REFERENCE_VALUE VARCHAR2 (255) Yes Cross reference designator
_KF:ITEM_NAME CHAR (15)
Name of item
VALUE_DESCRIPTION VARCHAR2 (240)
Cross reference description
_LA:ALL_ORGANIZATIONS_FLAG CHAR (54)
Indicates organization independence
_DF CHAR (31)
Descriptive flexfield
INVENTORY_ITEM_ID NUMBER
Yes Item identifier
ORGANIZATION_ID NUMBER

Organization 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
,      CROSS_REFERENCE_TYPE
,      CROSS_REFERENCE_VALUE
,      _KF:ITEM_NAME
,      VALUE_DESCRIPTION
,      _LA:ALL_ORGANIZATIONS_FLAG
,      _DF
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_EXTERNAL_ITEM_XREFS;

Dependencies

[top of page]

APPS.INVFV_EXTERNAL_ITEM_XREFS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_CROSS_REFERENCES
SynonymMTL_SYSTEM_ITEMS

APPS.INVFV_EXTERNAL_ITEM_XREFS is not referenced by any database object