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

VIEW: APPS.OKL_LA_SRV_COV_AST_UV

Object Details
Object Name: OKL_LA_SRV_COV_AST_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_SRV_COV_AST_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
ID1 NUMBER
Yes
ID2 CHAR (1)
NAME VARCHAR2 (150)
DESCRIPTION VARCHAR2 (200)
CHR_ID NUMBER
Yes
DNZ_CHR_ID NUMBER
Yes
LTY_CODE VARCHAR2 (30) Yes
LSE_TYPE VARCHAR2 (10) Yes
LINE_NUMBER VARCHAR2 (150) Yes
DATE_TERMINATED DATE

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

STATUS VARCHAR2 (1)
PRIMARY_UOM_CODE VARCHAR2 (0)
CONTRACT_STATUS VARCHAR2 (30) Yes
AUTHORING_ORG_ID NUMBER
Yes
INV_ORGANIZATION_ID NUMBER
Yes
OKL_LINE_STATUS VARCHAR2 (30) Yes
OKC_LINE_STATUS VARCHAR2 (30) Yes
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      CHR_ID
,      DNZ_CHR_ID
,      LTY_CODE
,      LSE_TYPE
,      LINE_NUMBER
,      DATE_TERMINATED
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
,      CONTRACT_STATUS
,      AUTHORING_ORG_ID
,      INV_ORGANIZATION_ID
,      OKL_LINE_STATUS
,      OKC_LINE_STATUS
FROM APPS.OKL_LA_SRV_COV_AST_UV;

Dependencies

[top of page]

APPS.OKL_LA_SRV_COV_AST_UV references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_LINE_STYLES_B
SynonymOKC_STATUSES_B
APPS.OKL_LA_SRV_COV_AST_UV is referenced by following:

SchemaAPPS
Package BodyOKL_CONTRACT_LINE_ITEM_PVT - show dependent code