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

VIEW: APPS.OKL_COV_PROD_LINES_V

Object Details
Object Name: OKL_COV_PROD_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_COV_PROD_LINES_V
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
ID1 NUMBER
Yes Unique identifier for covered product line. Primary key
ID2 CHAR (1)
Primary key
NAME VARCHAR2 (150)
Coverd product name
DESCRIPTION VARCHAR2 (1995)
Covered product description
START_DATE_ACTIVE DATE

Covered product start date
END_DATE_ACTIVE DATE

Covered product end date
STATUS VARCHAR2 (1)
Covered product line status
STS_CODE VARCHAR2 (30) Yes Covered product line status code
ORG_ID NUMBER
Yes Operating unit identifier
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      STS_CODE
,      ORG_ID
FROM APPS.OKL_COV_PROD_LINES_V;

Dependencies

[top of page]

APPS.OKL_COV_PROD_LINES_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_LINE_STYLES_B

APPS.OKL_COV_PROD_LINES_V is not referenced by any database object