Search Results inv_mgd_mvt_stats_pvt




Overview
Explore in AI Chat

Overview

INV_MGD_MVT_STATS_PVT is a private PL/SQL package in the APPS schema that supports the Managed Movement Statistics feature of Oracle Inventory. Its role is to compute, validate, and maintain records in the movement statistics tables used to report the movement of goods across fiscal and statistical boundaries, a capability required by tax and customs authorities in many jurisdictions (for example, Intrastat reporting within the European Union).

The package name carries the _PVT suffix, which by Oracle E-Business Suite naming convention designates it as a private implementation package. It is not intended to be called directly by external code; rather, it is invoked by the public package INV_MGD_MVT_STATS_PUB and by the concurrent-processing entry point INV_MGD_MVT_STATS_PROC, which orchestrate the user-visible behavior. The ETRM metadata classifies this object as API classification PVT and confirms its status is VALID in the 12.1.1 and 12.2.2 releases.

The package depends on the standard Oracle API foundation (FND_API) and on the record structure definition package INV_MGD_MVT_DATA_STR, which supplies the PL/SQL types used to pass movement data between the public and private layers. It is referenced by INV_MGD_MVT_STATS_PUB, INV_MGD_MVT_STATS_PROC, and INV_MGD_MVT_VALIDATE_PROC, and it references itself through internal recursive calls.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within this package:

  • CREATE_MOVEMENT_STATISTICS — Constructs new movement statistics records for qualifying transactions, populating the statistics tables for later reporting.
  • INIT_MOVEMENT_RECORD — Initializes an in-memory movement record, establishing default values before fields are populated.
  • GET_OPEN_MVMT_STATS_TXNS — Retrieves open (unprocessed or incomplete) movement statistics transactions eligible for processing.
  • GET_PENDING_TXNS — Identifies pending transactions awaiting inclusion in the statistics.
  • GET_INVOICE_TRANSACTIONS — Gathers invoice-related transactions relevant to movement statistics, supporting inbound movement derived from payables activity.
  • GET_PO_TRANS_WITH_CORRECTION — Retrieves purchase order transactions including corrections, ensuring amended receipts are reflected accurately.
  • UPDATE_MOVEMENT_STATISTICS — Modifies existing movement statistics records when underlying transaction data changes.
  • VALIDATE_MOVEMENT_STATISTICS — Applies validation logic to computed statistics before they are committed.
  • DELETE_MOVEMENT_STATISTICS — Removes movement statistics records that are no longer valid or required.
  • VALIDATE_RULES — Evaluates configured movement statistics rules against transaction data to determine inclusion and classification.

No parameter lists are documented in the ETRM extract; the descriptions above reflect the functional intent implied by each name and by the object's purpose.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • MTL_MOVEMENT_STATISTICS — The primary table storing movement statistics records; the package creates, updates, and deletes rows here.
  • MTL_MOVEMENT_STATISTICS_S — The corresponding sequence or secondary table used during record creation.
  • MTL_MVT_STATS_RULES — Stores the user-defined rules evaluated by VALIDATE_RULES to decide which transactions qualify for reporting.
  • OE_ORDER_HEADERS_ALL — Supplies order header information for outbound movements originating from order management.
  • RCV_TRANSACTIONS — Provides receiving transaction details for inbound movements.
  • PLITBLM — The standard Oracle PL/SQL index-by table used internally for bulk processing.

Usage Notes

In normal operation, INV_MGD_MVT_STATS_PVT is never called directly by end users or custom code. It is invoked through INV_MGD_MVT_STATS_PUB for online form-driven processing, and through INV_MGD_MVT_STATS_PROC when the movement statistics generation is submitted as a concurrent program. Validation-only processing is routed via INV_MGD_MVT_VALIDATE_PROC. Customizations that need to extend movement statistics behavior should be directed at the public package or the concurrent program rather than at this private layer, since Oracle reserves the right to change private package signatures between patch levels.