Search Results serialization_start_op




Overview
Explore in AI Chat

Overview

The view APPS.WIP_OPEN_DISCRETE_JOBS_VAL_V is a Work in Process (WIP) reporting object that exposes open discrete jobs within an Oracle E-Business Suite environment. Registered in the APPS schema with a status of VALID, it is delivered for use in both release 12.1.1 and 12.2.2. Its stated purpose is the presentation of open discrete jobs — records representing manufacturing work orders that have been released to the shop floor but not yet closed. In the terminology of EBS validation views, the _VAL_V suffix signals that the object is intended to support value-set, lookup, and reference validation, making it a candidate data source for list-of-values queries, concurrent program parameters, and integration extracts where a compact set of open jobs is required.

Underlying Base Objects

The view is defined over two documented base objects, both exposed through APPS synonyms: WIP_DISCRETE_JOBS and WIP_ENTITIES. The join is an equi-join on WIP_ENTITY_ID, with WIP_ENTITIES supplying the entity name and entity type while WIP_DISCRETE_JOBS contributes the job-level attributes. The critical filter is J.STATUS_TYPE IN (1, 3, 4, 6), which restricts the result set to open job statuses — unreleased, released, complete, and on hold — and excludes closed, cancelled, and pending-close jobs. Because it is a simple two-table validation view with no aggregation, it inherits minimal performance overhead and is safe to query directly from reports, forms, and PL/SQL validation logic.

Key Columns

Common Use Cases and Queries

Typical applications include open job list-of-values on transactional forms, shop floor dispatch reports, and integration extracts feeding MES or scheduling systems. A representative query retrieving jobs that have a defined serialization start operation is shown below.

  • Validate a discrete job number entered by a user against open jobs in a specific organization.
  • Extract all open jobs and their serialization start operation for serial-tracked assemblies.
  • Report scheduled start and completion dates for released but incomplete work orders.
SELECT wip_entity_name,
       description,
       organization_id,
       scheduled_start_date,
       scheduled_completion_date,
       start_quantity,
       serialization_start_op
FROM   apps.wip_open_discrete_jobs_val_v
WHERE  organization_id = :p_org_id
AND    status_type IN (1,3,4,6)
AND    serialization_start_op IS NOT NULL
ORDER BY scheduled_start_date;

Because the view already enforces the open-status filter, consumers should not re-apply status predicates unless a narrower subset is required. As with all EBS validation views, it should be referenced through the APPS synonym and never queried against the underlying tables with hard-coded schema prefixes.