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


VIEW: APPS.OKL_CS_ASSET_COUNTERS_UV

Object Details
Object Name: OKL_CS_ASSET_COUNTERS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_ASSET_COUNTERS_UV
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 Mandatory Comments
CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
ASSET_NUMBER VARCHAR2 (15)
Asset Number
ITEM_DESCRIPTION VARCHAR2 (240)
SERIAL_NUMBER VARCHAR2 (30)
QUANTITY NUMBER

COUNTER_NAME VARCHAR2 (80)
CONSOLIDATED_COUNTER_NAME VARCHAR2 (150)
LAST_READING_DATE DATE

LAST_READING NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
COUNTER_ID NUMBER

ASSET_ID NUMBER (15)
CLL_ID NUMBER

Foreign key to view OKL_CNTR_LVLNG_LNS_V
CLG_ID NUMBER

Foreign key to view OKL_CNTR_LVLNG_GRPS_V
KHR_ID NUMBER

Foreign key to view OKL_K_HEADERS_V
PARENT_LINE_ID NUMBER

Query Text

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


SELECT CONTRACT_NUMBER
,      ASSET_NUMBER
,      ITEM_DESCRIPTION
,      SERIAL_NUMBER
,      QUANTITY
,      COUNTER_NAME
,      CONSOLIDATED_COUNTER_NAME
,      LAST_READING_DATE
,      LAST_READING
,      UNIT_OF_MEASURE
,      COUNTER_ID
,      ASSET_ID
,      CLL_ID
,      CLG_ID
,      KHR_ID
,      PARENT_LINE_ID
FROM APPS.OKL_CS_ASSET_COUNTERS_UV;

Dependencies

[top of page]

APPS.OKL_CS_ASSET_COUNTERS_UV references the following:

SchemaAPPS
PL/SQL PackageCSI_COUNTER_READINGS_PVT - show dependent code
SynonymCSI_ITEM_INSTANCES
SynonymCS_COUNTERS
SynonymCS_COUNTER_GROUPS
SynonymCS_COUNTER_VALUES
SynonymFA_ADDITIONS_B
ViewMTL_SYSTEM_ITEMS_VL
ViewMTL_UNITS_OF_MEASURE_VL
SynonymOKC_K_HEADERS_B
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_LINE_STYLES_B
ViewOKL_CNTR_LVLNG_GRPS_V
SynonymOKL_CNTR_LVLNG_LNS_B

APPS.OKL_CS_ASSET_COUNTERS_UV is not referenced by any database object