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

VIEW: APPS.OKL_SO_PLAN_SUMMARY_UV

Object Details
Object Name: OKL_SO_PLAN_SUMMARY_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_SO_PLAN_SUMMARY_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
PAYMENT_PLAN_ID NUMBER

Payment Plan Line ID
CHR_ID NUMBER

Contract ID
NAME VARCHAR2 (533)
Plan Name (derived)
BOOK_CLASS VARCHAR2 (80) Yes Book Classification (Deal Type) used in the plan
PAYMENT VARCHAR2 (450)
Total periodic payment
STATUS VARCHAR2 (80) Yes Plan Status
PAYMENT_STRUCTURE VARCHAR2 (80) Yes Payment structure as defined on plan (not used in Pricing for r11i9)
Query Text

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


SELECT PAYMENT_PLAN_ID
,      CHR_ID
,      NAME
,      BOOK_CLASS
,      PAYMENT
,      STATUS
,      PAYMENT_STRUCTURE
FROM APPS.OKL_SO_PLAN_SUMMARY_UV;

Dependencies

[top of page]

APPS.OKL_SO_PLAN_SUMMARY_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKC_RULES_B
SynonymOKC_RULE_GROUPS_B
SynonymOKL_LS_RT_FCTR_SETS_B

APPS.OKL_SO_PLAN_SUMMARY_UV is not referenced by any database object