[Home] [Help] [Dependency Information]
Object Name: | OKC_TIMEUNIT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_TIMEUNIT_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UOM_CODE | VARCHAR2 | (3) | Yes | Foreign Key to the MTL_UNITS_OF_MEASURE indicating the unit of Measure |
UNIT_OF_MEASURE | VARCHAR2 | (25) | Yes | The Translated Unit of Measure description. |
DESCRIPTION | VARCHAR2 | (50) | User entered free format text description. | |
TCE_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
TIMEUNIT | VARCHAR2 | (80) | Yes | Seeded unit of time which is also referred to as the base unit (e.g. DAY, MONTH, YEAR, MINUTE, HOUR, SECOND). |
QUANTITY | NUMBER | Yes | Quantity value. | |
INACTIVE_DATE | DATE | The date (from FND_LOOKUPS) beyond which the the code ceases to be active. | ||
ACTIVE_FLAG | VARCHAR2 | (3) | A flag to indicate whether the mapping is active.Valid values are Y and N. |
Cut, paste (and edit) the following text to query this object:
SELECT UOM_CODE
, UNIT_OF_MEASURE
, DESCRIPTION
, TCE_CODE
, TIMEUNIT
, QUANTITY
, INACTIVE_DATE
, ACTIVE_FLAG
FROM APPS.OKC_TIMEUNIT_V;
|
|
|