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


VIEW: APPS.INVFV_MANUFACTURERS

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

View Type

A Business Intelligence System view


This shows definitions of manufacturers of items defined in Oracle Inventory. This information may be used to search for items by manufacturer or by manufacturer's part number.


[View Source]

Columns
Name Datatype Length Mandatory Comments
MANUFACTURER_NAME VARCHAR2 (30) Yes
DESCRIPTION VARCHAR2 (240)

_DF CHAR (28)
Descriptive flexfield
MANUFACTURER_ID NUMBER
Yes
LAST_UPDATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATED_DATE DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT MANUFACTURER_NAME
,      DESCRIPTION
,      _DF
,      MANUFACTURER_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVFV_MANUFACTURERS;

Dependencies

[top of page]

APPS.INVFV_MANUFACTURERS references the following:

SchemaAPPS
SynonymMTL_MANUFACTURERS

APPS.INVFV_MANUFACTURERS is not referenced by any database object