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_OR_SUBSIDY_REFUNDS

Object Details

Object Name:	OKL_OR_SUBSIDY_REFUNDS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_OR_SUBSIDY_REFUNDS
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
CPL_ID	NUMBER		Yes	Contract party role Identifier
DNZ_CHR_ID	NUMBER		Yes	Contract Identifier
CLETS_ID	NUMBER		Yes	Contract Line Identifier
SUBSIDY_ID	NUMBER		Yes	Subsidy Identifier
SUBSIDY_NAME	VARCHAR2	(30)	Yes	Subsidy Name
ID	NUMBER			Identifier for payment details record
OBJECT_VERSION_NUMBER	NUMBER	(9)		Column used for locking records during updates
PYD_CPL_ID	NUMBER			Contract party role Identifier
OBJECT1_ID1	VARCHAR2	(40)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view
VENDOR_ID	NUMBER			Vendor Identifier
VENDOR_NAME	VARCHAR2	(240)		Vendor Name
PAY_SITE_ID	NUMBER			Payment Site Identifier
PAY_SITE_NAME	VARCHAR2	(15)		Payment Site name
PAYMENT_TERM_ID	NUMBER			Payment Term Identifier
PAYMENT_TERM_NAME	VARCHAR2	(50)		Payment Term name
PAYMENT_METHOD_CODE	VARCHAR2	(30)		Payment Method code
PAYMENT_METHOD_NAME	VARCHAR2	(80)		Payment Method name
PAY_GROUP_CODE	VARCHAR2	(30)		Pay Group code
PAY_GROUP_NAME	VARCHAR2	(80)		Pay Group name

Query Text

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


SELECT CPL_ID
,      DNZ_CHR_ID
,      CLETS_ID
,      SUBSIDY_ID
,      SUBSIDY_NAME
,      ID
,      OBJECT_VERSION_NUMBER
,      PYD_CPL_ID
,      OBJECT1_ID1
,      VENDOR_ID
,      VENDOR_NAME
,      PAY_SITE_ID
,      PAY_SITE_NAME
,      PAYMENT_TERM_ID
,      PAYMENT_TERM_NAME
,      PAYMENT_METHOD_CODE
,      PAYMENT_METHOD_NAME
,      PAY_GROUP_CODE
,      PAY_GROUP_NAME
FROM APPS.OKL_OR_SUBSIDY_REFUNDS;

Dependencies

[top of page]

APPS.OKL_OR_SUBSIDY_REFUNDS references the following:

APPS: AP_LOOKUP_CODES; AP_TERMS_TL; FND_GLOBAL - show dependent code; OKC_K_LINES_B; OKC_K_PARTY_ROLES_B; OKL_K_LINES; OKL_PARTY_PAYMENT_DTLS; OKL_SUBSIDIES_B; PO_LOOKUP_CODES; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.OKL_OR_SUBSIDY_REFUNDS is not referenced by any database object