Search Results price_differential_desc

Overview

APPS.PO_PRICE_DIFF_LOOKUPS_V is a reporting and validation view in Oracle E-Business Suite that exposes the subset of Oracle Purchasing lookup values used to describe price differentials on purchase order and sourcing documents. Its purpose is to present a curated, security-filtered list of lookup codes that a user may select when defining how a supplier's price differs from a reference or base price — for example premiums, surcharges, or negotiated adjustments relative to a standard price. The view is commonly consumed by Oracle Forms, OAF pages, concurrent programs, and custom integrations that need to populate a list of valid price differential types without directly joining the underlying Flexfields (FND) lookup tables. Because the view already applies the security group, enabled flag, and date-range filters, consuming applications obtain only the lookup values that are currently valid and authorized for the calling user's session.

Underlying Base Objects

The view is defined over three documented referenced base objects: FND_GLOBAL (a package), FND_LOOKUP_TYPES_VL (a view), and FND_LOOKUP_VALUES_VL (a view). FND_LOOKUP_TYPES_VL supplies the lookup type definition, while FND_LOOKUP_VALUES_VL supplies the individual code/meaning/description rows. The two are joined on LOOKUP_TYPE, SECURITY_GROUP_ID, and VIEW_APPLICATION_ID. The view restricts results to the lookup type 'PRICE DIFFERENTIALS' belonging to APPLICATION_ID = 201 (Oracle Purchasing) and VIEW_APPLICATION_ID = 0. The join to FND_GLOBAL is made through a call to FND_GLOBAL.LOOKUP_SECURITY_GROUP, which returns the security group applicable to the current session, ensuring that the caller only sees lookups belonging to their authorized security group.

Key Columns

• LOOKUP_CODE — The internal code identifying the price differential, such as a premium or surcharge identifier. Two codes, 'STANDARD' and 'FIXED PRICE', are intentionally excluded by the view definition.
• MEANING — The user-facing display text associated with the lookup code, typically shown in list of values (LOV) prompts and reports.
• DESCRIPTION — A longer explanatory string providing additional context about the differential, useful for tooltips and documentation.

Row filtering is applied through standard FND conventions: ENABLED_FLAG must be 'Y' (defaulted via NVL), and the current SYSDATE must fall between the effective START_DATE_ACTIVE and END_DATE_ACTIVE values. These filters guarantee that only currently active, enabled differentials are returned.

Common Use Cases and Queries

Typical scenarios include populating a price differential LOV on purchase order price adjustment forms, driving supplier price comparison reports, and validating inbound differential codes in interfaces. A representative query follows:

• SELECT LOOKUP_CODE, MEANING, DESCRIPTION FROM APPS.PO_PRICE_DIFF_LOOKUPS_V ORDER BY MEANING;
• SELECT MEANING FROM APPS.PO_PRICE_DIFF_LOOKUPS_V WHERE LOOKUP_CODE = :p_code;

Note that the view is read-only and inherits the security and date filters from its definition, so no additional WHERE clause is required for standard consumption. The search phrase "pricecheck south africa prune juice price" does not relate to this view; the object concerns Oracle Purchasing price differential lookup values, not retail pricing of consumer goods.