eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKS_USAGE_COUNTERS_V

Object Details

Object Name:	OKS_USAGE_COUNTERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_USAGE_COUNTERS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
COUNTER_GROUP_ID	NUMBER		Counter Group Identifier
COUNTER_ID	NUMBER		Counter Identifier
NAME	VARCHAR2	(181)	Counter Name
TYPE	VARCHAR2	(30)	Counter Type
UOM_CODE	VARCHAR2	(3)	Code for Unit of Measure
NET_READING	NUMBER		Counter Reading Net value
VALUE_TIMESTAMP	DATE		TimeStamp when Value is recorded
SOURCE_OBJECT_ID	NUMBER		Source Object Identifier - refers to ,OKX_COUNTER_GROUPS_V. If Usage it will be Customer Product Identifier
SOURCE_OBJECT_CODE	VARCHAR2	(30)	Source_object_code - refers to OKX_COUNTER_GROUPS_VIf Usage Source Object Code will be equal to CP
USAGE_ITEM_ID	NUMBER		Usage Item Identifier
SOURCE_DETAILS	VARCHAR2	(271)	This Can be either a contract line or a Usage Product Name. If the Source Object Code = CP then the source detail will be product name otherwise it will be service name(Contract Line Name)
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)	Current Serial Number of the product.
REFERENCE_NUMBER	VARCHAR2	(30)	Reference Number of the product
TEMPLATE_FLAG	VARCHAR2	(1)	Template Flag

Query Text

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


SELECT COUNTER_GROUP_ID
,      COUNTER_ID
,      NAME
,      TYPE
,      UOM_CODE
,      NET_READING
,      VALUE_TIMESTAMP
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_CODE
,      USAGE_ITEM_ID
,      SOURCE_DETAILS
,      CURRENT_SERIAL_NUMBER
,      REFERENCE_NUMBER
,      TEMPLATE_FLAG
FROM APPS.OKS_USAGE_COUNTERS_V;

Dependencies

[top of page]

APPS.OKS_USAGE_COUNTERS_V references the following:

APPS: CSI_COUNTERS_B; CSI_COUNTERS_TL; CSI_COUNTER_ASSOCIATIONS; CSI_COUNTER_READINGS; CSI_ITEM_INSTANCES; CS_CSI_COUNTER_GROUPS; OKC_CONTEXT - show dependent code; OKC_K_HEADERS_V; OKC_K_LINES_V; OKC_UTIL - show dependent code; OKS_AUTH_UTIL_PVT - show dependent code; OKX_SYSTEM_ITEMS_V

APPS.OKS_USAGE_COUNTERS_V is not referenced by any database object