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

VIEW: APPS.OKX_TUOM_V

Object Details
Object Name: OKX_TUOM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_TUOM_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 VARCHAR2 (3) Yes Primary key column. Abbreviated unit of measure code
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (25) Yes Unit of measure name
DESCRIPTION VARCHAR2 (50)
Description
UNIT_OF_MEASURE VARCHAR2 (25) Yes Unit of measure name
UOM_CODE VARCHAR2 (3) Yes Abbreviated unit of measure code
UOM_CLASS VARCHAR2 (10) Yes Unit of measure class
BASE_UOM_FLAG VARCHAR2 (1) Yes Base unit of measure flag
UNIT_OF_MEASURE_TL VARCHAR2 (25) Yes Unit of measure name translation
SOURCE_LANG VARCHAR2 (4) Yes SOURCE_LANG indicated the Actual language code of the row
START_DATE_ACTIVE DATE

Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS VARCHAR2 (1)
Indicates whether uom code is active or inactive
PRIMARY_UOM_CODE VARCHAR2 (3) Yes Primary unit of measure code
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      UNIT_OF_MEASURE
,      UOM_CODE
,      UOM_CLASS
,      BASE_UOM_FLAG
,      UNIT_OF_MEASURE_TL
,      SOURCE_LANG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
FROM APPS.OKX_TUOM_V;

Dependencies

[top of page]

APPS.OKX_TUOM_V references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE_TL
APPS.OKX_TUOM_V is referenced by following:

SchemaAPPS
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code