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

VIEW: APPS.OKL_AM_CREATE_RES_QUOTE_UV

Object Details
Object Name: OKL_AM_CREATE_RES_QUOTE_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AM_CREATE_RES_QUOTE_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_NUMBER VARCHAR2 (120) Yes Contract Number
START_DATE DATE

Start Date
END_DATE DATE

End Date
CONTRACT_ID NUMBER
Yes Primary key column.
QRS_CODE VARCHAR2 (0)
COMMENTS VARCHAR2 (0)
User entered comments
POP_CODE_END VARCHAR2 (0)
PURCHASE_AMOUNT VARCHAR2 (0)
PURCHASE_FORMULA VARCHAR2 (0)
PURCHASE_FORMULA_ID VARCHAR2 (0)
PURCHASE_PERCENT VARCHAR2 (0)
QTP_CODE VARCHAR2 (30) Yes
QTP_MEANING VARCHAR2 (80) Yes
TERM VARCHAR2 (0)
RENT_AMT VARCHAR2 (0)
Query Text

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


SELECT CONTRACT_NUMBER
,      START_DATE
,      END_DATE
,      CONTRACT_ID
,      QRS_CODE
,      COMMENTS
,      POP_CODE_END
,      PURCHASE_AMOUNT
,      PURCHASE_FORMULA
,      PURCHASE_FORMULA_ID
,      PURCHASE_PERCENT
,      QTP_CODE
,      QTP_MEANING
,      TERM
,      RENT_AMT
FROM APPS.OKL_AM_CREATE_RES_QUOTE_UV;

Dependencies

[top of page]

APPS.OKL_AM_CREATE_RES_QUOTE_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKC_K_HEADERS_B

APPS.OKL_AM_CREATE_RES_QUOTE_UV is not referenced by any database object