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

VIEW: APPS.OKL_BPD_CNTR_READING_UV

Object Details
Object Name: OKL_BPD_CNTR_READING_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_BPD_CNTR_READING_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
CLG_ID NUMBER
Yes Foreign key to view OKL_CNTR_LVLNG_GRPS_V
COUNTER_GROUP VARCHAR2 (150) Yes Name
COUNTER_NUMBER NUMBER

COUNTER_NAME VARCHAR2 (80)
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
ASSET_NUMBER VARCHAR2 (150)
Asset Number
ASSET_SERIAL_NUMBER VARCHAR2 (35)
ASSET_DESCRIPTION VARCHAR2 (80)
EFFECTIVE_DATE_FROM DATE

EFFECTIVE_DATE_TO DATE

COUNTER_READING VARCHAR2 (0)
COUNTER_READING_DATE VARCHAR2 (0)
COUNTER_BILL_AMOUNT VARCHAR2 (0)
UNIT_OF_MEASURE VARCHAR2 (25) Yes
COUNTER_TYPE VARCHAR2 (30)
Query Text

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


SELECT CLG_ID
,      COUNTER_GROUP
,      COUNTER_NUMBER
,      COUNTER_NAME
,      CONTRACT_NUMBER
,      ASSET_NUMBER
,      ASSET_SERIAL_NUMBER
,      ASSET_DESCRIPTION
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
,      COUNTER_READING
,      COUNTER_READING_DATE
,      COUNTER_BILL_AMOUNT
,      UNIT_OF_MEASURE
,      COUNTER_TYPE
FROM APPS.OKL_BPD_CNTR_READING_UV;

Dependencies

[top of page]

APPS.OKL_BPD_CNTR_READING_UV references the following:

SchemaAPPS
SynonymCS_COUNTERS
SynonymMTL_UNITS_OF_MEASURE_TL
SynonymOKC_K_HEADERS_B
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
ViewOKL_CNTR_LVLNG_GRPS_V
ViewOKL_CNTR_LVLNG_LNS_V
ViewOKX_ASSETS_V

APPS.OKL_BPD_CNTR_READING_UV is not referenced by any database object