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_REFUNDS_DTLS_UV

Object Details

Object Name:	OKL_CURE_REFUNDS_DTLS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CURE_REFUNDS_DTLS_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
CONTRACT_ID	NUMBER			Contract identifier
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number
CONTRACT_CURRENCY_CODE	VARCHAR2	(15)
VENDOR_NAME	VARCHAR2	(240)
VENDOR_ID	NUMBER		Yes	vendor ID
VENDOR_SITE_CODE	VARCHAR2	(15)
VENDOR_SITE_ID	NUMBER		Yes	vendor Site ID
REFUND_AMOUNT_DUE	NUMBER			Remaining refund due to be paid back to the vendor for a contract
VENDOR_CURE_DUE	NUMBER			Total outstanding cure at the vendor site level. this is actuially the sum of all cure invoices for which a payment has not been received.
VENDOR_SITE_CURE_DUE	NUMBER			Total outstanding cure at the vendor site level. this is actuially the sum of all cure invoices for which a payment has not been received.

Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_CURRENCY_CODE
,      VENDOR_NAME
,      VENDOR_ID
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      REFUND_AMOUNT_DUE
,      VENDOR_CURE_DUE
,      VENDOR_SITE_CURE_DUE
FROM APPS.OKL_CURE_REFUNDS_DTLS_UV;

Dependencies

[top of page]

APPS.OKL_CURE_REFUNDS_DTLS_UV references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; AR_RECEIVABLE_APPLICATIONS_ALL; FND_GLOBAL - show dependent code; OKC_K_HEADERS_B; OKC_K_HEADERS_V; OKC_UTIL - show dependent code; OKL_BILLING_UTIL_PVT - show dependent code; OKL_BPD_TLD_AR_LINES_V; OKL_CURE_REFUNDS; OKL_CURE_VENDOR_SUMRY_UV; OKL_K_HEADERS; OKL_K_VENDOR_PROGRAMS_UV; OKL_TRX_AR_INVOICES_V; OKL_TXD_AR_LN_DTLS_B; OKL_TXL_AR_INV_LNS_V

APPS.OKL_CURE_REFUNDS_DTLS_UV is referenced by following:

APPS: OKL_CURE_CALC_PVT - show dependent code; OKL_CURE_CONTRACT_UV; OKL_CURE_RFND_VND_DTLS_UV; OKL_PAY_CURE_REFUNDS_PVT - show dependent code