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

VIEW: APPS.MTL_SYSTEM_ITEMS_ER4_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization Code
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
MASTER_ORGANIZATION_ID NUMBER
Yes Master Organization Identifier
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (4000)
Primary UOM
TRACKING_QUANTITY VARCHAR2 (4000)
Tracking UOM
ONT_PRICING_QTY_SOURCE VARCHAR2 (4000)
Pricing UOM
SECONDARY_UOM VARCHAR2 (4000)
Secondary UOM
SECONDARY_DEFAULT_IND VARCHAR2 (4000)
Defaulting
DUAL_UOM_DEVIATION_HIGH NUMBER

Deviation Factor +
DUAL_UOM_DEVIATION_LOW NUMBER

Deviation Factor -
Query Text

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


SELECT ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      MASTER_ORGANIZATION_ID
,      PRIMARY_UNIT_OF_MEASURE
,      TRACKING_QUANTITY
,      ONT_PRICING_QTY_SOURCE
,      SECONDARY_UOM
,      SECONDARY_DEFAULT_IND
,      DUAL_UOM_DEVIATION_HIGH
,      DUAL_UOM_DEVIATION_LOW
FROM APPS.MTL_SYSTEM_ITEMS_ER4_V;

Dependencies

[top of page]

APPS.MTL_SYSTEM_ITEMS_ER4_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageINV_MEANING_SEL - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_B

APPS.MTL_SYSTEM_ITEMS_ER4_V is not referenced by any database object