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]

TABLE: OKL.OKL_TRX_QUOTES_ALL_B

Object Details

Object Name:	OKL_TRX_QUOTES_ALL_B
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TRX_QUOTES_ALL_B
Subobject Name:
Status:	VALID

DEFINITION
Termination, restructure or repurchase quotes
EXAMPLE
MISCELLANEOUS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TRX_QUOTES_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUOTE_NUMBER
OKL_TRX_QUOTES_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ART_ID
OKL_TRX_QUOTES_ALL_B_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QTP_CODE
OKL_TRX_QUOTES_ALL_B_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRN_CODE
OKL_TRX_QUOTES_ALL_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONSOLIDATED_QTE_ID
OKL_TRX_QUOTES_ALL_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PURCHASE_FORMULA
OKL_TRX_QUOTES_ALL_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID
OKL_TRX_QUOTES_ALL_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PDT_ID
OKL_TRX_QUOTES_ALL_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POP_CODE_EARLY
OKL_TRX_QUOTES_ALL_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POP_CODE_END
OKL_TRX_QUOTES_ALL_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QRS_CODE
OKL_TRX_QUOTES_ALL_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QST_CODE
OKL_TRX_QUOTES_ALL_B_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
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
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
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
PDT_ID	NUMBER			Foreign key to table OKL_PRODUCTS
DATE_EFFECTIVE_FROM	DATE		Yes	The date the quote is effective from
QUOTE_NUMBER	NUMBER		Yes	A unique identifier for each quote
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
PURCHASE_PERCENT	NUMBER	(14)		Percentage of original equipment cost for specific purchase options
TERM	NUMBER	(4)		The term extension of the contract for restructure quotes
DATE_RESTRUCTURE_START	DATE			If defined, this is the start date of a new contract. Mainly used for renewals
DATE_DUE	DATE			The proposed due date change
DATE_APPROVED	DATE			The date the quote was approved
DATE_RESTRUCTURE_END	DATE			The new contract end date for restructure quotes
REMAINING_PAYMENTS	NUMBER	(4)		The proposed remaining payments
RENT_AMOUNT	NUMBER	(14)		The proposed rent amount of the restructured contract
YIELD	NUMBER	(5)		The new contract yield generated by pricing
RESIDUAL_AMOUNT	NUMBER	(14)		An amount that can be suggested & changed that may affect the rent and other streams
PRINCIPAL_PAYDOWN_AMOUNT	NUMBER	(14)		Balloon payment which may affect the future payment schedule
PAYMENT_FREQUENCY	VARCHAR2	(90)		The proposed payment frequency change
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
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
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
PAYMENT_RECEIVED_YN	VARCHAR2	(3)		Flag to state whether the payment has been received in Accounts Receivables
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
DATE_PAYMENT_RECEIVED	DATE			This is the date the payment of the quote amount has been flagged as received in Accounts Receivables
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
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
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
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
PERDIEM_AMOUNT	NUMBER	(14)		The quote perdiem amount
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 ID
,      QRS_CODE
,      QST_CODE
,      CONSOLIDATED_QTE_ID
,      KHR_ID
,      ART_ID
,      QTP_CODE
,      TRN_CODE
,      POP_CODE_END
,      POP_CODE_EARLY
,      PDT_ID
,      DATE_EFFECTIVE_FROM
,      QUOTE_NUMBER
,      OBJECT_VERSION_NUMBER
,      PURCHASE_PERCENT
,      TERM
,      DATE_RESTRUCTURE_START
,      DATE_DUE
,      DATE_APPROVED
,      DATE_RESTRUCTURE_END
,      REMAINING_PAYMENTS
,      RENT_AMOUNT
,      YIELD
,      RESIDUAL_AMOUNT
,      PRINCIPAL_PAYDOWN_AMOUNT
,      PAYMENT_FREQUENCY
,      EARLY_TERMINATION_YN
,      PARTIAL_YN
,      PREPROCEEDS_YN
,      SUMMARY_FORMAT_YN
,      CONSOLIDATED_YN
,      DATE_REQUESTED
,      DATE_PROPOSAL
,      DATE_EFFECTIVE_TO
,      DATE_ACCEPTED
,      PAYMENT_RECEIVED_YN
,      REQUESTED_BY
,      APPROVED_YN
,      ACCEPTED_YN
,      DATE_PAYMENT_RECEIVED
,      APPROVED_BY
,      ORG_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      PERDIEM_AMOUNT
,      LEGAL_ENTITY_ID
,      REPO_QUOTE_INDICATOR_YN
FROM OKL.OKL_TRX_QUOTES_ALL_B;

Dependencies

[top of page]

OKL.OKL_TRX_QUOTES_ALL_B does not reference any database object

OKL.OKL_TRX_QUOTES_ALL_B is referenced by following:

OKL: OKL_TRX_QUOTES_ALL_B#