[Home] [Help] [Dependency Information]
Object Name: | OKS_COUNTERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_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.This will be Contract Line Identifier | ||
SOURCE_OBJECT_CODE | VARCHAR2 | (30) | Source object code - refers to OKX_COUNTER_GROUPS_V. It will be CONTRACT_LINE | |
TEMPLATE_FLAG | VARCHAR2 | (1) |
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
, TEMPLATE_FLAG
FROM APPS.OKS_COUNTERS_V;
APPS.OKS_COUNTERS_V is not referenced by any database object
|
|
|