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

VIEW: APPS.INVFV_CUSTOMER_ITEM_XREFS

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

View Type

A Business Intelligence System view


This shows the relationship between Customer Items and Inventory Items. The relationship is defined at the Item Master Organization Level, and is ranked by a preference number.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ITEM_NAME VARCHAR2 (50) Yes Name of customer item
_KF:ITEM_NAME CHAR (15)
Name of inventory item
ORGANIZATION_NAME VARCHAR2 (240) Yes Item master organization name
ORGANIZATION_CODE VARCHAR2 (3)
Item master organization code
CROSS_REFERENCE_RANK NUMBER
Yes Establishes the Customer Item Cross Reference preference
_LA:ACTIVE_FLAG CHAR (59)
Determines if cross reference is active or not
CUSTOMER_ITEM_ID NUMBER
Yes Customer item identifier
MASTER_ORGANIZATION_ID NUMBER
Yes Item master organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
LAST_UPDATED_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATED_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_ITEM_NAME
,      _KF:ITEM_NAME
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      CROSS_REFERENCE_RANK
,      _LA:ACTIVE_FLAG
,      CUSTOMER_ITEM_ID
,      MASTER_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_CUSTOMER_ITEM_XREFS;

Dependencies

[top of page]

APPS.INVFV_CUSTOMER_ITEM_XREFS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_CUSTOMER_ITEM_XREFS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS

APPS.INVFV_CUSTOMER_ITEM_XREFS is not referenced by any database object