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_HDRS_UV

Object Details

Object Name:	OKL_CURE_REFUNDS_HDRS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CURE_REFUNDS_HDRS_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
CURE_REFUND_HEADER_ID	NUMBER		Yes	Primary key
REFUND_HEADER_NUMBER	VARCHAR2	(120)	Yes	The natural primary unique identifier of the refund request
REFUND_DUE_DATE	DATE			Request Date
CURRENCY_CODE	VARCHAR2	(15)	Yes	Oracle Payables invoice number from TAP table
DISBURSEMENT_AMOUNT	NUMBER			disbursed Amount to the vendor
REFUND_STATUS	VARCHAR2	(120)		status from TAP table
REFUND_STATUS_MEANING	VARCHAR2	(80)	Yes	refund status meaning from fnd lookups
PAYMENT_METHOD	VARCHAR2	(120)		Oracle Payables invoice number from TAP table
PAYMENT_TERM_ID	NUMBER			payment term ID (ippt_id)from TAP table
PAYMENT_TERM	VARCHAR2	(50)		payment term from okx_payables_terms_v for ippt_id from TAP table
VENDOR_ID	NUMBER		Yes	vendor ID
VENDOR_SITE_ID	NUMBER		Yes	vendor Site ID
VENDOR_SITE_CODE	VARCHAR2	(15)	Yes	Vendor site Code
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.
DESCRIPTION	VARCHAR2	(1995)		User entered description
OFFSET_AMOUNT	NUMBER			Cure amount generated for contract
RECEIVED_AMOUNT	NUMBER			received amount
VENDOR_NAME	VARCHAR2	(240)		vendor name
VENDOR_ADDRESS	VARCHAR2	(925)		vendor address

Query Text

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


SELECT CURE_REFUND_HEADER_ID
,      REFUND_HEADER_NUMBER
,      REFUND_DUE_DATE
,      CURRENCY_CODE
,      DISBURSEMENT_AMOUNT
,      REFUND_STATUS
,      REFUND_STATUS_MEANING
,      PAYMENT_METHOD
,      PAYMENT_TERM_ID
,      PAYMENT_TERM
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      VENDOR_CURE_DUE
,      DESCRIPTION
,      OFFSET_AMOUNT
,      RECEIVED_AMOUNT
,      VENDOR_NAME
,      VENDOR_ADDRESS
FROM APPS.OKL_CURE_REFUNDS_HDRS_UV;

Dependencies

[top of page]

APPS.OKL_CURE_REFUNDS_HDRS_UV references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; OKL_CURE_REFUND_HEADERS_V; OKL_CURE_VENDOR_DUE_UV; OKX_PAYABLES_TERMS_V; PO_VENDORS; PO_VENDOR_SITES

APPS.OKL_CURE_REFUNDS_HDRS_UV is not referenced by any database object