[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: | INV.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:
-
APPS
-
MTL_SYSTEM_ITEMS_B
-
MTL_UNITS_OF_MEASURE
-
MTL_UNITS_OF_MEASURE_VL
-
MTL_UOM_CLASS_CONVERSIONS
-
MTL_UOM_CONVERSIONS
APPS.MTL_ITEM_UOMS_VIEW is referenced by following:
-
APPS
-
ARP_TRX_LINE_UTIL
- show dependent code
-
AR_INVOICE_UTILS
- show dependent code
-
ASO_ATP_INT
- show dependent code
-
ASO_I_ITEM_UOMS_V
-
ASO_VALIDATE_PVT
- show dependent code
-
CSD_ESTIMATE_UTILS_PVT
- show dependent code
-
CSD_LOGISTICS_UTIL
- show dependent code
-
CSP_PARTS_ORDER
- show dependent code
-
CSP_REQUIREMENT_LINES_PUB
- show dependent code
-
CSP_TRANSACTIONS_PUB
- show dependent code
-
CS_CHARGE_DETAILS_PVT
- show dependent code
-
CS_COST_DETAILS_PVT
- show dependent code
-
GML_MOBILE_RECEIPT
- show dependent code
-
GML_RCV_DIR_RCPT_APIS
- show dependent code
-
IBE_CATALOG_PVT
- show dependent code
-
INVPVDR6
- show dependent code
-
INV_CONVERT
- show dependent code
-
INV_LABEL_PVT1
- show dependent code
-
INV_LOGICAL_TRANSACTIONS_PVT
- show dependent code
-
INV_PROCESS_TEMP
- show dependent code
-
INV_QTY_MANAGEMENT
- show dependent code
-
INV_RCV_DIR_RCPT_APIS
- show dependent code
-
INV_RCV_INTEGRATION_PVT
- show dependent code
-
INV_RCV_STD_DELIVER_APIS
- show dependent code
-
INV_RCV_STD_RCPT_APIS
- show dependent code
-
INV_RCV_STD_TRANSFER_APIS
- show dependent code
-
INV_TRANSACTION_LOVS
- show dependent code
-
INV_TXN_MANAGER_GRP
- show dependent code
-
INV_UI_ITEM_LOVS
- show dependent code
-
MTL_INV_VALIDATE_GRP
- show dependent code
-
OE_ID_TO_VALUE
- show dependent code
-
OE_OE_FORM_LINE
- show dependent code
-
OE_VALIDATE_LINE
- show dependent code
-
OKE_AMG_GRP
- show dependent code
-
OKE_CLE_PVT
- show dependent code
-
OKE_DELIVERABLE_PVT
- show dependent code
-
OZF_ADJ_NEW_PROD_PVT
- show dependent code
-
OZF_SD_REQUEST_PUB
- show dependent code
-
OZF_VOLUME_OFFER_DISC_PVT
- show dependent code
-
PON_VALIDATE_ITEM_PRICES_INT
- show dependent code
-
PO_R12_CAT_UPG_VAL_PVT
- show dependent code
-
PO_VAL_LINES2
- show dependent code
-
QA_PLAN_ELEMENT_API
- show dependent code
-
QP_BULK_VALIDATE
- show dependent code
-
QP_VALIDATE_PLL_PRICING_ATTR
- show dependent code
-
QP_VALIDATE_PRICING_ATTR
- show dependent code
-
RCV_ROI_TRANSACTION
- show dependent code
-
RCV_TRANSACTIONS_INTERFACE_SV
- show dependent code
-
WIP_MOVE_VALIDATOR
- show dependent code
-
WMS_CATCH_WEIGHT_PVT
- show dependent code
-
WMS_RETURN_SV
- show dependent code
-
WSH_UTIL_VALIDATE
- show dependent code