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

VIEW: APPS.OKL_POOL_CONTRACTS_UV

Object Details
Object Name: OKL_POOL_CONTRACTS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_POOL_CONTRACTS_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
DNZ_CHR_ID NUMBER
Yes Denormalized contract header identifier
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract number
PRE_TAX_YIELD NUMBER

Pre tax yield
BOOK_CLASSIFICATION VARCHAR2 (30)
Deal type
PDT_ID NUMBER

Financial product identifier
ASSIGNABLE_YN VARCHAR2 (3)
Assignable flag. Indicates wheter contract can be securitized or not
STS_CODE VARCHAR2 (30) Yes Contract status code
START_DATE DATE

Contract effective from date
END_DATE DATE

Contract efective to date
OPERATING_UNIT NUMBER
Yes Operating unit
CURRENCY_CODE VARCHAR2 (15)
Currency code
AUTHORING_ORG_ID NUMBER
Yes Operating unit identifier
TAX_OWNER VARCHAR2 (450)
Tax owner
Query Text

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


SELECT DNZ_CHR_ID
,      CONTRACT_NUMBER
,      PRE_TAX_YIELD
,      BOOK_CLASSIFICATION
,      PDT_ID
,      ASSIGNABLE_YN
,      STS_CODE
,      START_DATE
,      END_DATE
,      OPERATING_UNIT
,      CURRENCY_CODE
,      AUTHORING_ORG_ID
,      TAX_OWNER
FROM APPS.OKL_POOL_CONTRACTS_UV;

Dependencies

[top of page]

APPS.OKL_POOL_CONTRACTS_UV references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_RULES_B
SynonymOKC_RULE_GROUPS_B
SynonymOKL_K_HEADERS
APPS.OKL_POOL_CONTRACTS_UV is referenced by following:

SchemaAPPS
ViewOKL_POOL_SRCH_PAYFREQ_V
ViewOKL_POOL_SRCH_V