eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_TRX_QUOTES_V

Object Details

Object Name:	OKL_TRX_QUOTES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_TRX_QUOTES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

DEFINITION
Termination, restructure or repurchase quotes
EXAMPLE
MISCELLANEOUS

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Auto-generated by Headstart Utilities
ID	NUMBER		Yes	Primary key column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
SFWT_FLAG	VARCHAR2	(3)	Yes	Column used by the translation batch program
QRS_CODE	VARCHAR2	(30)	Yes	The quote reason code. The FND lookup type is OKL_QUOTE_REASON
QST_CODE	VARCHAR2	(30)	Yes	The quote status code. The FND lookup type is OKL_QUOTE_STATUS
QTP_CODE	VARCHAR2	(30)	Yes	The quote type code. The FND lookup type is OKL_QUOTE_TYPE
TRN_CODE	VARCHAR2	(30)		The termination reason code. The FND lookup type is OKC_TERMINATION_REASON
POP_CODE_END	VARCHAR2	(30)		The new purchase option at the contract end of term. The FND lookup type is OKL_EOT_OPTION
POP_CODE_EARLY	VARCHAR2	(30)		The new purchase option for early contract terminations. The FND lookup type is OKL_EOT_OPTION
CONSOLIDATED_QTE_ID	NUMBER			The consolidated quote identifier
KHR_ID	NUMBER			Foreign key to table OKL_K_HEADERS
ART_ID	NUMBER			Foreign key to table OKL_ASSET_RETURNS_B
PDT_ID	NUMBER			Foreign key to table OKL_PRODUCTS
EARLY_TERMINATION_YN	VARCHAR2	(3)		Is this an early termination
PARTIAL_YN	VARCHAR2	(3)		Is this a quote for less than all assets from one contract
PREPROCEEDS_YN	VARCHAR2	(3)		Is this a pre-proceeds termination
DATE_REQUESTED	DATE			The request date of the quote
DATE_PROPOSAL	DATE			The proposal date of the quote
DATE_EFFECTIVE_TO	DATE			The date the quote is effective to
DATE_ACCEPTED	DATE			The date the quote is accepted
SUMMARY_FORMAT_YN	VARCHAR2	(3)		Is the presentation format to be summary or detailed
CONSOLIDATED_YN	VARCHAR2	(3)		Is this a consolidated quote? A consolidated quote is a group of quotes for mass transaction and communication purposes
PRINCIPAL_PAYDOWN_AMOUNT	NUMBER	(14)		Balloon payment which may affect the future payment schedule
RESIDUAL_AMOUNT	NUMBER	(14)		An amount that can be suggested & changed that may affect the rent and other streams
YIELD	NUMBER	(5)		The new contract yield generated by pricing
RENT_AMOUNT	NUMBER	(14)		The proposed rent amount of the restructured contract
DATE_RESTRUCTURE_END	DATE			The new contract end date for restructure quotes
DATE_RESTRUCTURE_START	DATE			If defined, this is the start date of a new contract. Mainly used for renewals
TERM	NUMBER	(4)		The term extension of the contract for restructure quotes
PURCHASE_PERCENT	NUMBER	(14)		Percentage of original equipment cost for specific purchase options
COMMENTS	VARCHAR2	(1995)		Notes and Comments
DATE_DUE	DATE			The proposed due date change
PAYMENT_FREQUENCY	VARCHAR2	(90)		The proposed payment frequency change
REMAINING_PAYMENTS	NUMBER	(4)		The proposed remaining payments
DATE_EFFECTIVE_FROM	DATE		Yes	The date the quote is effective from
QUOTE_NUMBER	NUMBER		Yes	A unique identifier for each quote
REQUESTED_BY	NUMBER	(15)		The requester of the quote
APPROVED_YN	VARCHAR2	(3)		Flag to determine whether the quote has been approved
ACCEPTED_YN	VARCHAR2	(3)		Flag to determine whether the quote has been accepted
PAYMENT_RECEIVED_YN	VARCHAR2	(3)		Flag to state whether the payment has been received in Accounts Receivables
DATE_PAYMENT_RECEIVED	DATE			This is the date the payment of the quote amount has been flagged as received in Accounts Receivables
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive flexfield category column
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield column
DATE_APPROVED	DATE			The date the quote was approved
APPROVED_BY	NUMBER	(15)		The quote approver
ORG_ID	NUMBER	(15)		Operating unit identifier
REQUEST_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
PURCHASE_AMOUNT	NUMBER	(14)		The calculated purchase amount
PURCHASE_FORMULA	VARCHAR2	(150)		The formula used to calculate the purchase amount
ASSET_VALUE	NUMBER	(14)		The asset value is total asset value taken from the quote lines
RESIDUAL_VALUE	NUMBER	(14)		The residual value is total residual value taken from the quote lines
UNBILLED_RECEIVABLES	NUMBER	(14)		The unbilled receivables value is total unbilled receivables taken from the quote lines
GAIN_LOSS	NUMBER	(14)		The quote gain loss value
PERDIEM_AMOUNT	NUMBER	(14)		The quote perdiem amount
CURRENCY_CODE	VARCHAR2	(15)		Indicates the currency in which the amounts are stored
CURRENCY_CONVERSION_CODE	VARCHAR2	(15)		Indicates the target currency of the conversion information
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		The conversion type (spot, user or corporate)
CURRENCY_CONVERSION_RATE	NUMBER			The conversion rate to convert the amounts from the CURRENCY_CODE to the CURRENCY_CONVERSION_CODE
CURRENCY_CONVERSION_DATE	DATE			The conversion date the conversion rate was determined
LEGAL_ENTITY_ID	NUMBER			Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES
REPO_QUOTE_INDICATOR_YN	VARCHAR2	(1)		Indicates repossesion quote indicator

Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      QRS_CODE
,      QST_CODE
,      QTP_CODE
,      TRN_CODE
,      POP_CODE_END
,      POP_CODE_EARLY
,      CONSOLIDATED_QTE_ID
,      KHR_ID
,      ART_ID
,      PDT_ID
,      EARLY_TERMINATION_YN
,      PARTIAL_YN
,      PREPROCEEDS_YN
,      DATE_REQUESTED
,      DATE_PROPOSAL
,      DATE_EFFECTIVE_TO
,      DATE_ACCEPTED
,      SUMMARY_FORMAT_YN
,      CONSOLIDATED_YN
,      PRINCIPAL_PAYDOWN_AMOUNT
,      RESIDUAL_AMOUNT
,      YIELD
,      RENT_AMOUNT
,      DATE_RESTRUCTURE_END
,      DATE_RESTRUCTURE_START
,      TERM
,      PURCHASE_PERCENT
,      COMMENTS
,      DATE_DUE
,      PAYMENT_FREQUENCY
,      REMAINING_PAYMENTS
,      DATE_EFFECTIVE_FROM
,      QUOTE_NUMBER
,      REQUESTED_BY
,      APPROVED_YN
,      ACCEPTED_YN
,      PAYMENT_RECEIVED_YN
,      DATE_PAYMENT_RECEIVED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DATE_APPROVED
,      APPROVED_BY
,      ORG_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PURCHASE_AMOUNT
,      PURCHASE_FORMULA
,      ASSET_VALUE
,      RESIDUAL_VALUE
,      UNBILLED_RECEIVABLES
,      GAIN_LOSS
,      PERDIEM_AMOUNT
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      LEGAL_ENTITY_ID
,      REPO_QUOTE_INDICATOR_YN
FROM APPS.OKL_TRX_QUOTES_V;

Dependencies

[top of page]

APPS.OKL_TRX_QUOTES_V references the following:

APPS: OKL_TRX_QUOTES_B; OKL_TRX_QUOTES_TL

APPS.OKL_TRX_QUOTES_V is referenced by following:

APPS: OKL_AM_ASSET_QUOTES_UV; OKL_AM_BTCH_EXP_LEASE_LOAN_PVT - show dependent code; OKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code; OKL_AM_CONSOLIDATED_QTE_PVT - show dependent code; OKL_AM_LEASE_LOAN_TRMNT_PVT - show dependent code; OKL_AM_LEASE_TRMNT_PVT - show dependent code; OKL_AM_QUOTES_UV; OKL_AM_QUOTES_WF - show dependent code; OKL_AM_REPURCHASE_ASSET_HDR_UV; OKL_AM_REPURCHASE_ASSET_PVT - show dependent code; OKL_AM_RESTRUCTURE_LINES_UV; OKL_AM_RESTRUCTURE_QUOTES_UV; OKL_AM_RESTRUCTURE_QUOTE_PVT - show dependent code; OKL_AM_RESTRUCTURE_RENTS_PVT - show dependent code; OKL_AM_SECURITIZATION_PVT - show dependent code; OKL_AM_TERMNT_QUOTE_PVT - show dependent code; OKL_AM_UTIL_PVT - show dependent code; OKL_CURE_REQUEST_UV; OKL_LCKBX_CSH_APP_PVT - show dependent code; OKL_MASS_REBOOK_PVT - show dependent code; OKL_QA_DATA_INTEGRITY - show dependent code; OKL_QCO_PVT - show dependent code; OKL_QPY_PVT - show dependent code; OKL_QTE_PVT - show dependent code; OKL_QTE_PVT - show dependent code; OKL_SEEDED_FUNCTIONS_PVT - show dependent code; OKL_TAP_PVT - show dependent code; OKL_TCN_PVT - show dependent code; OKL_TQL_PVT - show dependent code; OKL_VSS_WF - show dependent code