Search Results supplier_notif_method




Overview
Explore in AI Chat

Overview

APPS.POFV_MC_PURCHASE_ORDERS is a Business Intelligence System (BIS) view in the Oracle E-Business Suite APPS schema, classified under the FND Design Data namespace PO.POFV_MC_PURCHASE_ORDERS. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2. The view implements the Multiple Reporting Currencies (MRC) functionality, which allows an alternative reporting currency to be specified for a purchase order based on the Set of Books. Rather than storing a single functional-currency representation of a purchase order, the MRC model records the same transaction in both the primary and reporting currencies, and this view exposes that reporting-currency perspective alongside the operating-unit and conversion-rate context required to interpret it.

For reporting and integration purposes, the view provides a flattened, denormalized projection of purchase-order header attributes joined to Set of Books, operating unit, and currency conversion type information. It is intended primarily for read-only reporting, ad hoc enquiry, and extract routines rather than for transactional updates. The user search term update_sourcing_rules_flag corresponds directly to a column exposed by this view and reflects one of the document-control flags carried on the purchase-order header.

Underlying Base Objects

The documented base objects referenced by the view are:

  • PO_HEADERS_ALL (SYNONYM) — the primary purchase-order header table supplying document identifiers, operating unit, supplier notification attributes, sourcing flags, and tax-attribute update information.
  • HR_ALL_ORGANIZATION_UNITS (SYNONYM) — the organization definition table supplying the operating unit name for the operating unit identifier on the purchase order.
  • GL_DAILY_CONVERSION_TYPES (SYNONYM) — the General Ledger conversion-rate type definition table supplying the rate type name and description used to translate between the primary and reporting currencies.

All three are referenced through synonyms visible in the APPS schema, which is consistent with the standard Oracle EBS layered-synonym architecture. Because the view is MRC-enabled, the effective row count and currency values depend on the reporting Set of Books in scope.

Key Columns

The view exposes columns across four logical groups:

UPDATE_SOURCING_RULES_FLAG is a VARCHAR2 flag indicating whether the purchase order is permitted to update sourcing rules when the document is processed, a control relevant to sourcing-rule-driven replenishment and blanket/planned order behaviour.

Common Use Cases and Queries

Typical scenarios include reporting purchase orders in a reporting currency, auditing sourcing-rule and retro-price flag settings, and extracting supplier notification configuration.

  • List purchase orders whose sourcing rules are eligible for update:
  • Report reporting-currency values for a specific Set of Books:

Sample SQL:

SELECT document_number,
       operating_unit_name,
       currency_conversion_rate,
       update_sourcing_rules_flag
FROM   apps.pofv_mc_purchase_orders
WHERE  update_sourcing_rules_flag = 'Y';
SELECT set_of_books_name,
       document_number,
       rate_type_name,
       currency_conversion_rate
FROM   apps.pofv_mc_purchase_orders
WHERE  set_of_books_id = :p_set_of_books_id;

The view should be treated as read-only for integration purposes; flag maintenance is performed against PO_HEADERS_ALL through the purchasing application programming interfaces and forms.