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

VIEW: APPS.OKL_GEN_LOSS_PROVISION_UV

Object Details
Object Name: OKL_GEN_LOSS_PROVISION_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_GEN_LOSS_PROVISION_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_ID NUMBER
Yes
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
STY_ID NUMBER
Yes Foreign key to view OKL_STRM_TYPE_V
STREAM_TYPE_NAME VARCHAR2 (150) Yes
TRANSACTION_DATE DATE
Yes
TAX_DEDUCTIBLE_LOCAL VARCHAR2 (3)
TAX_DEDUCTIBLE_CORPORATE VARCHAR2 (3)
DESCRIPTION VARCHAR2 (1995)
User entered description
BUCKET_NAME VARCHAR2 (20) Yes
AMOUNT NUMBER

Amount
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      STY_ID
,      STREAM_TYPE_NAME
,      TRANSACTION_DATE
,      TAX_DEDUCTIBLE_LOCAL
,      TAX_DEDUCTIBLE_CORPORATE
,      DESCRIPTION
,      BUCKET_NAME
,      AMOUNT
FROM APPS.OKL_GEN_LOSS_PROVISION_UV;

Dependencies

[top of page]

APPS.OKL_GEN_LOSS_PROVISION_UV references the following:

SchemaAPPS
SynonymAR_AGING_BUCKETS
SynonymAR_AGING_BUCKET_LINES_B
SynonymOKC_K_HEADERS_B
SynonymOKL_BUCKETS
SynonymOKL_STRM_TYPE_B
SynonymOKL_STRM_TYPE_TL
SynonymOKL_TRX_CONTRACTS_ALL
SynonymOKL_TXL_CNTRCT_LNS_ALL

APPS.OKL_GEN_LOSS_PROVISION_UV is not referenced by any database object