Search Results msc_hub_query_s

Overview

MSC_ITEM_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It is a core component of the Oracle Advanced Supply Chain Planning (ASCP) and related MSC (Supply Chain Planning) modules. Its principal business function is to manage the summarization, export, and import of item-level inventory and order data used by the planning engine. The package consolidates detailed transactional records into planning-friendly summary tables and provides the transfer mechanisms that move item inventory and order information between source systems and the planning repository. In EBS 12.1.1 and 12.2.2, this package is marked VALID, and its metadata classifies it as an OTHER-type API rather than a formal public interface. The presence of the MSC_HUB_QUERY and MSC_HUB_QUERY_S dependencies — the latter being the object the searcher referenced — indicates that the package relies on hub query views to source and stage planning data.

Key Procedures and Functions

POPULATE_DETAILS — Populates item-level detail records that support downstream inventory and order processing within the planning schema.
SUMMARIZE_ITEM_INVENTORY_F — Aggregates and summarizes inventory-level records into the item inventory fact table (MSC_ITEM_INVENTORY_F) for planning consumption.
SUMMARIZE_ITEM_ORDERS_F — Aggregates and summarizes order records into the item orders fact table (MSC_ITEM_ORDERS_F).
EXPORT_ITEM_INVENTORY_F — Exports summarized item inventory fact data, typically to staging or external planning structures.
EXPORT_ITEM_ORDERS_F — Exports summarized item orders fact data for downstream planning or integration use.
IMPORT_ITEM_INVENTORY_F — Imports item inventory fact data into the planning schema, generally from a staging table (for example MSC_ST_ITEM_INVENTORY_F).
IMPORT_ITEM_ORDERS_F — Imports item orders fact data into the planning schema, generally from a staging table (for example MSC_ST_ITEM_ORDERS_F).

The documented procedures therefore follow a consistent pattern: populate, summarize, export, and import of item inventory and order facts. Parameter lists are not documented in the available metadata and are not reproduced here.

Tables Accessed

The package reads and writes a broad set of planning tables through APPS synonyms, including:

MSC_ITEM_INVENTORY_F and MSC_ITEM_ORDERS_F — the primary fact tables targeted by the summarize, export, and import procedures.
MSC_ST_ITEM_INVENTORY_F and MSC_ST_ITEM_ORDERS_F — staging tables that hold imported inventory and order data.
MSC_HUB_QUERY and MSC_HUB_QUERY_S — hub query and query-set structures used to source planning data.
MSC_BIS_INV_DETAIL, MSC_INVENTORY_LEVELS, MSC_SAFETY_STOCKS — inventory detail, level, and safety stock sources.
MSC_DEMANDS, MSC_DEMANDS_F, MSC_SUPPLIES, MSC_SUPPLIES_F — demand and supply records linked to item planning.
MSC_FULL_PEGGING, MSC_EXCEPTIONS_F — pegging and exception data referenced during processing.
MSC_PLANS and MSC_PLAN_RUNS — plan and plan-run context used to scope execution.
MSC_APCC_ITEM_D — item dimension data supporting the APC/APCC collections.

Standard dependencies on FND_GLOBAL, FND_LOG, FND_PROFILE, and Msc_phub_util support logging, profile lookups, and utility operations.

Usage Notes

MSC_ITEM_PKG is not referenced by any other database object in the metadata, indicating it is invoked directly rather than as a utility library. In practice it is typically called from ASCP concurrent programs (such as planning data collection and item summarization workers) and from planning-related forms or custom code performing export/import of item inventory and order facts. It executes under the APPS schema and relies on standard FND profile values to determine plan and organization context. Because it is a package body with no documented API classification, customizations should treat it as an internal implementation package and invoke it only through supported concurrent program entry points.

SEQUENCE: MSC.MSC_HUB_QUERY_S 12.1.1
owner:MSC, object_type:SEQUENCE, object_name:MSC_HUB_QUERY_S, status:VALID,
SEQUENCE: MSC.MSC_HUB_QUERY_S 12.2.2
owner:MSC, object_type:SEQUENCE, object_name:MSC_HUB_QUERY_S, status:VALID,
SYNONYM: APPS.MSC_HUB_QUERY_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MSC_HUB_QUERY_S, status:VALID,
SYNONYM: APPS.MSC_HUB_QUERY_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MSC_HUB_QUERY_S, status:VALID,
PACKAGE BODY: APPS.MSC_ITEM_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_ITEM_PKG, status:VALID,
PACKAGE BODY: APPS.MSC_PHUB_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_PHUB_UTIL, status:VALID,
PACKAGE BODY: APPS.MSC_PHUB_EXCESS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_PHUB_EXCESS_PKG, status:VALID,
PACKAGE BODY: APPS.MSC_SUPPLIER_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_SUPPLIER_PKG, status:VALID,
PACKAGE BODY: APPS.MSC_SUPPLIER_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_SUPPLIER_PKG, status:VALID,
PACKAGE BODY: APPS.MSC_DEMAND_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_DEMAND_PKG, status:VALID,
PACKAGE BODY: APPS.MSC_PHUB_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_PHUB_PKG, status:VALID,
PACKAGE BODY: APPS.MSC_SUPPLY_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_SUPPLY_PKG, status:VALID,
PACKAGE BODY: APPS.MSC_DEMANTRA_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:MSC_DEMANTRA_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.MSC_DEMAND_PKG dependencies on MSC_HUB_QUERY_S 12.1.1
APPS.MSC_PHUB_PKG dependencies on MSC_HUB_QUERY_S 12.2.2
APPS.MSC_PHUB_EXCESS_PKG dependencies on MSC_HUB_QUERY_S 12.2.2
APPS.MSC_ITEM_PKG dependencies on MSC_HUB_QUERY_S 12.1.1
APPS.MSC_PHUB_UTIL dependencies on MSC_HUB_QUERY_S 12.2.2
APPS.MSC_SUPPLY_PKG dependencies on MSC_HUB_QUERY_S 12.1.1
APPS.MSC_SUPPLIER_PKG dependencies on MSC_HUB_QUERY_S 12.1.1
APPS.MSC_DEMANTRA_PKG dependencies on MSC_HUB_QUERY_S 12.2.2
APPS.MSC_SUPPLIER_PKG dependencies on MSC_HUB_QUERY_S 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1