[Home] [Help] [Dependency Information]
Object Name: | OKS_USAGE_COUNTERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_USAGE_COUNTERS_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | 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 |
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;
APPS.OKS_USAGE_COUNTERS_V is not referenced by any database object
|
|
|