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


VIEW: APPS.BIL_DIMV_UOM

Object Details
Object Name: BIL_DIMV_UOM
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIL.BIL_DIMV_UOM
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


BIL_DIMV_UOM - Dimension view used to provide descriptive in information for materials
management units of measure.
.
Source is Oracle Applications Materials Management schema.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure name
UOM_CODE VARCHAR2 (30)
Abbreviated unit of measure code
UOM_CLASS VARCHAR2 (10)
Unit of measure class
UOM_DISABLE_DATE DATE

Date when the unit can no longer be used to define conversions
UOM_DESCRIPTION VARCHAR2 (240)
Unit of measure description
BASE_UOM_FLAG VARCHAR2 (1)
Base unit of measure flag
ID VARCHAR2 (30)
Abbreviated unit of measure code
VALUE VARCHAR2 (25)
Unit of measure name
Query Text

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


SELECT UNIT_OF_MEASURE
,      UOM_CODE
,      UOM_CLASS
,      UOM_DISABLE_DATE
,      UOM_DESCRIPTION
,      BASE_UOM_FLAG
,      ID
,      VALUE
FROM APPS.BIL_DIMV_UOM;

Dependencies

[top of page]

APPS.BIL_DIMV_UOM references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymMTL_UNITS_OF_MEASURE_TL

APPS.BIL_DIMV_UOM is not referenced by any database object