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_SUMRY_UV

Object Details

Object Name:	OKL_CURE_REFUNDS_SUMRY_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CURE_REFUNDS_SUMRY_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_ID	NUMBER		Yes	Primary key
CURE_REFUND_HEADER_ID	NUMBER		Yes	cure Refund Header Id
REFUND_NUMBER	VARCHAR2	(120)	Yes	The natural primary unique identifier of the refund request
REFUND_DUE_DATE	DATE			Request Date
DISBURSEMENT_AMOUNT	NUMBER			disbursed Amount to the vendor
TOTAL_REFUND_DUE	NUMBER			total refund due at the time the disbursement was made. This will be the sum (amount paid by vendor ) -sum (disbursment _amount)
INVOICE_DATE	DATE			Refund Date
CHR_ID	NUMBER		Yes	Contract identifier
CONTRACT_NUMBER	VARCHAR2	(120)	Yes
TAP_ID	NUMBER			Foreign key to table OKL_TRX_AP_INVOICES_B
INVOICE_NUMBER	VARCHAR2	(50)		Oracle Payables invoice number from TAP table
CURRENCY_CODE	VARCHAR2	(15)	Yes	Oracle Payables invoice number from TAP table
PAYMENT_METHOD	VARCHAR2	(30)		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
REFUND_STATUS	VARCHAR2	(30)	Yes	status from TAP table
VENDOR_ID	NUMBER		Yes	vendor ID
VENDOR_SITE_ID	NUMBER			vendor Site ID
VENDOR_SITE_CODE	VARCHAR2	(15)		Vendor site Code

Query Text

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


SELECT CURE_REFUND_ID
,      CURE_REFUND_HEADER_ID
,      REFUND_NUMBER
,      REFUND_DUE_DATE
,      DISBURSEMENT_AMOUNT
,      TOTAL_REFUND_DUE
,      INVOICE_DATE
,      CHR_ID
,      CONTRACT_NUMBER
,      TAP_ID
,      INVOICE_NUMBER
,      CURRENCY_CODE
,      PAYMENT_METHOD
,      PAYMENT_TERM_ID
,      PAYMENT_TERM
,      REFUND_STATUS
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
FROM APPS.OKL_CURE_REFUNDS_SUMRY_UV;

Dependencies

[top of page]

APPS.OKL_CURE_REFUNDS_SUMRY_UV references the following:

APPS: FND_GLOBAL - show dependent code; OKC_K_HEADERS_ALL_B; OKL_CURE_REFUNDS; OKL_CURE_REFUND_HEADERS_B; OKL_TRX_AP_INVOICES_V; OKX_PAYABLES_TERMS_V; PO_VENDOR_SITES_ALL

APPS.OKL_CURE_REFUNDS_SUMRY_UV is not referenced by any database object