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_QUOTES_UV

Object Details

Object Name:	OKL_AM_RESTRUCTURE_QUOTES_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AM_RESTRUCTURE_QUOTES_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
ID	NUMBER		Yes	Primary key column
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)
DATE_RESTRUCTURE_START	DATE
DATE_RESTRUCTURE_END	DATE
ORG_ID	NUMBER	(15)		Operating Unit Identifier
POP_CODE_END	VARCHAR2	(30)		The new purchase option at the contract end of term. The FND lookup type is OKL_EOT_OPTION
ACCEPTED_YN_MEANING	VARCHAR2	(80)	Yes	Meaning from FND_LOOKUPS for column ACCEPTED_YN

Query Text

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


SELECT 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
,      DATE_RESTRUCTURE_START
,      DATE_RESTRUCTURE_END
,      ORG_ID
,      POP_CODE_END
,      ACCEPTED_YN_MEANING
FROM APPS.OKL_AM_RESTRUCTURE_QUOTES_UV;

Dependencies

[top of page]

APPS.OKL_AM_RESTRUCTURE_QUOTES_UV references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; OKC_K_HEADERS_ALL_B; OKL_TRX_QUOTES_V

APPS.OKL_AM_RESTRUCTURE_QUOTES_UV is not referenced by any database object