Search Results pmifv_inventory_transactions_v




Overview
Explore in AI Chat

Overview

PMIFV_INVENTORY_TRANSACTIONS_V is an APPS-owned database view within the Process Manufacturing Intelligence (PMI) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It consolidates detail information about all completed and pending inventory transactions into a single unified result set, allowing reporting and analytical tools to query transaction activity without joining separate completion and pending tables directly.

The view is particularly relevant to users searching on the term current_period. Because each transaction row is joined to the PMI inventory calendar through date-range logic, the view exposes fiscal year, period, period description, and period start/end dates. This makes it the natural source for period-aware inventory reporting, where users need to isolate transactions falling within the open or current accounting period rather than filtering raw transaction dates manually.

Underlying Base Objects

The view is defined as a UNION ALL of two symmetric branches. The first selects from IC_TRAN_CMP (completed transactions) and the second from IC_TRAN_PND (pending transactions); each branch is literaled with a discriminator value ('C' for completed, 'P' for pending). Both branches are joined to IC_ITEM_MST for item attributes and to PMI_INV_CALENDAR_V for calendar attributes.

Key Columns

Common Use Cases and Queries

The view supports period-scoped inventory reporting, reconciliation between completed and pending movements, and lot-level traceability. A typical query filtering to the current accounting period uses the calendar columns exposed by the view:

  • Reporting all transactions for an organization within the current period by comparing SYSDATE against START_DATE and END_DATE.
  • Comparing completed versus pending activity by grouping on the type discriminator.
  • Extracting UOM-normalized quantities for cost or yield analysis.
  • Auditing GL posting status via GL_POSTED_IND for a given fiscal year and period.

Sample SQL:

SELECT TRANS_ID, ITEM_NO, ORGN_CODE, TRANS_QTY, TRANS_UM, FISCAL_YEAR, PERIOD, PERIOD_DESC FROM APPS.PMIFV_INVENTORY_TRANSACTIONS_V WHERE TRUNC(SYSDATE) BETWEEN START_DATE AND END_DATE AND ORGN_CODE = :org;

Oracle organization security is applied automatically through PMI_SECURITY_PKG.SHOW_RECORD, so results are restricted to organizations the querying user is permitted to view.