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_CURE_REQUEST_UV

Object Details

Object Name:	OKL_CURE_REQUEST_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CURE_REQUEST_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	Comments
CONTRACT_NUMBER	VARCHAR2	(120)	Contract Number
CUSTOMER_NAME	VARCHAR2	(360)
PROGRAM_AGREEMENT	VARCHAR2	(120)	Program agreement
CURE_AMOUNT	NUMBER
REPURCHASE_AMOUNT	NUMBER
EFFECTIVE_DATE	DATE		Effective date
CURES_IN_POSSESSION	NUMBER
CURE_AMOUNT_RECEIVED	NUMBER		cure amount received
NEGOTIATED_AMOUNT	NUMBER		negotiated amount
RECEIVED_AMOUNT	NUMBER		received amount
CURE_AMOUNT_ID	NUMBER
CURE_REPORT_ID	NUMBER
VENDOR_ID	NUMBER		vendor ID
VENDOR_SITE_ID	NUMBER		vendor Site ID
VENDOR_CONTACT_ID	NUMBER		vendorcontact ID
APPROVAL_STATUS	VARCHAR2	(50)	approval status
REQUEST_NUMBER	VARCHAR2	(150)	Report number
CURRENCY_CODE	VARCHAR2	(15)	Oracle Payables invoice number from TAP table
CRT_ID	NUMBER		Cure report associated with the cure amount
SELECTED_ON_REQUEST	VARCHAR2	(1)	for UI purpose
REQUEST_ALL_YN	VARCHAR2	(0)	for UI purpose
REQUEST_STATUS	VARCHAR2	(11)	request status
CHR_ID	NUMBER
REPURCHASE_QUOTE_NUMBER	NUMBER		REPURCHASE_QUOTE_NUMBER
QTE_ID	NUMBER

Query Text

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


SELECT CONTRACT_NUMBER
,      CUSTOMER_NAME
,      PROGRAM_AGREEMENT
,      CURE_AMOUNT
,      REPURCHASE_AMOUNT
,      EFFECTIVE_DATE
,      CURES_IN_POSSESSION
,      CURE_AMOUNT_RECEIVED
,      NEGOTIATED_AMOUNT
,      RECEIVED_AMOUNT
,      CURE_AMOUNT_ID
,      CURE_REPORT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      APPROVAL_STATUS
,      REQUEST_NUMBER
,      CURRENCY_CODE
,      CRT_ID
,      SELECTED_ON_REQUEST
,      REQUEST_ALL_YN
,      REQUEST_STATUS
,      CHR_ID
,      REPURCHASE_QUOTE_NUMBER
,      QTE_ID
FROM APPS.OKL_CURE_REQUEST_UV;

Dependencies

[top of page]

APPS.OKL_CURE_REQUEST_UV references the following:

APPS: HZ_PARTIES; OKC_K_HEADERS_ALL_B; OKC_K_PARTY_ROLES_B; OKL_CURE_AMOUNTS; OKL_CURE_AMOUNTS_ALL; OKL_CURE_RECEIVED_UV; OKL_CURE_REPORTS_ALL; OKL_K_HEADERS; OKL_NO_OF_CURES_UV; OKL_TRX_QUOTES_V

APPS.OKL_CURE_REQUEST_UV is not referenced by any database object