Results for “net_quantity”

10 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.WIP_JOBS_RESERVATIONS_V is a Work in Process (WIP) reporting view that exposes discrete jobs eligible for material reservations. It is a filtered, read-only projection rather than a base table, and its purpose is to present only those jobs whose remaining available quantity justifies further reservation activity, or which are already linked to pending move-order/LPN supply. Because the view is owned by APPS and marked VALID in both 12.1.1 and 12.2.2, it is safe to reference from custom concurrent programs, BI Publisher reports, OAF pages, and integration extracts without concern for schema drift across these releases. The user search term start_quantity maps directly to one of the view's exposed columns, and it is central to the view's internal eligibility logic: the quantity remaining for reservation is computed as START_QUANTITY - QUANTITY_SCRAPPED - QUANTITY_COMPLETED and compared against the sum of existing primary reservations. The view therefore answers the operational question "which discrete jobs still have unreserved or partially reserved demand, or which have staged supply awaiting reservation?"

Underlying Base Objects

The view is defined over two synonyms and references additional objects within its inline subqueries. The dominant join is between WIP_DISCRETE_JOBS (aliased WDJ), which supplies job-level attributes including START_QUANTITY, and WIP_ENTITIES (WE), which supplies the job name and entity type, joined on WIP_ENTITY_ID. A correlated subquery aggregates WIP_RESERVATIONS_V to derive the sum of primary reserved quantities per job. A further set of EXISTS predicates interrogates MTL_TXN_REQUEST_LINES joined to WMS_LICENSE_PLATE_NUMBERS, restricted to undelivered lines (NVL(QUANTITY_DELIVERED,0)=0), LPN context 2, and line status other than 5, to identify jobs with pending LPN-based supply. The documented metadata also lists INV_CONVERT as a referenced object, reflecting shipped Oracle logic that may invoke conversion utilities. Note that the view does not expose move-order lines directly; it merely tests for their existence.

Key Columns

Common Use Cases and Queries

Typical usage includes identifying jobs available for reservation, reconciling reserved versus remaining quantities, and driving move-order generation for LPN-enabled warehouses. A simple query filtered on the searched column might read:

  • SELECT wip_entity_name, organization_id, status_type, start_quantity, net_quantity FROM wip_jobs_reservations_v WHERE organization_id = :org AND status_type IN (1,3) ORDER BY scheduled_start_date;
  • SELECT wip_entity_id, start_quantity FROM wip_jobs_reservations_v WHERE primary_item_id = :item AND start_quantity > 0;
  • Joining the view to WIP_RESERVATIONS_V to compare the view's implied remaining quantity against actual reservation records.

Because the view already applies complex eligibility filtering, developers should avoid re-implementing the START_QUANTITY arithmetic and instead treat the view as the authoritative source for reservation-eligible job lists.