Results for “v_site”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.OKL_BPD_DISB_LOV_UV is a read-only Oracle EBS view that supplies the list of values used when a disbursement or payment must be associated with a vendor and a specific vendor site on an Oracle Lease and Finance Management (OKL) contract. The view joins contract header information to the vendor identity and, critically, to the payable vendor site, so that downstream disbursement processing can default the pay group, payment method, payment terms, and terms identifier for the chosen site. Because it is exposed in the APPS schema and built entirely from other views and synonyms, it is intended for reporting, LOV population, and integration rather than for direct DML. In the context of EBS 12.1.1 and 12.2.2 the object is delivered as part of the lease management module and inherits the multi-org and MOAC behavior of the underlying purchasing and contracts views.

Underlying Base Objects

The view is defined over five referenced objects, all resolved through APPS synonyms or views:

• OKC_K_HEADERS_B — the contract headers base table (synonym), supplying CONTRACT_ID and CONTRACT_NUMBER.
• OKC_K_PARTY_ROLES_V — the contract party roles view, filtered to RLE_CODE = 'OKL_VENDOR', linking each contract to its vendor party.
• OKX_VENDORS_V — the vendor master view, supplying VENDOR_ID and VENDOR_NAME.
• PO_VENDOR_SITES_ALL — the purchasing vendor sites view, restricted to PAY_SITE_FLAG = 'Y', supplying the payable site and its payment attributes.
• OKL_BPD_PAY_TERMS_V — the lease payment terms view, supplying the TERMS description.

FND_GLOBAL is referenced for session context (organization and user), consistent with standard EBS views. The joins are driven by contract ID, party role, vendor ID, and site terms ID.

Key Columns

• CONTRACT_ID / CONTRACT_NUMBER — identity of the OKL contract header.
• CURRENCY_CODE — contract currency.
• VENDOR_ID / VENDOR_NAME — vendor party on the contract.
• VENDOR_SITE_ID / VENDOR_SITE_CODE — the payable vendor site.
• PAY_GROUP_LOOKUP_CODE — payment group (pay group) for the site.
• PAYMENT_METHOD_LOOKUP_CODE — default payment method for the site.
• TERMS_ID / TERMS — payment terms identifier and its description.

Common Use Cases and Queries

The view is typically queried to populate an LOV showing valid payable sites for a contract, or to retrieve default payment attributes during disbursement setup.

SELECT contract_number, vendor_name, vendor_site_code,
       pay_group_lookup_code, payment_method_lookup_code, terms
FROM   apps.okl_bpd_disb_lov_uv
WHERE  contract_id = :p_contract_id;

To find all sites available for a given vendor across contracts:

SELECT contract_number, currency_code, vendor_site_code, terms
FROM   apps.okl_bpd_disb_lov_uv
WHERE  vendor_id = :p_vendor_id
ORDER BY contract_number, vendor_site_code;

Because only payable sites (PAY_SITE_FLAG = 'Y') are exposed, results are already restricted to sites eligible for disbursement. Queries should always filter by contract or vendor to avoid a full scan across all lease contracts.