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_AM_RESTRUCTURE_LINES_UV

Object Details

Object Name:	OKL_AM_RESTRUCTURE_LINES_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AM_RESTRUCTURE_LINES_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
QTE_ID	NUMBER		Yes	Foreign key to view OKL_TRX_QUOTES_V
KHR_ID	NUMBER			Foreign key to view OKL_K_HEADERS_V
QUOTE_NUMBER	NUMBER		Yes	an unique identifier for each quote
QUOTE_TYPE	VARCHAR2	(30)	Yes
QUOTE_TYPE_DESCRIPTION	VARCHAR2	(80)	Yes	QuickCode meaning
QUOTE_STATUS	VARCHAR2	(30)	Yes
QUOTE_STATUS_DESCRIPTION	VARCHAR2	(80)	Yes	QuickCode meaning
DATE_EFFECTIVE_FROM	DATE		Yes	The date the quote is effective, may equal date proposal, but not limited to.
DATE_EFFECTIVE_TO	DATE			the first day the quote is NOT effective
RENT_AMOUNT	NUMBER	(14)		The proposed rent amount of the restructured contract.
START_DATE	DATE			Start Date
END_DATE	DATE			End Date
ACCEPTED_YN	VARCHAR2	(3)		Flag to determine whether the quote has been accepted.
APPROVED_YN	VARCHAR2	(3)		Flag to determine whether the quote has been approved.
QRS_CODE	VARCHAR2	(30)	Yes
QRS_CODE_MEANING	VARCHAR2	(80)	Yes	QuickCode meaning
TERM	NUMBER	(4)		The new term of the contract, from the start date if mentioned. Otherwise replacing the existing contract term.
YIELD	NUMBER	(5)		The new contract yield generated by supertrump.
COMMENTS	VARCHAR2	(1995)		User entered comments
CONTRACT_NUMBER	VARCHAR2	(120)		Contract Number
CONSOLIDATED_QTE_ID	NUMBER
CONSOLIDATED_YN	VARCHAR2	(3)
PURCHASE_AMOUNT	NUMBER	(14)
PURCHASE_FORMULA	VARCHAR2	(150)
ID	NUMBER		Yes	Primary key column
LINE_START_DATE	DATE
PERIOD	VARCHAR2	(30)
NUMBER_OF_PERIODS	NUMBER	(4)
LOCK_LEVEL_STEP	VARCHAR2	(10)
ADVANCE_OR_ARREARS	VARCHAR2	(10)
YIELD_NAME	VARCHAR2	(150)
YIELD_VALUE	NUMBER	(18)
IMPLICIT_INTEREST_RATE	NUMBER	(18)
AMOUNT	NUMBER	(14)	Yes	Amount
QLT_CODE	VARCHAR2	(30)
QUOTE_LINE_TYPE	VARCHAR2	(80)	Yes
LINE_NUMBER	NUMBER		Yes	Line Number
DATE_RESTRUCTURE_START	DATE
DATE_RESTRUCTURE_END	DATE

Query Text

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


SELECT QTE_ID
,      KHR_ID
,      QUOTE_NUMBER
,      QUOTE_TYPE
,      QUOTE_TYPE_DESCRIPTION
,      QUOTE_STATUS
,      QUOTE_STATUS_DESCRIPTION
,      DATE_EFFECTIVE_FROM
,      DATE_EFFECTIVE_TO
,      RENT_AMOUNT
,      START_DATE
,      END_DATE
,      ACCEPTED_YN
,      APPROVED_YN
,      QRS_CODE
,      QRS_CODE_MEANING
,      TERM
,      YIELD
,      COMMENTS
,      CONTRACT_NUMBER
,      CONSOLIDATED_QTE_ID
,      CONSOLIDATED_YN
,      PURCHASE_AMOUNT
,      PURCHASE_FORMULA
,      ID
,      LINE_START_DATE
,      PERIOD
,      NUMBER_OF_PERIODS
,      LOCK_LEVEL_STEP
,      ADVANCE_OR_ARREARS
,      YIELD_NAME
,      YIELD_VALUE
,      IMPLICIT_INTEREST_RATE
,      AMOUNT
,      QLT_CODE
,      QUOTE_LINE_TYPE
,      LINE_NUMBER
,      DATE_RESTRUCTURE_START
,      DATE_RESTRUCTURE_END
FROM APPS.OKL_AM_RESTRUCTURE_LINES_UV;

Dependencies

[top of page]

APPS.OKL_AM_RESTRUCTURE_LINES_UV references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; OKC_K_HEADERS_B; OKL_TRX_QUOTES_V; OKL_TXL_QUOTE_LINES_V

APPS.OKL_AM_RESTRUCTURE_LINES_UV is not referenced by any database object