Results for “payment_term_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OKL_LESSEE_AS_VENDORS_UV view is a user interface view within the Oracle Lease and Finance Management (OKL) product module. It presents vendor (payment) details for a lessee, where the lessee is represented as a TCA party. The view is owned by the APPS schema and has a VALID status in both Oracle EBS 12.1.1 and 12.2.2.
The view serves as a consolidated reporting and integration layer that surfaces payment-related attributes for lessees who are treated as vendors in the payables domain. It joins payment detail records from the lease management data model with vendor master information, vendor site details, payment terms, and role definitions. Because the join to OKC_K_PARTY_ROLES_B is restricted to the role code LESSEE, the view returns payment profiles only for parties acting in a lessee capacity.
The object is referenced by the user interface to render vendor payment fields, and it is equally suitable for custom reports, data extracts, and integration interfaces that require lessee payment information. The column of particular interest to users searching on payment_term_descr is PAYMENT_TERM_DESCR, which exposes the descriptive text of the payment term associated with the lessee's vendor record.
Underlying Base Objects
The view is defined over the following documented base objects:
- OKL_PARTY_PAYMENT_DTLS (synonym) — the driving table, aliased PPYD, holding party payment detail records keyed by CPL_ID.
- OKC_K_PARTY_ROLES_B (synonym) — aliased KPR, supplying the party role and the DNZ_CHR_ID contract identifier, filtered to RLE_CODE = 'LESSEE'.
- PO_VENDORS (view) — aliased PV, providing vendor name and SEGMENT1 (vendor number).
- PO_VENDOR_SITES (view) — aliased VS, providing the pay site code, address components, and site description.
- AP_TERMS_TL (synonym) — aliased APT, providing the translated payment term NAME and DESCRIPTION.
- AP_LOOKUP_CODES (view) — used in a scalar subquery to resolve PAYMENT METHOD display text.
- PO_LOOKUP_CODES (view) — used in a scalar subquery to resolve PAY GROUP display text.
- ARP_ADDR_LABEL_PKG (package) — invoked to format the pay site address into the PAY_SITE_DESCR column.
- FND_GLOBAL (package) — referenced through USERENV('LANG') to align the payment term translation language.
Join conditions link vendor to vendor site by VENDOR_ID, connect the pay site through an outer join on VENDOR_SITE_ID, and attach payment terms through an outer join on TERM_ID with the language predicate. The lessee constraint is enforced by KPR.ID = PPYD.CPL_ID combined with RLE_CODE = 'LESSEE'.
Key Columns
- ID — primary identifier from OKL_PARTY_PAYMENT_DTLS.
- OBJECT_VERSION_NUMBER — optimistic locking version for the underlying record.
- DNZ_CHR_ID — contract identifier from the party role.
- CPL_ID — party role identifier linking to OKC_K_PARTY_ROLES_B.
- VENDOR_ID, VENDOR_NAME, SEGMENT1 — vendor identifier, name, and vendor number.
- PAY_SITE_ID, PAY_SITE_NAME, PAY_SITE_DESCR — pay site identifier, site code, and formatted address.
- PAYMENT_TERM_ID, PAYMENT_TERM_NAME, PAYMENT_TERM_DESCR — payment term identifier, name, and description from AP_TERMS_TL; PAYMENT_TERM_DESCR is the descriptive field returned by the search term
payment_term_descr. - PAYMENT_METHOD_CODE, PAYMENT_METHOD_NAME, PAYMENT_METHOD_DESCR — payment method code and decoded display name; PAYMENT_METHOD_DESCR is returned as NULL.
- PAY_GROUP_CODE, PAY_GROUP_NAME, PAY_GROUP_DESCR — pay group code and decoded display name; PAY_GROUP_DESCR is returned as NULL.
Common Use Cases and Queries
Typical scenarios include displaying lessee payment profiles in lease management screens, extracting payment terms for downstream payables processing, and validating that lessee vendor records carry the correct payment method and pay group.
To retrieve payment terms for all lessees:
SELECT vendor_id, vendor_name, payment_term_name, payment_term_descr FROM okl_lessee_as_vendors_uv;
To locate lessees using a specific payment term description:
SELECT cpl_id, vendor_name, pay_site_name, payment_term_descr FROM okl_lessee_as_vendors_uv WHERE payment_term_descr LIKE '%NET%';
To report payment method and pay group by contract:
SELECT dnz_chr_id, vendor_name, payment_method_name, pay_group_name FROM okl_lessee_as_vendors_uv ORDER BY dnz_chr_id;
Because PAYMENT_TERM_DESCR originates from AP_TERMS_TL through an outer join, the column may be NULL when no payment term is assigned. Consumers should account for this in report logic and integration mappings.
-
User interface view for vemdor (payment) details for a lessee(TCA party)
APPS.OKL_LESSEE_AS_VENDORS_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ ARP_ADDR_LABEL_PKG·Explore OKL module →
-
View: APFV_AP_PAYMENT_TERMS 12.1.1
Business view
-
View: APFV_AP_PAYMENT_TERMS 12.2.2
Business view
-
User interface view to indicate passthrough vendors on a Passthrough Fee or Service
APPS.OKL_LA_PASSTHRU_VENDOR_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ FND_GLOBAL·Explore OKL module →
-
User interface view for subsidies party payment details page
APPS.OKL_PARTY_PAYMENT_DTLS_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ ARP_ADDR_LABEL_PKG·Explore OKL module →
-
View: APBV_AP_PAYMENT_TERMS 12.1.1
Business view
-
View: APBV_AP_PAYMENT_TERMS 12.2.2
Business view
-
Business view to show information about the customer agreements.
APPS.PAFV_CUSTOMER_AGREEMENTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HZ_CUST_ACCOUNTS·Explore PA module →
-
View: ARFV_AR_TERMS 12.1.1
Stores information about the specific payment conditions applicable to the customer for the sale of goods or services.
-
User interface view that displays payment information for a context vendor
APPS.OKL_LA_VENDOR_PAYMENTS_UV·↳ AP_TERMS_TL·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore OKL module →
-
User interface view that displays payment information for a context vendor
APPS.OKL_LA_VENDOR_PAYMENTS_UV·↳ AP_TERMS_TL·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore OKL module →
-
View: ARFV_AR_TERMS 12.2.2
Stores information about the specific payment conditions applicable to the customer for the sale of goods or services.
-
User interface view for vemdor (payment) details for a lessee(TCA party)
APPS.OKL_LESSEE_AS_VENDORS_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ ARP_ADDR_LABEL_PKG·Explore OKL module →
-
Business view to show information about the customer agreements.
APPS.PAFV_CUSTOMER_AGREEMENTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HZ_CUST_ACCOUNTS·Explore PA module →
-
APPS.AST_CUST_PROFILE_CREDIT_V·↳ AR_COLLECTORS·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore AST module →
-
APPS.AST_CUST_PROFILE_CREDIT_V·↳ AR_COLLECTORS·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore AST module →
-
View: CSC_ACCOUNT_OVERVIEW_V 12.1.1
CSC_ACCOUNT_OVERVIEW_V retrieves an overview of the customer account.
APPS.CSC_ACCOUNT_OVERVIEW_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ RA_TERMS_TL·Explore CSC module →
-
View: OKL_OR_SUBSIDY_REFUNDS 12.1.1
APPS.OKL_OR_SUBSIDY_REFUNDS·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ FND_GLOBAL·Explore OKL module →
-
View: OKL_OR_SUBSIDY_REFUNDS 12.2.2
APPS.OKL_OR_SUBSIDY_REFUNDS·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ FND_GLOBAL·Explore OKL module →
-
User interface view for subsidies party payment details page
APPS.OKL_PARTY_PAYMENT_DTLS_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ ARP_ADDR_LABEL_PKG·Explore OKL module →
-
View: ECE_CDMO_HEADER_V 12.2.2
This view extracts header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header View@rep:category BUSINESS_ENTITY AR_CRE
APPS.ECE_CDMO_HEADER_V·↳ AR_BATCH_SOURCES·↳ AR_PAYMENT_SCHEDULES·↳ AR_SYSTEM_PARAMETERS·Explore EC module →
-
APPS.OKL_CS_CUST_ACCT_OVERVIEW_UV·↳ AR_LOOKUPS·↳ AR_STATEMENT_CYCLES·↳ HZ_CUSTOMER_PROFILES·Explore OKL module →
-
View: CSC_ACCOUNT_OVERVIEW_V 12.2.2
CSC_ACCOUNT_OVERVIEW_V retrieves an overview of the customer account.
APPS.CSC_ACCOUNT_OVERVIEW_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ RA_TERMS_TL·Explore CSC module →
-
View: HZ_SITE_USES_V 12.1.1
APPS.HZ_SITE_USES_V·↳ AR_RECEIVABLES_TRX·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →
-
APPS.OKL_CS_CUST_ACCT_OVERVIEW_UV·↳ AR_LOOKUPS·↳ AR_STATEMENT_CYCLES·↳ HZ_CUSTOMER_PROFILES·Explore OKL module →
-
View: ASO_PAYMENTS_V 12.1.1
view based on aso_payments
APPS.ASO_PAYMENTS_V·↳ ASO_I_PAYMENT_TYPES_V·↳ ASO_PAYMENTS·↳ IBY_FNDCPT_TRXN_PUB·Explore ASO module →
-
User interface view to indicate passthrough vendors on a Passthrough Fee or Service
APPS.OKL_LA_PASSTHRU_VENDOR_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ FND_GLOBAL·Explore OKL module →
-
View: ARFV_CUSTOMER_SITES 12.2.2
APPS.ARFV_CUSTOMER_SITES·↳ FND_TERRITORIES_VL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →
-
View: ECE_INO_HEADER_V 12.2.2
This view extracts header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Header View@rep:category BUSINESS_ENTITY AR_INVOICE
APPS.ECE_INO_HEADER_V·↳ AR_PAYMENT_SCHEDULES·↳ ECE_AR_TRANSACTION·↳ ECE_TP_DETAILS·Explore EC module →
-
View: ECE_INO_HEADER_V 12.1.1
This view extracts header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Header View@rep:category BUSINESS_ENTITY AR_INVOICE
APPS.ECE_INO_HEADER_V·↳ AR_PAYMENT_SCHEDULES·↳ ECE_AR_TRANSACTION·↳ ECE_TP_DETAILS·Explore EC module →
-
APPS.CSC_CUST_PROFILE_CREDIT_V·↳ AR_COLLECTORS·↳ HZ_CUSTOMER_PROFILES·↳ HZ_CUST_ACCOUNTS·Explore CSC module →
-
View: ECE_CDMO_HEADER_V 12.1.1
This view extracts header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header View@rep:category BUSINESS_ENTITY AR_CRE
APPS.ECE_CDMO_HEADER_V·↳ AR_BATCH_SOURCES·↳ AR_PAYMENT_SCHEDULES·↳ AR_SYSTEM_PARAMETERS·Explore EC module →
-
View: ARFV_CUSTOMER_SITES 12.1.1
APPS.ARFV_CUSTOMER_SITES·↳ FND_TERRITORIES_VL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →
-
APPS.CSC_CUST_PROFILE_CREDIT_V·↳ AR_COLLECTORS·↳ HZ_CUSTOMER_PROFILES·↳ HZ_CUST_ACCOUNTS·Explore CSC module →
-
View: AR_SITE_USES_V 12.1.1
(Release 11.5 Only)
APPS.AR_SITE_USES_V·↳ AR_LOOKUPS·↳ AR_RECEIVABLES_TRX·↳ FND_COMMON_LOOKUPS·Explore AR module →
-
View: ARFV_DEBITS 12.1.1
This shows information relating to items that increase your customer's receivable balance. Debit items remain open until the balance due is zero.
APPS.ARFV_DEBITS·↳ AR_RECEIPT_METHODS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_COMMON_PUB·Explore AR module →
-
View: ARFV_DEBITS 12.2.2
This shows information relating to items that increase your customer's receivable balance. Debit items remain open until the balance due is zero.
APPS.ARFV_DEBITS·↳ AR_RECEIPT_METHODS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore AR module →
-
View: ASO_PAYMENTS_V 12.2.2
view based on aso_payments
APPS.ASO_PAYMENTS_V·↳ ASO_I_PAYMENT_TYPES_V·↳ ASO_PAYMENTS·↳ FND_GLOBAL·Explore ASO module →
-
View: ARFV_INVOICE_ARS 12.2.2
This shows information about an invoice. An invoice is a document that lists amounts owed for the purchase of goods or services.
APPS.ARFV_INVOICE_ARS·↳ AR_RECEIPT_METHODS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore AR module →
-
This shows information about entries against accounts receivable transactions ( both debits and credits ), except adjustments and miscellaneous cash.
APPS.ARFV_AR_PAYMENT_SCHEDULES·↳ AR_CASH_RECEIPTS·↳ AR_COLLECTORS·↳ AR_CONS_INV·Explore AR module →
-
This shows information about entries against accounts receivable transactions ( both debits and credits ), except adjustments and miscellaneous cash.
APPS.ARFV_AR_PAYMENT_SCHEDULES·↳ AR_CASH_RECEIPTS·↳ AR_COLLECTORS·↳ AR_CONS_INV·Explore AR module →
-
View: IGS_FI_CONTROL_V 12.1.1
APPS.IGS_FI_CONTROL_V·↳ FND_CURRENCIES_TL·↳ GL_SETS_OF_BOOKS·↳ HR_OPERATING_UNITS·Explore IGS module →
-
View: ARFV_CREDIT_MEMO_ARS 12.1.1
This shows information about documents that partially or fully reduce the original balance due for an invoice.
APPS.ARFV_CREDIT_MEMO_ARS·↳ AR_RECEIPT_METHODS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_COMMON_PUB·Explore AR module →
-
View: ARFV_CREDITS 12.1.1
This shows information about any item that you can apply to an open debit item to reduce the balance due for a customer. Credit items remain open until they are fully applied.
APPS.ARFV_CREDITS·↳ AR_RECEIPT_METHODS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_COMMON_PUB·Explore AR module →
-
View: ARFV_CREDIT_MEMO_ARS 12.2.2
This shows information about documents that partially or fully reduce the original balance due for an invoice.
APPS.ARFV_CREDIT_MEMO_ARS·↳ AR_RECEIPT_METHODS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore AR module →
-
This shows information about credits that you assign to your customers account that are not related to a specific invoice.
APPS.ARFV_ON_ACCOUNT_CREDIT_MEMOS·↳ AR_RECEIPT_METHODS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_COMMON_PUB·Explore AR module →
-
View: ARFV_INVOICE_ARS 12.1.1
This shows information about an invoice. An invoice is a document that lists amounts owed for the purchase of goods or services.
APPS.ARFV_INVOICE_ARS·↳ AR_RECEIPT_METHODS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_COMMON_PUB·Explore AR module →
-
View: AR_SITE_USES_V 12.2.2
(Release 11.5 Only)
APPS.AR_SITE_USES_V·↳ AR_LOOKUPS·↳ AR_RECEIVABLES_TRX·↳ FND_COMMON_LOOKUPS·Explore AR module →
-
This shows information about credits that you assign to your customers account that are not related to a specific invoice.
APPS.ARFV_ON_ACCOUNT_CREDIT_MEMOS·↳ AR_RECEIPT_METHODS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore AR module →
-
View: ARFV_CREDITS 12.2.2
This shows information about any item that you can apply to an open debit item to reduce the balance due for a customer. Credit items remain open until they are fully applied.
APPS.ARFV_CREDITS·↳ AR_RECEIPT_METHODS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore AR module →