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

VIEW: APPS.INVFV_EXT_ITEM_XREF_TYPES

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

View Type

A Business Intelligence System view


This shows External Item Cross-Reference Types which are used to define cross-reference
type codes. The cross-reference type code provides context information for cross-referencing from an item to some other relevant identification method.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CROSS_REFERENCE_TYPE VARCHAR2 (25) Yes Type of cross reference
END_EFFECTIVE_DATE DATE

Disable date
DESCRIPTION VARCHAR2 (240)
Cross reference type description
_DF CHAR (36)
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 CROSS_REFERENCE_TYPE
,      END_EFFECTIVE_DATE
,      DESCRIPTION
,      _DF
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_EXT_ITEM_XREF_TYPES;

Dependencies

[top of page]

APPS.INVFV_EXT_ITEM_XREF_TYPES references the following:

SchemaAPPS
SynonymMTL_CROSS_REFERENCE_TYPES

APPS.INVFV_EXT_ITEM_XREF_TYPES is not referenced by any database object