[Home] [Help]
[Dependency Information]
| Object Name: | MTL_ITEM_UOMS_VIEW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | INV.MTL_ITEM_UOMS_VIEW
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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 |
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;
APPS
MTL_SYSTEM_ITEMS_B
MTL_UNITS_OF_MEASURE
MTL_UNITS_OF_MEASURE_VL
MTL_UOM_CLASS_CONVERSIONS
MTL_UOM_CONVERSIONS
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
|
|
|
|