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

VIEW: INV.MTL_LOT_UOM_CLASS_CONVERSIONS#

Object Details
Object Name: MTL_LOT_UOM_CLASS_CONVERSIONS#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONVERSION_ID NUMBER
Yes
LOT_NUMBER VARCHAR2 (80) Yes
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
FROM_UNIT_OF_MEASURE VARCHAR2 (25) Yes
FROM_UOM_CODE VARCHAR2 (3) Yes
FROM_UOM_CLASS VARCHAR2 (10) Yes
TO_UNIT_OF_MEASURE VARCHAR2 (25) Yes
TO_UOM_CODE VARCHAR2 (3) Yes
TO_UOM_CLASS VARCHAR2 (10) Yes
CONVERSION_RATE NUMBER
Yes
DISABLE_DATE DATE

EVENT_SPEC_DISP_ID NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT CONVERSION_ID
,      LOT_NUMBER
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      FROM_UNIT_OF_MEASURE
,      FROM_UOM_CODE
,      FROM_UOM_CLASS
,      TO_UNIT_OF_MEASURE
,      TO_UOM_CODE
,      TO_UOM_CLASS
,      CONVERSION_RATE
,      DISABLE_DATE
,      EVENT_SPEC_DISP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM INV.MTL_LOT_UOM_CLASS_CONVERSIONS#;

Dependencies

[top of page]

INV.MTL_LOT_UOM_CLASS_CONVERSIONS# references the following:

SchemaINV
TableMTL_LOT_UOM_CLASS_CONVERSIONS
INV.MTL_LOT_UOM_CLASS_CONVERSIONS# is referenced by following:

SchemaAPPS
SynonymMTL_LOT_UOM_CLASS_CONVERSIONS