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


VIEW: APPS.MTL_ITEM_UOMS_VIEW

Object Details
Object Name: MTL_ITEM_UOMS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_ITEM_UOMS_VIEW
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_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
UOM_TYPE NUMBER

Allowed unit of measure conversion type
UOM_CODE VARCHAR2 (3) Yes Abbreviated unit of measure code
UNIT_OF_MEASURE VARCHAR2 (25) Yes Unit of measure name
UNIT_OF_MEASURE_TL VARCHAR2 (25) Yes
DESCRIPTION VARCHAR2 (50)
Unit of measure description
UOM_CLASS VARCHAR2 (10) Yes Unit of measure class
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      UOM_TYPE
,      UOM_CODE
,      UNIT_OF_MEASURE
,      UNIT_OF_MEASURE_TL
,      DESCRIPTION
,      UOM_CLASS
FROM APPS.MTL_ITEM_UOMS_VIEW;

Dependencies

[top of page]

APPS.MTL_ITEM_UOMS_VIEW references the following:

SchemaAPPS
SynonymMTL_SYSTEM_ITEMS_B
SynonymMTL_UNITS_OF_MEASURE
ViewMTL_UNITS_OF_MEASURE_VL
SynonymMTL_UOM_CLASS_CONVERSIONS
SynonymMTL_UOM_CONVERSIONS
APPS.MTL_ITEM_UOMS_VIEW is referenced by following:

SchemaAPPS
Package BodyARP_TRX_LINE_UTIL - show dependent code
Package BodyAR_INVOICE_UTILS - show dependent code
Package BodyASO_ATP_INT - show dependent code
ViewASO_I_ITEM_UOMS_V
Package BodyASO_VALIDATE_PVT - show dependent code
Package BodyCSD_ESTIMATE_UTILS_PVT - show dependent code
Package BodyCSD_LOGISTICS_UTIL - show dependent code
Package BodyCSP_PARTS_ORDER - show dependent code
Package BodyCSP_REQUIREMENT_LINES_PUB - show dependent code
Package BodyCSP_TRANSACTIONS_PUB - show dependent code
Package BodyCS_CHARGE_DETAILS_PVT - show dependent code
Package BodyCS_COST_DETAILS_PVT - show dependent code
Package BodyGML_MOBILE_RECEIPT - show dependent code
Package BodyGML_RCV_DIR_RCPT_APIS - show dependent code
Package BodyIBE_CATALOG_PVT - show dependent code
Package BodyINVPVDR6 - show dependent code
Package BodyINV_CONVERT - show dependent code
Package BodyINV_LABEL_PVT1 - show dependent code
Package BodyINV_LOGICAL_TRANSACTIONS_PVT - show dependent code
Package BodyINV_PROCESS_TEMP - show dependent code
Package BodyINV_QTY_MANAGEMENT - show dependent code
Package BodyINV_RCV_DIR_RCPT_APIS - show dependent code
Package BodyINV_RCV_INTEGRATION_PVT - show dependent code
Package BodyINV_RCV_STD_DELIVER_APIS - show dependent code
Package BodyINV_RCV_STD_RCPT_APIS - show dependent code
Package BodyINV_RCV_STD_TRANSFER_APIS - show dependent code
Package BodyINV_TRANSACTION_LOVS - show dependent code
Package BodyINV_TXN_MANAGER_GRP - show dependent code
Package BodyINV_UI_ITEM_LOVS - show dependent code
Package BodyMTL_INV_VALIDATE_GRP - show dependent code
Package BodyOE_ID_TO_VALUE - show dependent code
Package BodyOE_OE_FORM_LINE - show dependent code
Package BodyOE_VALIDATE_LINE - show dependent code
Package BodyOKE_AMG_GRP - show dependent code
Package BodyOKE_CLE_PVT - show dependent code
Package BodyOKE_DELIVERABLE_PVT - show dependent code
Package BodyOZF_ADJ_NEW_PROD_PVT - show dependent code
Package BodyOZF_SD_REQUEST_PUB - show dependent code
Package BodyOZF_VOLUME_OFFER_DISC_PVT - show dependent code
Package BodyPON_VALIDATE_ITEM_PRICES_INT - show dependent code
Package BodyPO_R12_CAT_UPG_VAL_PVT - show dependent code
Package BodyPO_VAL_LINES2 - show dependent code
Package BodyQA_PLAN_ELEMENT_API - show dependent code
Package BodyQP_BULK_VALIDATE - show dependent code
Package BodyQP_VALIDATE_PLL_PRICING_ATTR - show dependent code
Package BodyQP_VALIDATE_PRICING_ATTR - show dependent code
Package BodyRCV_ROI_TRANSACTION - show dependent code
Package BodyRCV_TRANSACTIONS_INTERFACE_SV - show dependent code
Package BodyWIP_MOVE_VALIDATOR - show dependent code
Package BodyWMS_CATCH_WEIGHT_PVT - show dependent code
Package BodyWMS_RETURN_SV - show dependent code
Package BodyWSH_UTIL_VALIDATE - show dependent code