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

TABLE: OKL.OKL_PARTY_ROLES_INTERFACE

Object Details
Object Name: OKL_PARTY_ROLES_INTERFACE
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_PARTY_ROLES_INTERFACE
Subobject Name:
Status: VALID


OKL_PARTY_ROLES_INTERFACE stores information used to create party role (Guarantor, Lease Vendor, Label Holder) at contract header and/or line level during Lease contract open interface import. This table also captures information of billing vendor as customer (popularly known as vendor billing).
Scope: public
Product: OKL
Display Name: OKL Contract Party Open Interface
Category: BUSINESS_ENTITY OKL_CONTRACT
Lifecycle: active


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_PARTY_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCONTRACT_NUMBER_OLD
Columns
Name Datatype Length Mandatory Comments
CONTRACT_NUMBER_OLD VARCHAR2 (30) Yes Legacy Contract number. Used to link party role records with imported contract.
LINE_NUMBER NUMBER

Line number
ASSET_VENDOR_NAME VARCHAR2 (240)
Name of vendor of assets. Validated against OKX_VENDORS_V.NAME.
ASSET_VENDOR_ID NUMBER

ID of vendor of assets. Validated against OKX_VENDORS_V.ID1.
SERVICE_VENDOR_NAME VARCHAR2 (240)
Name of vendor of service. Validated against OKX_VENDORS_V.NAME.
SERVICE_VENDOR_ID NUMBER

ID of vendor of service. Validated against OKX_VENDORS_V.ID1.
FEES_VENDOR_NAME VARCHAR2 (240)
Name of vendor of fee. Validated against OKX_VENDORS_V.NAME.
FEES_VENDOR_ID NUMBER

ID of vendor of fee. Validated against OKX_VENDORS_V.ID1.
GUARANTOR_NUMBER VARCHAR2 (30)
Guarantor number (credit guarantor). Validated against OKX_PARTIES_V.PARTY_NUMBER.
GUARANTOR_ID NUMBER

Guarantor ID (credit guarantor). Validated against OKX_PARTIES_V.ID1.
GUARANTOR_SITE_NUMBER VARCHAR2 (30)
Guarantor site address number. Validated against OKX_PARTY_SITES_V.PARTY_SITE_NUMBER.
GUARANTOR_SITE_ID NUMBER

Guarantor site address ID. Validated against OKX_PARTY_SITES_V.ID1.
DEALER_NAME VARCHAR2 (80)
Dealer Name.
DEALER_ID NUMBER

Delear ID.
GUARANTOR_TYPE VARCHAR2 (30)
Type of credit guarantor for contract.
GUARANTEE_TYPE VARCHAR2 (30)
Type of credit guarantee (primary, secondary).
GUARANTEED_AMOUNT NUMBER

Amount of credit guarantee.
GUARANTEE_DATE DATE

Date guarantee received.
GUARANTEE_COMMENT VARCHAR2 (50)
Credit guarantee group comment.
BILLABLE_VENDOR_ID NUMBER

Billable vendor ID. The billable vendor is a valid asset vendor. Validated against OKX_VENDORS_V.ID1.
BILLABLE_VENDOR_NAME VARCHAR2 (240)
Billable vendor name. The billable vendor is a valid asset vendor. Validate against OKX_VENDORS_V.NAME.
VEND_AS_CUSTOMER_NUMBER VARCHAR2 (30)
Customer Name for billing. Validated against OKX_PARTIES_V.PARTY_NUMBER.
VEND_AS_CUSTOMER_ID NUMBER

Customer ID for billing. Validated against OKX_PARTIES_V.ID1.
VEND_AS_CUSTOMER_ACC_NUMBER VARCHAR2 (30)
Customer account number for billing. Validated against OKX_CUSTOMER_ACCOUNTS_V.DESCRIPTION.
VEND_AS_CUSTOMER_ACC_ID NUMBER

Customer account id for billing. Validated against OKX_CUSTOMER_ACCOUNTS_V.ID1.
VEND_BILL_TO_ADDR_ID NUMBER

Billing address ID. Validated against OKX_CUST_SITE_USES_V.ID1.
VEND_BILL_TO_ADDR VARCHAR2 (240)
Billing address ID. Validated against OKX_CUST_SITE_USES_V.ID1.
VEND_PAYMENT_METHOD_ID NUMBER

Payment method ID. Validated against OKX_RECEIPT_METHODS_V.ID1.
VEND_PAYMENT_METHOD VARCHAR2 (30)
Payment method. Validated against OKX_RECEIPT_METHODS_V.NAME.
VEND_BANK_ACC_ID NUMBER

Bank account ID. Validated against OKX_RCPT_METHOD_ACCOUNTS_V.ID1.
VEND_BANK_ACC_NUMBER VARCHAR2 (30)
Bank account number. Validated against OKX_RCPT_METHOD_ACCOUNTS_V.BANK_ACCOUNT_NUM.
VEND_INVOICE_FORMAT_ID NUMBER

Invoice format ID. Validated against OKL_INVOICE_FORMATS_V.ID1.
VEND_INVOICE_FORMAT_CODE VARCHAR2 (150)
Invoice format code. Validated against OKL_INVOICE_FORMATS_V.NAME.
VEND_REVIEW_INVOICE_FLAG VARCHAR2 (3)
Review invoice flag. Valid values are 'Y' or 'N'.
VEND_REASON_FOR_INV_REVIEW VARCHAR2 (50)
Reason for invoice review.
VEND_INV_REVIEW_UNTIL_DATE DATE

Invoice review until date.
PTH_BASE_VENDOR_SITE_CODE VARCHAR2 (150)
Pass through base term vendor site code
PTH_BASE_VENDOR_SITE_CODE_1 VARCHAR2 (150)
Pass through base term vendor site code
PTH_BASE_VENDOR_SITE_ID NUMBER

Pass through base term vendor site identifier
PTH_BASE_PAYGROUP_CODE VARCHAR2 (30)
Pass through base term paygroup code
PTH_BASE_PMNT_TERM_CODE VARCHAR2 (50)
Pass through base term payment term code
PTH_BASE_PMNT_TERM_ID NUMBER

Pass through base term payment term identifier
PTH_BASE_PMNT_BASIS VARCHAR2 (15)
Pass through base term payment basis
PTH_BASE_PMNT_START_DATE DATE

Pass through base term payment start date
PTH_BASE_PMNT_METHOD_CODE VARCHAR2 (30)
Pass through base term payment method code
PTH_BASE_PMNT_FREQ VARCHAR2 (15)
Pass through base term payment frequency
PTH_BASE_PMNT_REMIT_DAYS NUMBER

Pass through base term remittance days
PTH_BASE_DISB_BASIS VARCHAR2 (10)
Pass through base term disbursement basis
PTH_BASE_DISB_FIXED_AMOUNT NUMBER

Pass through base term disbursement fixed amount
PTH_BASE_DISB_PCT NUMBER

Pass through base term disbursement percentage
PTH_BASE_PROC_FEE_BASIS VARCHAR2 (10)
Pass through base term processing fee basis
PTH_BASE_PROC_FEE_FIXED_AMT NUMBER

Pass through base term processing fee fixed amount
PTH_BASE_PROC_PCT NUMBER

Pass through base term processing fee percentage
PTH_EVG_VENDOR_SITE_CODE VARCHAR2 (150)
Pass through evergreen term vendor site code
PTH_EVG_VENDOR_SITE_ID NUMBER

Pass through evergreen term vendor site identifier
PTH_EVG_PAYGROUP_CODE VARCHAR2 (30)
Pass through evergreen paygroup code
PTH_EVG_PMNT_TERM_CODE VARCHAR2 (30)
Pass through evergreen term payment term code
PTH_EVG_PMNT_TERM_ID NUMBER

Pass through evergreen term payment term identifier
PTH_EVG_PMNT_BASIS VARCHAR2 (15)
Pass through evergreen term payment basis
PTH_EVG_PMNT_START_DATE DATE

Pass through evergreen term payment start date
PTH_EVG_PMNT_METHOD_CODE VARCHAR2 (30)
Pass through evergreen term payment method code
PTH_EVG_PMNT_FREQ VARCHAR2 (30)
Pass through evergreen term payment frequency
PTH_EVG_PMNT_REMIT_DAYS NUMBER

Pass through evergreen term remittance days
PTH_EVG_DISB_BASIS VARCHAR2 (10)
Pass through evergreen term disbursement basis
PTH_EVG_DISB_FIXED_AMOUNT NUMBER

Pass through evergreen term disbursement fixed amount
PTH_EVG_DISB_PCT NUMBER

Pass through evergreen term disbursement percentage
PTH_EVG_PROC_FEE_BASIS VARCHAR2 (10)
Pass through evergreen term processing fee basis
PTH_EVG_PROC_FEE_FIXED_AMT NUMBER

Pass through evergreen term processing fee fixed amount
PTH_EVG_PROC_PCT NUMBER

Pass through evergreen term processing percentage
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive column
Query Text

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


SELECT CONTRACT_NUMBER_OLD
,      LINE_NUMBER
,      ASSET_VENDOR_NAME
,      ASSET_VENDOR_ID
,      SERVICE_VENDOR_NAME
,      SERVICE_VENDOR_ID
,      FEES_VENDOR_NAME
,      FEES_VENDOR_ID
,      GUARANTOR_NUMBER
,      GUARANTOR_ID
,      GUARANTOR_SITE_NUMBER
,      GUARANTOR_SITE_ID
,      DEALER_NAME
,      DEALER_ID
,      GUARANTOR_TYPE
,      GUARANTEE_TYPE
,      GUARANTEED_AMOUNT
,      GUARANTEE_DATE
,      GUARANTEE_COMMENT
,      BILLABLE_VENDOR_ID
,      BILLABLE_VENDOR_NAME
,      VEND_AS_CUSTOMER_NUMBER
,      VEND_AS_CUSTOMER_ID
,      VEND_AS_CUSTOMER_ACC_NUMBER
,      VEND_AS_CUSTOMER_ACC_ID
,      VEND_BILL_TO_ADDR_ID
,      VEND_BILL_TO_ADDR
,      VEND_PAYMENT_METHOD_ID
,      VEND_PAYMENT_METHOD
,      VEND_BANK_ACC_ID
,      VEND_BANK_ACC_NUMBER
,      VEND_INVOICE_FORMAT_ID
,      VEND_INVOICE_FORMAT_CODE
,      VEND_REVIEW_INVOICE_FLAG
,      VEND_REASON_FOR_INV_REVIEW
,      VEND_INV_REVIEW_UNTIL_DATE
,      PTH_BASE_VENDOR_SITE_CODE
,      PTH_BASE_VENDOR_SITE_CODE_1
,      PTH_BASE_VENDOR_SITE_ID
,      PTH_BASE_PAYGROUP_CODE
,      PTH_BASE_PMNT_TERM_CODE
,      PTH_BASE_PMNT_TERM_ID
,      PTH_BASE_PMNT_BASIS
,      PTH_BASE_PMNT_START_DATE
,      PTH_BASE_PMNT_METHOD_CODE
,      PTH_BASE_PMNT_FREQ
,      PTH_BASE_PMNT_REMIT_DAYS
,      PTH_BASE_DISB_BASIS
,      PTH_BASE_DISB_FIXED_AMOUNT
,      PTH_BASE_DISB_PCT
,      PTH_BASE_PROC_FEE_BASIS
,      PTH_BASE_PROC_FEE_FIXED_AMT
,      PTH_BASE_PROC_PCT
,      PTH_EVG_VENDOR_SITE_CODE
,      PTH_EVG_VENDOR_SITE_ID
,      PTH_EVG_PAYGROUP_CODE
,      PTH_EVG_PMNT_TERM_CODE
,      PTH_EVG_PMNT_TERM_ID
,      PTH_EVG_PMNT_BASIS
,      PTH_EVG_PMNT_START_DATE
,      PTH_EVG_PMNT_METHOD_CODE
,      PTH_EVG_PMNT_FREQ
,      PTH_EVG_PMNT_REMIT_DAYS
,      PTH_EVG_DISB_BASIS
,      PTH_EVG_DISB_FIXED_AMOUNT
,      PTH_EVG_DISB_PCT
,      PTH_EVG_PROC_FEE_BASIS
,      PTH_EVG_PROC_FEE_FIXED_AMT
,      PTH_EVG_PROC_PCT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM OKL.OKL_PARTY_ROLES_INTERFACE;

Dependencies

[top of page]

OKL.OKL_PARTY_ROLES_INTERFACE does not reference any database object

OKL.OKL_PARTY_ROLES_INTERFACE is referenced by following:

SchemaAPPS
SynonymOKL_PARTY_ROLES_INTERFACE