Search Results lc_terms

Overview

APPS.AP_VENDOR_SITES_V is a reporting and integration view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that presents supplier site information in a denormalized, business-ready form. A supplier site represents a specific operating location for a supplier — for example a remit-to, purchasing, or RFQ-only location — and carries the payment, tax, freight, distribution, and address attributes required for procurement and payables processing. Because the underlying Payables tables store many of these attributes as lookup codes, location identifiers, and foreign keys, the view resolves them into displayed descriptions, territory short names, and formatted addresses. The view therefore serves as a convenient single source for reports, interfaces, custom concurrent programs, and inbound/outbound integrations that need human-readable supplier site data without repeatedly joining the same reference tables.

The user search term "lc_group" corresponds directly to a column exposed by this view, LC_GROUP.DISPLAYED_FIELD, which resolves the supplier site's payment group held in the base site record against the lookup definition to return the displayed value.

Underlying Base Objects

The view is owned by APPS and is defined over a mixture of synonyms, views, and packages. The primary driving entity is PO_VENDOR_SITES_ALL (with its PO_VENDOR_SITES view), which stores the site-level records for every operating unit and supplier. Supporting joins draw from HR_LOCATIONS_ALL for ship-to and bill-to location codes, ORG_FREIGHT for ship-via descriptions, FND_TERRITORIES_VL for territory short names, and FND_LANGUAGES_VL for language descriptions. Lookup-driven columns are resolved through PO_LOOKUP_CODES, covering FOB, freight terms, and payment group codes. Payment terms come from AP_TERMS, distribution sets from AP_DISTRIBUTION_SETS_ALL, and withholding tax groups from AP_AWT_GROUPS. Financials system parameters are read from FINANCIALS_SYSTEM_PARAMS_ALL, security context from FND_GLOBAL, and address formatting plus phone/FAX derivation from the AP_VENDOR_SITES_PKG and AP_UTILITIES_PKG packages. PO_LOCATION_ASSOCIATIONS_ALL links site locations used in purchasing.

Key Columns

• VENDOR_SITE_ID, VENDOR_ID, VENDOR_SITE_CODE — the site primary key, its parent supplier, and the user-visible site name.
• SHIP_TO_LOCATION_ID / HR_SHIPTO.LOCATION_CODE and BILL_TO_LOCATION_ID / HR_BILLTO.LOCATION_CODE — ship-to and bill-to location identifiers and codes.
• ADDRESS_LINE1 through ADDRESS_LINE4, CITY, COUNTY, STATE, PROVINCE, ZIP, COUNTRY, and the package-formatted address returning TERRITORY_SHORT_NAME — the mailing address as stored and as formatted.
• AREA_CODE, PHONE, FAX_AREA_CODE, FAX, TELEX — contact numbers.
• PURCHASING_SITE_FLAG, PAY_SITE_FLAG, RFQ_ONLY_SITE_FLAG, TAX_REPORTING_SITE_FLAG — flags indicating the site's functional purposes.
• LC_GROUP.DISPLAYED_FIELD — the displayed payment group for the site, resolved from the underlying lookup code (the object matching the search term "lc_group").
• LC_FOB.DISPLAYED_FIELD and LC_TERMS.DISPLAYED_FIELD — displayed FOB and freight terms.
• TERMS_ID / AT.NAME, DISTRIBUTION_SET_ID / AD.DISTRIBUTION_SET_NAME, AWT_GROUP_ID — payment terms, distribution set, and withholding tax group references.
• ACCTS_PAY_CODE_COMBINATION_ID, PREPAY_CODE_COMBINATION_ID — payables and prepayment accounting flexfield combinations.
• PAYMENT_CURRENCY_CODE, INVOICE_CURRENCY_CODE, PAYMENT_PRIORITY, PAY__DATE_BASIS_LOOKUP_CODE, PAY_GROUP_LOOKUP_CODE, ALWAYS_TAKE_DISC_FLAG — payment behavior attributes.
• HOLD_ALL_PAYMENTS_FLAG, HOLD_FUTURE_PAYMENTS_FLAG, HOLD_UNMATCHED_INVOICES_FLAG, HOLD_REASON, INVOICE_AMOUNT_LIMIT — payment and invoicing controls.
• INACTIVE_DATE — the date the site became inactive.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield columns available for client-specific data.

Common Use Cases and Queries

Typical uses include supplier master extracts, payables setup auditing, address validation interfaces, and procurement reporting. The view is frequently joined to AP_SUPPLIERS or PO_VENDORS on VENDOR_ID for supplier-level reporting.

List active payable sites for a supplier with their payment group:

• SELECT vendor_site_code, city, state, country, lc_group.displayed_field payment_group FROM ap_vendor_sites_v WHERE vendor_id = :p_vendor_id AND pay_site_flag = 'Y' AND (inactive_date IS NULL OR inactive_date > SYSDATE);

Audit formatted addresses and terms across purchasing sites:

• SELECT vendor_site_code, formatted_address, at.name terms_name, lc_terms.displayed_field freight_terms FROM ap_vendor_sites_v WHERE purchasing_site_flag = 'Y' ORDER BY vendor_site_code;

Identify sites on full payment hold:

• SELECT vendor_id, vendor_site_code, hold_reason FROM ap_vendor_sites_v WHERE hold_all_payments_flag = 'Y';

Because the view reads from PO_VENDOR_SITES_ALL, results reflect the supplier site definition for the current operating unit context; callers should ensure the correct organization is initialized via FND_GLOBAL before relying on the output.