[Home] [Help] [Dependency Information]

VIEW: APPS.OKC_TIME_CODE_UNITS_V

Object Details

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

View Type

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)

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

APPS

OKC_TIME_CODE_UNITS_B

OKC_TIME_CODE_UNITS_TL

APPS

CSI_COUNTER_READINGS_PVT - show dependent code

OKC_TCU_PVT - show dependent code

OKC_TCU_PVT - show dependent code

OKC_TIME_UTIL_PVT - show dependent code

OKL_OPEN_INTERFACE_PVT - show dependent code

OKS_BILLING_PROFILES_PUB - show dependent code

OKS_BILLING_PROFILES_PVT - show dependent code

OKS_BILLING_PUB - show dependent code

OKS_BILL_REC_PUB - show dependent code

OKS_BILL_UTIL_PUB - show dependent code

OKS_BPE_PVT - show dependent code

OKS_CUSTOMER_ACCEPTANCE_PVT - show dependent code

OKS_ENTITLEMENTS_PVT - show dependent code

OKS_EXTWARPRGM_PVT - show dependent code

OKS_EXTWAR_UTIL_PVT - show dependent code

OKS_IMPORT_VALIDATE - show dependent code

OKS_OMINT_PUB - show dependent code

OKS_REPRICE_PVT - show dependent code

OKS_SUBSCRIPTION_PVT - show dependent code

OKS_TIME_CODE_UNITS_V

OKS_TIME_MEASURES_PUB - show dependent code

OKS_UPGRADE_PRECHECK - show dependent code

OKS_USAGE_SETTLE_PUB - show dependent code