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

VIEW: APPS.OKC_TIMEUNIT_V

Object Details
Object Name: OKC_TIMEUNIT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_TIMEUNIT_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 Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.OKC_TIMEUNIT_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKC_TIME_CODE_UNITS_B
ViewOKX_UNITS_OF_MEASURE_V
APPS.OKC_TIMEUNIT_V is referenced by following:

SchemaAPPS
Package BodyOKC_ISE_PVT - show dependent code
Package BodyOKC_SPN_PVT - show dependent code
Package BodyOKC_TAL_PVT - show dependent code
Package BodyOKC_TCU_PVT - show dependent code
Package BodyOKL_INTEREST_CALC_PVT - show dependent code