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


VIEW: APPS.MTL_UNITS_OF_MEASURE_VL

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

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.MTL_UNITS_OF_MEASURE_VL references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE_TL
APPS.MTL_UNITS_OF_MEASURE_VL is referenced by following:

SchemaAPPS
ViewAHL_ITEM_CLASS_UOM_V
ViewAHL_ITEM_COMP_DETAIL_V
Package BodyAHL_MC_ITEM_COMP_PVT - show dependent code
ViewAHL_MR_INTERVALS_V
Package BodyAHL_OSP_ORDERS_PVT - show dependent code
Package BodyAHL_PRD_DF_PVT - show dependent code
Package BodyAHL_PRD_DISPOSITION_PVT - show dependent code
Package BodyAHL_PRD_MTLTXN_PVT - show dependent code
Package BodyAHL_RM_ROUTE_UTIL - show dependent code
PL/SQL PackageAHL_RM_ROUTE_UTIL - show dependent code
ViewAHL_RT_OPER_MATERIALS_V
Package BodyAHL_UC_UTILIZATION_PVT - show dependent code
Package BodyAHL_UMP_UF_PVT - show dependent code
Package BodyAHL_VWP_PRICE_PVT - show dependent code
Package BodyASO_VALIDATE_PVT - show dependent code
ViewAS_INV_UOM_V
Package BodyBOM_GTIN_RULES - show dependent code
ViewCSD_CP_REFERENCE_V
ViewCSD_ESTIMATE_DETAILS_EXT_V
Package BodyCSD_PROCESS_UTIL - show dependent code
ViewCSD_PRODUCT_TXNS_V
Package BodyCSD_RECEIVE_UTIL - show dependent code
ViewCSD_REPAIRS_NON_SEC_V
ViewCSD_REPAIRS_V
ViewCSD_REPAIR_ACTUAL_LINES_V
ViewCSD_REPAIR_ESTIMATE_LINES_V
ViewCSD_REPAIR_ORDER_GROUPS_V
ViewCSD_RO_GROUP_DETAILS_V
ViewCSD_RO_SUMMARY_V
Package BodyCSF_GANTT_DATA_PKG - show dependent code
Package BodyCSF_PARAMS_PKG - show dependent code
Package BodyCSF_UTIL_PVT - show dependent code
ViewCSI_IIH_DETAILS_V
ViewCSI_INSTANCE_DETAILS_V
Package BodyCSI_ITEM_INSTANCE_PVT - show dependent code
Package BodyCSI_ML_UTIL_PVT - show dependent code
Package BodyCSI_TIME_BASED_CTR_ENGINE_PKG - show dependent code
Package BodyCS_ERES_INT_PKG - show dependent code
Package BodyEAM_FAILURE_ANALYSIS_PVT - show dependent code
Package BodyEAM_RES_VALIDATE_PVT - show dependent code
Package BodyEAM_SUB_RESOURCE_VALIDATE_PVT - show dependent code
Package BodyEGO_IMPORT_PVT - show dependent code
Package BodyEGO_ITEM_BULKLOAD_PKG - show dependent code
Package BodyFTE_BULK_DTT_PKG - show dependent code
Package BodyFTE_LOCATION_PARAMETERS_PKG - show dependent code
Package BodyFV_IPAC_DISBURSEMENT_PKG - show dependent code
Package BodyGMF_CMCOMMON - show dependent code
ViewINL_DET_LANDED_COSTS_V
Package BodyINL_SHIPMENT_PVT - show dependent code
Package BodyINVIDIT1 - show dependent code
Package BodyINVIDIT2 - show dependent code
Package BodyINVIDIT3 - show dependent code
Package BodyINVIDTMP_PKG - show dependent code
Package BodyINVPAGI2 - show dependent code
Package BodyINVPPROC - show dependent code
Package BodyINVUPD2B - show dependent code
Package BodyINV_ITEM_API - show dependent code
Package BodyINV_ITEM_PVT - show dependent code
Package BodyINV_MEANING_SEL - show dependent code
Package BodyINV_MGD_MVT_UTILS_PKG - show dependent code
Package BodyINV_MINMAX_PVT - show dependent code
Package BodyITG_SYNCITEMINBOUND_PVT - show dependent code
Package BodyJMF_GTA_ARTRX_PROC - show dependent code
Package BodyJMF_PROCESS_SHIKYU_RCV_TRX_PVT - show dependent code
Package BodyJMF_SHIKYU_ALLOCATION_PVT - show dependent code
Package BodyJMF_SHIKYU_AUTO_RCV_PROC - show dependent code
Package BodyJMF_SHIKYU_ONT_PVT - show dependent code
Package BodyJMF_SHIKYU_RPT_UTIL - show dependent code
Package BodyJMF_SUBCONTRACT_ORDERS_PVT - show dependent code
ViewMTL_ITEM_ATTRIBUTE_VALUES_V
ViewMTL_ITEM_UOMS_VIEW
Package BodyMTL_LOT_UOM_CONV_PVT - show dependent code
SynonymMTL_UNITS_OF_MEASURE
ViewMTL_UOM_CONVERSIONS_VIEW
ViewOE_AK_CHARGE_PERIODICITY_V
Package BodyOE_ID_TO_VALUE - show dependent code
Package BodyOE_VALIDATE - show dependent code
Package BodyOKE_CLE_PVT - show dependent code
ViewOKL_CS_ASSET_COUNTERS_UV
Package BodyOKS_OMINT_PUB - show dependent code
Package BodyONT_OEXOEACK_XMLP_PKG - show dependent code
Package BodyONT_OEXOECOD_XMLP_PKG - show dependent code
Package BodyONT_OEXOEITR_XMLP_PKG - show dependent code
Package BodyONT_OEXOEOSR_XMLP_PKG - show dependent code
Package BodyONT_OEXOESOS_XMLP_PKG - show dependent code
Package BodyONT_OEXOEUBD_XMLP_PKG - show dependent code
Package BodyONT_OEXOEUBK_XMLP_PKG - show dependent code
Package BodyONT_OEXPRPRD_XMLP_PKG - show dependent code
Package BodyONT_OEXPRPRS_XMLP_PKG - show dependent code
Package BodyOPI_DBI_REP_UOM_PKG - show dependent code
Package BodyOPI_DBI_REP_UOM_STD_CONV_PKG - show dependent code
Package BodyOZF_ADJ_NEW_PROD_PVT - show dependent code
Package BodyOZF_VOLUME_OFFER_DISC_PVT - show dependent code
Package BodyPA_CHECK_COMMITMENTS - show dependent code
Package BodyPJM_COMMITMENT_UTILS - show dependent code
ViewPOR_SRC_SUBINV_LOV_V
ViewPOR_UNIT_OF_MEASURE_LOV_V
ViewPOR_VIEW_LINES_ALL_V
ViewPOR_VIEW_LINES_V
Package BodyPO_EMAIL_GENERATE - show dependent code
Package BodyPO_LINES_SV7 - show dependent code
Package BodyPO_UOM_SV2 - show dependent code
Package BodyPO_VAL_LINES2 - show dependent code
ViewQPR_SR_OM_QUOTE_LINES_V
ViewQPR_SR_QUOTE_LINES_V
ViewQPR_SR_UOM_CONVERSIONS_V
Package BodyQP_BULK_VALIDATE - show dependent code
Package BodyQP_VALIDATE_PLL_PRICING_ATTR - show dependent code
Package BodyQP_VALIDATE_PRICE_LIST_LINE - show dependent code
Package BodyQP_VALIDATE_PRICING_ATTR - show dependent code
ViewRCV_FTE_LINES_V
Package BodyRCV_INSERT_FROM_INL - show dependent code
Package BodyRLM_VALIDATEDEMAND_SV - show dependent code
Package BodyWIP_DEFAULT_SHOPFLOORMOVE - show dependent code
Package BodyWIP_RESOURCE_VALIDATIONS - show dependent code
Package BodyWMS_LMS_EXPECTED_RES - show dependent code
Package BodyWSH_CARRIERS_GRP - show dependent code
ViewWSH_CONSOL_BATCHES_V
Package BodyWSH_DETAILS_VALIDATIONS - show dependent code
ViewWSH_PURGE_SET_V
Package BodyWSH_WSHRDMBL_XMLP_PKG - show dependent code
Package BodyWSM_LBJ_INTERFACE_PVT - show dependent code