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

VIEW: APPS.OKL_AM_QUOTE_AMT_SUMMARY_UV

Object Details
Object Name: OKL_AM_QUOTE_AMT_SUMMARY_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AM_QUOTE_AMT_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
QUOTE_NUMBER NUMBER

Quote Number
QLT_CODE VARCHAR2 (30)
QLT Code
QTE_ID NUMBER

Quote Id
MEANING VARCHAR2 (80)
Meaning
FULL_DESCRIPTION VARCHAR2 (233)
Full Description
AMOUNT NUMBER

Amount
QST_CODE VARCHAR2 (30)
Quote Status Code
QTP_CODE VARCHAR2 (30)
Quote Type Code
TOTAL_ASSET_VALUE NUMBER (14)
Total Asset Value
TOTAL_RESIDUAL_VALUE NUMBER (14)
Total Residual Value
TOTAL_UNBILLED_RECEIVABLES NUMBER (14)
Total Unbilled Receivables
GAIN_LOSS NUMBER (14)
Gain_loss
Query Text

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


SELECT QUOTE_NUMBER
,      QLT_CODE
,      QTE_ID
,      MEANING
,      FULL_DESCRIPTION
,      AMOUNT
,      QST_CODE
,      QTP_CODE
,      TOTAL_ASSET_VALUE
,      TOTAL_RESIDUAL_VALUE
,      TOTAL_UNBILLED_RECEIVABLES
,      GAIN_LOSS
FROM APPS.OKL_AM_QUOTE_AMT_SUMMARY_UV;

Dependencies

[top of page]

APPS.OKL_AM_QUOTE_AMT_SUMMARY_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKC_K_LINES_B
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
ViewOKL_STRM_TYPE_V
SynonymOKL_TAX_SOURCES
SynonymOKL_TRX_QUOTES_B
SynonymOKL_TXL_QTE_LINES_ALL_B

APPS.OKL_AM_QUOTE_AMT_SUMMARY_UV is not referenced by any database object