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]

TABLE: OKL.OKL_PARTY_PAYMENT_HDR_H

Object Details

Object Name:	OKL_PARTY_PAYMENT_HDR_H
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_PARTY_PAYMENT_HDR_H
Subobject Name:
Status:	VALID

History table for okl_party_payment_hdr to store pass through line level parameters

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_PARTY_PAYMENT_HDR_H_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID MAJOR_VERSION

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Unique identifier for party payment header
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
DNZ_CHR_ID	NUMBER		Yes	Contract Identifier
CLE_ID	NUMBER			Contract Line Identifier
PPL_ID	NUMBER			Payment Plan Identifier
PASSTHRU_START_DATE	DATE			Passthrough start date
PAYOUT_BASIS	VARCHAR2	(30)	Yes	Passthrough payout basis: Billing, Due Date, Partial Receipt, Full Receipt, Formula
EFFECTIVE_FROM	DATE		Yes	Contract start date
EFFECTIVE_TO	DATE			Contract end date
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
PASSTHRU_TERM	VARCHAR2	(10)	Yes	Passthrough term: base and evergreen
PAYOUT_BASIS_FORMULA	VARCHAR2	(150)		Payout Basis Formula stores the formula for payout basis "FORMULA" option.
PASSTHRU_STREAM_TYPE_ID	NUMBER			Stream type identifier
MAJOR_VERSION	NUMBER	(4)	Yes	Major version number

Query Text

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


SELECT ID
,      OBJECT_VERSION_NUMBER
,      DNZ_CHR_ID
,      CLE_ID
,      PPL_ID
,      PASSTHRU_START_DATE
,      PAYOUT_BASIS
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PASSTHRU_TERM
,      PAYOUT_BASIS_FORMULA
,      PASSTHRU_STREAM_TYPE_ID
,      MAJOR_VERSION
FROM OKL.OKL_PARTY_PAYMENT_HDR_H;

Dependencies

[top of page]

OKL.OKL_PARTY_PAYMENT_HDR_H does not reference any database object

OKL.OKL_PARTY_PAYMENT_HDR_H is referenced by following:

APPS: OKL_PARTY_PAYMENT_HDR_H