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

VIEW: APPS.INVFV_MFG_PART_NUMBERS

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

View Type

A Business Intelligence System view


This shows the cross-reference between an item defined in Oracle Inventory and the part number used by its manufacturer. This information can be used to perform item searches by manufacturer's part number.


[View Source]

Columns
Name Datatype Length Mandatory Comments
MANUFACTURERS_PART_NUMBER VARCHAR2 (150) Yes Manufacturer's part number
MANUFACTURER_NAME VARCHAR2 (30) Yes Name of manufacturer
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
_KF:ITEM_NAME CHAR (15)
Item name
_DF CHAR (31)
Descriptive flexfield
MANUFACTURER_ID NUMBER
Yes Manufacturer identifier
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 MANUFACTURERS_PART_NUMBER
,      MANUFACTURER_NAME
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      _KF:ITEM_NAME
,      _DF
,      MANUFACTURER_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_MFG_PART_NUMBERS;

Dependencies

[top of page]

APPS.INVFV_MFG_PART_NUMBERS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_MANUFACTURERS
SynonymMTL_MFG_PART_NUMBERS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS

APPS.INVFV_MFG_PART_NUMBERS is not referenced by any database object