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

VIEW: APPS.OKL_PSTHRU_EVRGRN_PMNT_DTL_UV

Object Details
Object Name: OKL_PSTHRU_EVRGRN_PMNT_DTL_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_PSTHRU_EVRGRN_PMNT_DTL_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
PARTY_NAME VARCHAR2 (240)
Supplier name
OBJECT1_ID1 NUMBER

Supplier unique identifier
OBJECT1_ID2 CHAR (1)
(Multi-part) Primary Key
CPL_ID NUMBER

Party role identifier
B_PASSTHRU_TERM VARCHAR2 (0)
Passthrough term
B_PAYMENT_DTLS_ID VARCHAR2 (0)
Payment details identifier
B_PAYMENT_HDR_ID VARCHAR2 (0)
Payment header identifier
B_PAY_SITE_ID VARCHAR2 (0)
Pay site identifier
B_PAY_GROUP_CODE VARCHAR2 (0)
Pay group code
B_PAYMENT_TERM_ID VARCHAR2 (0)
Payment term identifier
B_PAYMENT_METHOD_CODE VARCHAR2 (0)
Payment method code
B_PAYMENT_BASIS VARCHAR2 (0)
Payment basis
B_PAYMENT_START_DATE VARCHAR2 (0)
Payment start date
B_PAYMENT_FREQUENCY VARCHAR2 (0)
Payment frequency
B_REMIT_DAYS VARCHAR2 (0)
Remit days
B_DISBURSEMENT_BASIS VARCHAR2 (0)
Disbursement basis
B_DISBURSEMENT_FIXED_AMOUNT VARCHAR2 (0)
Disbursement fixed amount
B_DISBURSEMENT_PERCENT VARCHAR2 (0)
Disbursement percent
B_PROCESSING_FEE_BASIS VARCHAR2 (0)
Processing fee basis
B_PROCESSING_FEE_FIXED_AMOUNT VARCHAR2 (0)
Processing fee fixed amount
B_PROCESSING_FEE_PERCENT VARCHAR2 (0)
Processing fee percent
CLE_ID NUMBER

Contract line identifier
E_PASSTHRU_TERM VARCHAR2 (10) Yes Passthrough term
E_PAYOUT_BASIS VARCHAR2 (30) Yes Payout basis
E_PAYMENT_DTLS_ID NUMBER

Payment details identifier
E_PAYMENT_HDR_ID NUMBER

Payment header identifier
E_PAY_SITE_ID NUMBER

Pay site identifier
E_PAY_GROUP_CODE VARCHAR2 (30)
Pay group code
E_PAYMENT_TERM_ID NUMBER

Payment term identifier
E_PAYMENT_METHOD_CODE VARCHAR2 (30)
Payment method code
E_PAYMENT_BASIS VARCHAR2 (15)
Payment basis
E_PAYMENT_START_DATE DATE

Payment start date
E_PAYMENT_FREQUENCY VARCHAR2 (15)
Payment frequency
E_REMIT_DAYS NUMBER

Remit days
E_DISBURSEMENT_BASIS VARCHAR2 (10)
Disbursement basis
E_DISBURSEMENT_FIXED_AMOUNT NUMBER

Disbursement fixed amount
E_DISBURSEMENT_PERCENT NUMBER

Disbursement percent
E_PROCESSING_FEE_BASIS VARCHAR2 (10)
Processing fee basis
E_PROCESSING_FEE_FIXED_AMOUNT NUMBER

Processing fee fixed amount
E_PROCESSING_FEE_PERCENT NUMBER

Processing fee percent
Query Text

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


SELECT PARTY_NAME
,      OBJECT1_ID1
,      OBJECT1_ID2
,      CPL_ID
,      B_PASSTHRU_TERM
,      B_PAYMENT_DTLS_ID
,      B_PAYMENT_HDR_ID
,      B_PAY_SITE_ID
,      B_PAY_GROUP_CODE
,      B_PAYMENT_TERM_ID
,      B_PAYMENT_METHOD_CODE
,      B_PAYMENT_BASIS
,      B_PAYMENT_START_DATE
,      B_PAYMENT_FREQUENCY
,      B_REMIT_DAYS
,      B_DISBURSEMENT_BASIS
,      B_DISBURSEMENT_FIXED_AMOUNT
,      B_DISBURSEMENT_PERCENT
,      B_PROCESSING_FEE_BASIS
,      B_PROCESSING_FEE_FIXED_AMOUNT
,      B_PROCESSING_FEE_PERCENT
,      CLE_ID
,      E_PASSTHRU_TERM
,      E_PAYOUT_BASIS
,      E_PAYMENT_DTLS_ID
,      E_PAYMENT_HDR_ID
,      E_PAY_SITE_ID
,      E_PAY_GROUP_CODE
,      E_PAYMENT_TERM_ID
,      E_PAYMENT_METHOD_CODE
,      E_PAYMENT_BASIS
,      E_PAYMENT_START_DATE
,      E_PAYMENT_FREQUENCY
,      E_REMIT_DAYS
,      E_DISBURSEMENT_BASIS
,      E_DISBURSEMENT_FIXED_AMOUNT
,      E_DISBURSEMENT_PERCENT
,      E_PROCESSING_FEE_BASIS
,      E_PROCESSING_FEE_FIXED_AMOUNT
,      E_PROCESSING_FEE_PERCENT
FROM APPS.OKL_PSTHRU_EVRGRN_PMNT_DTL_UV;

Dependencies

[top of page]

APPS.OKL_PSTHRU_EVRGRN_PMNT_DTL_UV references the following:

SchemaAPPS
SynonymOKL_PARTY_PAYMENT_DTLS
SynonymOKL_PARTY_PAYMENT_HDR
ViewOKX_VENDORS_V

APPS.OKL_PSTHRU_EVRGRN_PMNT_DTL_UV is not referenced by any database object