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.OKX_COUNTERS_V

Object Details

Object Name:	OKX_COUNTERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_COUNTERS_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 Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ID1	NUMBER		The identifier of the counter.
ID2	CHAR	(1)	(Multi-part) Primary Key
COUNTER_ID	NUMBER		Counter identifier
COUNTER_GROUP_ID	NUMBER		The identifier of the counter group to which the counter belongs
NAME	VARCHAR2	(80)	Counter Name
DESCRIPTION	VARCHAR2	(240)	Description
TYPE	VARCHAR2	(30)	Indicates whether the counter is a regular, formula-based, time-based or a SQL-derived counter.
START_DATE_ACTIVE	DATE		Date record becomes active
END_DATE_ACTIVE	DATE		Date record becomes inactive
CREATED_FROM_COUNTER_TMPL_ID	NUMBER		Created from counter template identifier
SOURCE_COUNTER_ID	NUMBER		Source counter identifier
INITIAL_READING	NUMBER		The initial reading of a counter template or an instance. Valid only for regular counters.
UOM_CODE	VARCHAR2	(3)	The unit of measure of the counter reading.
USAGE_ITEM_ID	NUMBER		The item that keeps track of the usage of this counter. Can only be the item which has the USAGE_ITEM_FLAG set to 'Y'.
CTR_VAL_MAX_SEQ_NO	NUMBER		The current maximum sequence number of the counter values being updated in this log.
COUNTER_VALUE_ID	NUMBER		The identifier of the counter value.
VALUE_TIMESTAMP	DATE		The date on which this counter reading was taken (maybe different from the date on which the reading is enteerd in the system).
COUNTER_READING	NUMBER		The counter reading.
NET_READING	NUMBER		Net reading
STATUS	VARCHAR2	(1)	Status
PRIMARY_UOM_CODE	VARCHAR2	(3)	Primary UOM code, needed for UOMs list for lines.

Query Text

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


SELECT ID1
,      ID2
,      COUNTER_ID
,      COUNTER_GROUP_ID
,      NAME
,      DESCRIPTION
,      TYPE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_FROM_COUNTER_TMPL_ID
,      SOURCE_COUNTER_ID
,      INITIAL_READING
,      UOM_CODE
,      USAGE_ITEM_ID
,      CTR_VAL_MAX_SEQ_NO
,      COUNTER_VALUE_ID
,      VALUE_TIMESTAMP
,      COUNTER_READING
,      NET_READING
,      STATUS
,      PRIMARY_UOM_CODE
FROM APPS.OKX_COUNTERS_V;

Dependencies

[top of page]

APPS.OKX_COUNTERS_V references the following:

APPS: CSI_COUNTERS_BC_V; CSI_COUNTER_READINGS; OKS_AUTH_UTIL_PVT - show dependent code

APPS.OKX_COUNTERS_V is referenced by following:

APPS: OKC_CNL_PVT - show dependent code; OKC_CONDITIONS_PVT - show dependent code; OKC_INST_CND_PVT - show dependent code; OKS_BILLPRST_USGSUBLINE_V; OKS_COUNTERS_V; OKS_EXTWAR_UTIL_PVT - show dependent code; OKS_TEMPLATE_COUNTERS_V; OKS_USAGE_COUNTERS_V