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_COUNTER_GROUPS_V

Object Details

Object Name:	OKX_COUNTER_GROUPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_COUNTER_GROUPS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Displays the counter groups. The records can be one of the following : the counter group templates or the counter group instances instantiated from a template.
The counter group templates are the ones attached to a master entity. In 11i, the only master entities supported are the serviceable products and service items from the item master.
The counter group instances are the ones attached to the instance of the master entity. The instances of the item master can either be a product in the installed base or a contract line in Oracle Contracts. Counter group instances are automatically instantiated when the product is instantiated in the installed base or a contract line is created in Contracts.
These counter group instances will have the CREATED_FROM_CTR_GRP_TMPL_ID as the identifier of the template.
The counter group templates will have the CREATE_FROM_CTR_GRP_TMPL_ID as NULL.
When the counter group is instantiated from a template, the SOURCE_COUNTER_GROUP_ID is also populated with the identifier of the template. The attributes of this counter group instance can then be over-written. When it is over-written, the SOURCE_COUNTER_GROUP_ID becomes NULL indicating that any changes to the template will not cascade to this counter group.
The ASSOCIATION_TYPE indicates the formula capabilities of the counter group.
For a counter group, if the value of this column is 'PROD_ITEM' or 'SVC_ITEM', then the formula counters within the counter group can only be based on the counters within that counter group.
If it is 'BOM' then the formula counters can be based on any counter within the configuration.

[View Source]

Columns

Name	Datatype	Length	Comments
COUNTER_GROUP_ID	NUMBER		Counter Group unique identifier
NAME	VARCHAR2	(100)	Counter group name
DESCRIPTION	VARCHAR2	(240)	Description
TEMPLATE_FLAG	VARCHAR2	(1)	Counter group template flag
START_DATE_ACTIVE	DATE		Date record becomes active
END_DATE_ACTIVE	DATE		Date record becomes inactive
ASSOCIATION_TYPE	VARCHAR2	(30)	See table description.
SOURCE_OBJECT_CODE	VARCHAR2	(30)	Valid only for instances. Can be either 'CP' or 'CTR_CONTRACT_LINE'.
SOURCE_OBJECT_ID	NUMBER		Mandatory only for instances. This must be valid for a particular SOURCE_OBJECT_CODE.
CREATED_FROM_CTR_GRP_TMPL_ID	NUMBER		See table description.
SOURCE_COUNTER_GROUP_ID	NUMBER		See table description.

Query Text

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


SELECT COUNTER_GROUP_ID
,      NAME
,      DESCRIPTION
,      TEMPLATE_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ASSOCIATION_TYPE
,      SOURCE_OBJECT_CODE
,      SOURCE_OBJECT_ID
,      CREATED_FROM_CTR_GRP_TMPL_ID
,      SOURCE_COUNTER_GROUP_ID
FROM APPS.OKX_COUNTER_GROUPS_V;

Dependencies

[top of page]

APPS.OKX_COUNTER_GROUPS_V references the following:

APPS: CS_COUNTER_GROUPS

APPS.OKX_COUNTER_GROUPS_V is referenced by following:

APPS: OKC_CG_UPD_ASMBLR_PVT - show dependent code; OKC_CNH_PVT - show dependent code; OKC_INST_CND_PVT - show dependent code; OKS_BILLPRST_USGSUBLINE_V; OKS_COUNTERS_V; OKS_COVERAGES_PVT - show dependent code; OKS_SETUP_UTIL_PUB - show dependent code; OKS_TEMPLATE_COUNTERS_V