[Home] [Help]
[Dependency Information]
| Object Name: | MTL_UNITS_OF_MEASURE_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | INV.MTL_UNITS_OF_MEASURE_VL
|
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
MTL_UNITS_OF_MEASURE_VL is a view of selected columns from the table
MTL_UNITS_OF_MEASURE_TL. This view contains information about the
available Unit of Measure in the language under which Oracle Applications
is currently running at your site.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Yes | |
| UOM_CODE | VARCHAR2 | (3) | Yes | |
| UOM_CLASS | VARCHAR2 | (10) | Yes | |
| BASE_UOM_FLAG | VARCHAR2 | (1) | Yes | |
| UNIT_OF_MEASURE_TL | VARCHAR2 | (25) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| DISABLE_DATE | DATE | |||
| DESCRIPTION | VARCHAR2 | (50) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| LANGUAGE | VARCHAR2 | (4) | Yes | |
| SOURCE_LANG | VARCHAR2 | (4) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, UNIT_OF_MEASURE
, UOM_CODE
, UOM_CLASS
, BASE_UOM_FLAG
, UNIT_OF_MEASURE_TL
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DISABLE_DATE
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LANGUAGE
, SOURCE_LANG
FROM APPS.MTL_UNITS_OF_MEASURE_VL;
APPS
MTL_UNITS_OF_MEASURE_TL
APPS
AHL_ITEM_CLASS_UOM_V
AHL_ITEM_COMP_DETAIL_V
AHL_MC_ITEM_COMP_PVT
- show dependent code
AHL_MR_INTERVALS_V
AHL_OSP_ORDERS_PVT
- show dependent code
AHL_PRD_DF_PVT
- show dependent code
AHL_PRD_DISPOSITION_PVT
- show dependent code
AHL_PRD_MTLTXN_PVT
- show dependent code
AHL_RM_ROUTE_UTIL
- show dependent code
AHL_RM_ROUTE_UTIL
- show dependent code
AHL_RT_OPER_MATERIALS_V
AHL_UC_UTILIZATION_PVT
- show dependent code
AHL_UMP_UF_PVT
- show dependent code
AHL_VWP_PRICE_PVT
- show dependent code
ASO_VALIDATE_PVT
- show dependent code
AS_INV_UOM_V
BOM_GTIN_RULES
- show dependent code
CSD_CP_REFERENCE_V
CSD_ESTIMATE_DETAILS_EXT_V
CSD_PROCESS_UTIL
- show dependent code
CSD_PRODUCT_TXNS_V
CSD_RECEIVE_UTIL
- show dependent code
CSD_REPAIRS_NON_SEC_V
CSD_REPAIRS_V
CSD_REPAIR_ACTUAL_LINES_V
CSD_REPAIR_ESTIMATE_LINES_V
CSD_REPAIR_ORDER_GROUPS_V
CSD_RO_GROUP_DETAILS_V
CSD_RO_SUMMARY_V
CSF_GANTT_DATA_PKG
- show dependent code
CSF_PARAMS_PKG
- show dependent code
CSF_UTIL_PVT
- show dependent code
CSI_IIH_DETAILS_V
CSI_INSTANCE_DETAILS_V
CSI_ITEM_INSTANCE_PVT
- show dependent code
CSI_ML_UTIL_PVT
- show dependent code
CSI_TIME_BASED_CTR_ENGINE_PKG
- show dependent code
CS_ERES_INT_PKG
- show dependent code
EAM_FAILURE_ANALYSIS_PVT
- show dependent code
EAM_RES_VALIDATE_PVT
- show dependent code
EAM_SUB_RESOURCE_VALIDATE_PVT
- show dependent code
EGO_IMPORT_PVT
- show dependent code
EGO_ITEM_BULKLOAD_PKG
- show dependent code
FTE_BULK_DTT_PKG
- show dependent code
FTE_LOCATION_PARAMETERS_PKG
- show dependent code
FV_IPAC_DISBURSEMENT_PKG
- show dependent code
GMF_CMCOMMON
- show dependent code
INL_DET_LANDED_COSTS_V
INL_SHIPMENT_PVT
- show dependent code
INVIDIT1
- show dependent code
INVIDIT2
- show dependent code
INVIDIT3
- show dependent code
INVIDTMP_PKG
- show dependent code
INVPAGI2
- show dependent code
INVPPROC
- show dependent code
INVUPD2B
- show dependent code
INV_ITEM_API
- show dependent code
INV_ITEM_PVT
- show dependent code
INV_MEANING_SEL
- show dependent code
INV_MGD_MVT_UTILS_PKG
- show dependent code
INV_MINMAX_PVT
- show dependent code
ITG_SYNCITEMINBOUND_PVT
- show dependent code
JMF_GTA_ARTRX_PROC
- show dependent code
JMF_PROCESS_SHIKYU_RCV_TRX_PVT
- show dependent code
JMF_SHIKYU_ALLOCATION_PVT
- show dependent code
JMF_SHIKYU_AUTO_RCV_PROC
- show dependent code
JMF_SHIKYU_ONT_PVT
- show dependent code
JMF_SHIKYU_RPT_UTIL
- show dependent code
JMF_SUBCONTRACT_ORDERS_PVT
- show dependent code
MTL_ITEM_ATTRIBUTE_VALUES_V
MTL_ITEM_UOMS_VIEW
MTL_LOT_UOM_CONV_PVT
- show dependent code
MTL_UNITS_OF_MEASURE
MTL_UOM_CONVERSIONS_VIEW
OE_AK_CHARGE_PERIODICITY_V
OE_ID_TO_VALUE
- show dependent code
OE_VALIDATE
- show dependent code
OKE_CLE_PVT
- show dependent code
OKL_CS_ASSET_COUNTERS_UV
OKS_OMINT_PUB
- show dependent code
ONT_OEXOEACK_XMLP_PKG
- show dependent code
ONT_OEXOECOD_XMLP_PKG
- show dependent code
ONT_OEXOEITR_XMLP_PKG
- show dependent code
ONT_OEXOEOSR_XMLP_PKG
- show dependent code
ONT_OEXOESOS_XMLP_PKG
- show dependent code
ONT_OEXOEUBD_XMLP_PKG
- show dependent code
ONT_OEXOEUBK_XMLP_PKG
- show dependent code
ONT_OEXPRPRD_XMLP_PKG
- show dependent code
ONT_OEXPRPRS_XMLP_PKG
- show dependent code
OPI_DBI_REP_UOM_PKG
- show dependent code
OPI_DBI_REP_UOM_STD_CONV_PKG
- show dependent code
OZF_ADJ_NEW_PROD_PVT
- show dependent code
OZF_VOLUME_OFFER_DISC_PVT
- show dependent code
PA_CHECK_COMMITMENTS
- show dependent code
PJM_COMMITMENT_UTILS
- show dependent code
POR_SRC_SUBINV_LOV_V
POR_UNIT_OF_MEASURE_LOV_V
POR_VIEW_LINES_ALL_V
POR_VIEW_LINES_V
PO_EMAIL_GENERATE
- show dependent code
PO_LINES_SV7
- show dependent code
PO_UOM_SV2
- show dependent code
PO_VAL_LINES2
- show dependent code
QPR_SR_OM_QUOTE_LINES_V
QPR_SR_QUOTE_LINES_V
QPR_SR_UOM_CONVERSIONS_V
QP_BULK_VALIDATE
- show dependent code
QP_VALIDATE_PLL_PRICING_ATTR
- show dependent code
QP_VALIDATE_PRICE_LIST_LINE
- show dependent code
QP_VALIDATE_PRICING_ATTR
- show dependent code
RCV_FTE_LINES_V
RCV_INSERT_FROM_INL
- show dependent code
RLM_VALIDATEDEMAND_SV
- show dependent code
WIP_DEFAULT_SHOPFLOORMOVE
- show dependent code
WIP_RESOURCE_VALIDATIONS
- show dependent code
WMS_LMS_EXPECTED_RES
- show dependent code
WSH_CARRIERS_GRP
- show dependent code
WSH_CONSOL_BATCHES_V
WSH_DETAILS_VALIDATIONS
- show dependent code
WSH_PURGE_SET_V
WSH_WSHRDMBL_XMLP_PKG
- show dependent code
WSM_LBJ_INTERFACE_PVT
- show dependent code
|
|
|
|