[Home] [Help] [Dependency Information]
Object Name: | OKL_LA_PASSTHROUGH_HDR_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_LA_PASSTHROUGH_HDR_UV |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.OKL_LA_PASSTHROUGH_HDR_UV is not referenced by any database object
|
|
|