Search Results source_org_id

Overview

MRP_AP_INTRANSIT_SUPPLIES_V is an Oracle EBS reporting view belonging to the MRP (Master Scheduling/MRP) product family. It exposes supply records that are in transit between organizations, specifically intransit supply lines originating from sales order shipments. The view is part of the MRP application programming interface (API) view set, a collection of database objects used internally by the planning engine to consolidate on-hand, intransit, and expected supply and demand signals. In Oracle EBS 12.1.1 and 12.2.2, these views are typically referenced by planning data collection programs rather than by end-user forms or concurrent reports. The ETRM metadata records the view as not implemented in the documented database, meaning it exists only in environments where the relevant planning components have been deployed and the underlying staging tables are populated. Users searching for the term "new_order_quantity" will find that this identifier maps to a specific aliased column within the view, not to a base table column name, which is a common point of confusion when tracing supply quantity logic across planning objects.

Underlying Base Objects

The view text joins several base and staging objects. The primary base tables are SO_HEADERS_ALL, which supplies the sales order header identifiers, and SO_PICKING_LINES_ALL, which provides the picking line, inventory item, and unit of measure information. Four staging snapshot tables contribute the supply and departure data: MRP_AP_SO_PK_HDRS_SN, MRP_AP_WSH_DEPAS_SN (workflow shipping departures), MRP_AP_SO_PK_DTLS_SN (picking details), and MRP_AP_MRP_PARAS_SN (planning parameters). MRP_AP_SYS_ITEMS_SN supplies the inventory item validity context, and HR_ORGANIZATION_INFORMATION supplies the organization identifiers and customer/supplier association attributes. The joins are keyed on HEADER_ID, PICKING_HEADER_ID, PICKING_LINE_ID, and DEPARTURE_ID, with organization and item resolution handled through MSI and the CUSTOMER/SUPPLIER ASSOCIATION flexfield context on HR_ORGANIZATION_INFORMATION. The role of the view is therefore to assemble a planning-usable intransit supply record from transactional sales order shipment data and planning snapshot tables.

Key Columns

• HEADER_ID: Sales order header identifier from SO_HEADERS_ALL.
• PO_NUMBER: Alias for SHA.ORDER_NUMBER, used as the planning document number.
• INVENTORY_ITEM_ID: Item identifier from the picking line.
• ORDER_TYPE: Hard-coded constant 11, identifying the supply record type.
• PURCH_LINE_NUM: Alias for SPLA.ORDER_LINE_ID; carries the line identifier for planning reference.
• FIRM_PLANNED_STATUS_TYPE: Hard-coded constant 2, marking the record as a firm planned supply.
• UOM_CODE / LINE_ID: Unit of measure and the picking line identifier.
• NEW_ORDER_QUANTITY: Alias for SPLD.SHIPPED_QUANTITY; the quantity released for shipment that constitutes the intransit supply. This is the column most often sought when users search for "new_order_quantity".
• SOURCE_ORG_ID: Alias for SPLD.WAREHOUSE_ID, the organization from which the supply originates.
• NEW_SCHEDULE_DATE: Alias for WD.PLANNED_DEPARTURE_DATE; the expected departure date used for scheduling.
• ACTUAL_DEPARTURE_DATE: The recorded actual departure, if available.
• ORGANIZATION_ID, CUSTOMER_ID, ARRIVED_FLAG: Destination organization, customer, and arrival status indicators.
• RN1 through RN5: Row numbering columns used by the planning collection logic.

Common Use Cases and Queries

This view is principally consumed by planning data collection and intransit supply verification. A typical diagnostic query isolates shipped quantities and departure dates for a given item and source organization:

• SELECT PO_NUMBER, INVENTORY_ITEM_ID, NEW_ORDER_QUANTITY, NEW_SCHEDULE_DATE, SOURCE_ORG_ID FROM MRP_AP_INTRANSIT_SUPPLIES_V WHERE INVENTORY_ITEM_ID = :item_id AND SOURCE_ORG_ID = :org_id;
• Aggregate intransit supply by organization: SELECT SOURCE_ORG_ID, SUM(NEW_ORDER_QUANTITY) FROM MRP_AP_INTRANSIT_SUPPLIES_V GROUP BY SOURCE_ORG_ID;
• Identify records pending arrival: SELECT PO_NUMBER, NEW_ORDER_QUANTITY, ACTUAL_DEPARTURE_DATE, ARRIVED_FLAG FROM MRP_AP_INTRANSIT_SUPPLIES_V WHERE ARRIVED_FLAG IS NULL OR ARRIVED_FLAG = 'N';

Because the view depends on snapshot tables, results reflect the last planning collection run rather than live transactional state. Administrators should confirm that MRP collection has executed before drawing conclusions from the data.