[Home] [Help] [Dependency Information]
Object Name: | OKC_TIME_CODE_UNITS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_TIME_CODE_UNITS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
time units of measure do not convert correctly using the mtl conversion mechanism
eg. how many days are there in a month?
conversions and time additions therefore require coding
units of measure are user definable
but the coding needs to know what time unit a particular uom represents
in order for the coded datetime arithmetic to work
it needs to know, for instance, that MTH is 1 month
(or perhaps it's MON - depends on the user uom setup)
this intersection allows user definable uom to be associated
to a known fixed set of time units understandable to the coding stored as lookups
it also contains the factor
eg. FM (user defined uom financial month) = 4 * WEEK (a fixed and understood time unit)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
UOM_CODE | VARCHAR2 | (3) | Yes | Unit of measure code. Refers to uom_code in MTL_UNITS_OF_MEASURE where uom_class = �Time�. |
TCE_CODE | VARCHAR2 | (30) | Yes | Time conversion code. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE=�OKC_TIME� |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Indicates a value was changed in another language. Not fully implemented in 11i |
QUANTITY | NUMBER | Yes | Quantity value. | |
SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format abbreviated text description. | |
DESCRIPTION | VARCHAR2 | (1995) | User entered free format text description. | |
COMMENTS | VARCHAR2 | (1995) | User entered comment. | |
ACTIVE_FLAG | VARCHAR2 | (3) | A flag to indicate whether the mapping is active.Valid values are Y and N | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, UOM_CODE
, TCE_CODE
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, QUANTITY
, SHORT_DESCRIPTION
, DESCRIPTION
, COMMENTS
, ACTIVE_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKC_TIME_CODE_UNITS_V;
|
|
|