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_LA_VENDOR_PAYMENTS_UV

Object Details

Object Name:	OKL_LA_VENDOR_PAYMENTS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_LA_VENDOR_PAYMENTS_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
PPH_ID	NUMBER		Yes	Unique identifier for party payment header
PYD_ID	NUMBER		Yes	Unique identifier for payment details record
VENDOR_ID	NUMBER		Yes	Identifier for vendor. It is the vendor to whom payment is to be made. In case the party role is a TCA party this is the vendor corresponding to TCA party
PASSTHRU_TERM	VARCHAR2	(10)	Yes	Passthrough term: base and evergreen
PASSTHRU_TERM_NAME	VARCHAR2	(80)		Passthrough term name: base and evergreen
PAY_SITE_ID	NUMBER			Identifier for Vendor payment site
PAY_SITE_NAME	VARCHAR2	(15)		Site code name
PAY_GROUP_CODE	VARCHAR2	(30)		Pay group code
PAY_GROUP_NAME	VARCHAR2	(80)		Pay group name
PAYMENT_TERM_ID	NUMBER			Payment term Identifier
PAYMENT_TERM_NAME	VARCHAR2	(50)		Payment term name
PAYMENT_FREQUENCY	VARCHAR2	(15)		Payment frequency
PAYMENT_FREQUENCY_NAME	VARCHAR2	(80)		Payment frequency name
PAYMENT_BASIS	VARCHAR2	(15)		Payment basis
PAYMENT_BASIS_NAME	VARCHAR2	(80)		Payment basis name
CPL_ID	NUMBER		Yes	Contract party role identifier
CLE_ID	NUMBER			Contract line Identifier
DNZ_CHR_ID	NUMBER		Yes	Contract Identifier

Query Text

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


SELECT PPH_ID
,      PYD_ID
,      VENDOR_ID
,      PASSTHRU_TERM
,      PASSTHRU_TERM_NAME
,      PAY_SITE_ID
,      PAY_SITE_NAME
,      PAY_GROUP_CODE
,      PAY_GROUP_NAME
,      PAYMENT_TERM_ID
,      PAYMENT_TERM_NAME
,      PAYMENT_FREQUENCY
,      PAYMENT_FREQUENCY_NAME
,      PAYMENT_BASIS
,      PAYMENT_BASIS_NAME
,      CPL_ID
,      CLE_ID
,      DNZ_CHR_ID
FROM APPS.OKL_LA_VENDOR_PAYMENTS_UV;

Dependencies

[top of page]

APPS.OKL_LA_VENDOR_PAYMENTS_UV references the following:

APPS: AP_TERMS_TL; FND_GLOBAL - show dependent code; FND_LOOKUPS; OKL_PARTY_PAYMENT_DTLS; OKL_PARTY_PAYMENT_HDR; PO_LOOKUP_CODES; PO_VENDOR_SITES_ALL

APPS.OKL_LA_VENDOR_PAYMENTS_UV is not referenced by any database object