DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_PARTY_PAYMENT_HDR_V

Object Details
Object Name: OKL_PARTY_PAYMENT_HDR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_PARTY_PAYMENT_HDR_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
ID NUMBER
Yes Unique identifier for payment header
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object version number
DNZ_CHR_ID NUMBER
Yes Denormalized 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 Payout basis
PAYOUT_BASIS_FORMULA VARCHAR2 (150)
Payout Basis Formula
EFFECTIVE_FROM DATE
Yes Effective from
EFFECTIVE_TO DATE

Effective to
PASSTHRU_TERM VARCHAR2 (10) Yes Passthrough Term
PASSTHRU_STREAM_TYPE_ID NUMBER

Passthru Stream Type Identifier
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
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      DNZ_CHR_ID
,      CLE_ID
,      PPL_ID
,      PASSTHRU_START_DATE
,      PAYOUT_BASIS
,      PAYOUT_BASIS_FORMULA
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      PASSTHRU_TERM
,      PASSTHRU_STREAM_TYPE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_PARTY_PAYMENT_HDR_V;

Dependencies

[top of page]

APPS.OKL_PARTY_PAYMENT_HDR_V references the following:

SchemaAPPS
SynonymOKL_PARTY_PAYMENT_HDR
APPS.OKL_PARTY_PAYMENT_HDR_V is referenced by following:

SchemaAPPS
Package BodyOKL_COPY_CONTRACT_PVT - show dependent code
Package BodyOKL_LDB_PVT - show dependent code
PL/SQL PackageOKL_LDB_PVT - show dependent code
PL/SQL PackageOKL_MAINTAIN_FEE_PVT - show dependent code
PL/SQL PackageOKL_PARTY_PAYMENTS_PVT - show dependent code