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

VIEW: APPS.OKL_LA_PASSTHROUGH_HDR_UV

Object Details
Object Name: OKL_LA_PASSTHROUGH_HDR_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_PASSTHROUGH_HDR_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
ID NUMBER
Yes Passthrough payment header unique identifier
CLE_ID NUMBER

Foreign key to table OKC_K_LINES_ALL_B
DNZ_CHR_ID NUMBER
Yes Foreign key to table OKC_K_HEADERS_ALL_B
PASSTHRU_START_DATE DATE

Passthrough start date
PAYOUT_BASIS VARCHAR2 (30) Yes Passthrough payout basis code: Billing, Due Date, Partial Receipt, Full Receipt, Formula
PAYOUT_BASIS_NAME VARCHAR2 (80)
Passthrough payout basis name: Billing, Due Date, Partial Receipt, Full Receipt, Formula
EFFECTIVE_FROM DATE
Yes Start date
EFFECTIVE_TO DATE

End date
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
NAME VARCHAR2 (150)
Stream type name
Query Text

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


SELECT ID
,      CLE_ID
,      DNZ_CHR_ID
,      PASSTHRU_START_DATE
,      PAYOUT_BASIS
,      PAYOUT_BASIS_NAME
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      PASSTHRU_TERM
,      PAYOUT_BASIS_FORMULA
,      PASSTHRU_STREAM_TYPE_ID
,      NAME
FROM APPS.OKL_LA_PASSTHROUGH_HDR_UV;

Dependencies

[top of page]

APPS.OKL_LA_PASSTHROUGH_HDR_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKL_PARTY_PAYMENT_HDR
SynonymOKL_STRM_TYPE_TL

APPS.OKL_LA_PASSTHROUGH_HDR_UV is not referenced by any database object