Results for “intraoperation_step_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.WIP_DISC_INTRAOP_STEPS_VAL_V view is a Work in Process (WIP) reporting and integration object that exposes the discrete intraoperation step status of released jobs and schedules. In Oracle EBS 12.1.1 and 12.2.2, WIP tracks shop floor quantities across five discrete intraoperation steps — Queue, Running, Waiting to Move, Rejected, and Scrapped — and this view consolidates those quantities into a single denormalized result set keyed by organization, WIP entity, and operation sequence. It serves as a validated, stable read interface for reports, dashboards, and external integrations that must determine how much material currently sits at each intraoperation step.
Because the object is a view rather than a table, it presents no stored data of its own; it derives its rows dynamically from WIP operation quantity columns and WIP intraoperation step configuration. It is registered as VALID in the APPS schema and is documented under the WIP - Work in Process product for both 12.1.1 and 12.2.2.
Underlying Base Objects
The view is defined over three documented objects:
- WIP_OPERATIONS (synonym) — aliased
WO, supplying the organization, WIP entity, current operation sequence, next operation sequence, and the five intraoperation quantity columns used in the decode. - WIP_VALID_INTRAOPERATION_STEPS (synonym) — aliased
WVIS, providing the valid step configuration per organization and theSTEP_LOOKUP_TYPEthat drives both the step type and the quantity decode. - MFG_LOOKUPS (view) — aliased
LU, providing the lookup meaning for each step whereLOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'.
The join is on ORGANIZATION_ID between WIP_OPERATIONS and WIP_VALID_INTRAOPERATION_STEPS, with a lookup join on LOOKUP_CODE = STEP_LOOKUP_TYPE. Row eligibility is constrained by a compound predicate: steps recorded as USER-created are always returned, step type 1 (Queue) is returned regardless of creator, and SYSTEM-created steps are returned only when the next operation sequence is null (that is, the final operation). This logic prevents system-seeded steps from appearing prematurely on intermediate operations.
Key Columns
- ORGANIZATION_ID — inventory organization owning the job or schedule.
- WIP_ENTITY_ID — the discrete job or repetitive schedule identifier.
- OPERATION_SEQ_NUM — the operation sequence at which the step quantity is measured.
- NEXT_OPERATION_SEQ_NUM — the subsequent operation sequence, used in the SYSTEM-creator filtering logic.
- INTRAOPERATION_STEP_TYPE — the numeric lookup code (1 Queue, 2 Running, 3 Waiting to Move, 4 Rejected, 5 Scrapped) sourced from
WVIS.STEP_LOOKUP_TYPE. - INTRAOPERATION_STEP_MEANING — the translated lookup meaning for the step.
- INTRAOPERATION_STEP_QUANTITY — the quantity at the step, resolved by a DECODE that maps step type 1 to
QUANTITY_IN_QUEUE, 2 toQUANTITY_RUNNING, 3 toQUANTITY_WAITING_TO_MOVE, 4 toQUANTITY_REJECTED, and 5 toQUANTITY_SCRAPPED.
Common Use Cases and Queries
Typical uses include shop floor status reporting, WIP quantity reconciliation, and feeders for MES or analytics extracts. A representative query returning current step quantities for a job is:
SELECT organization_id
, wip_entity_id
, operation_seq_num
, intraoperation_step_meaning
, intraoperation_step_quantity
FROM apps.wip_disc_intraop_steps_val_v
WHERE organization_id = :p_org_id
AND wip_entity_id = :p_wip_entity_id
ORDER BY operation_seq_num, intraoperation_step_type;
Aggregated queue-versus-running comparisons across an organization are equally straightforward:
SELECT operation_seq_num
, intraoperation_step_meaning
, SUM(intraoperation_step_quantity) total_qty
FROM apps.wip_disc_intraop_steps_val_v
WHERE organization_id = :p_org_id
GROUP BY operation_seq_num, intraoperation_step_meaning;
Because the view already resolves step types to meanings, it is preferable to joining MFG_LOOKUPS manually, and it respects the same creator and final-operation rules applied by the WIP discrete intraoperation validation logic.
-
Intraoperation steps
APPS.WIP_DISC_INTRAOP_STEPS_VAL_V·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·↳ WIP_VALID_INTRAOPERATION_STEPS·Explore WIP module →
-
Intraoperation steps
APPS.WIP_DISC_INTRAOP_STEPS_VAL_V·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·↳ WIP_VALID_INTRAOPERATION_STEPS·Explore WIP module →
-
Repetitive intraoperation steps for released/complete schedules
APPS.WIP_TX_REP_INTRAOP_STEPS_VAL_V·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·↳ WIP_REPETITIVE_SCHEDULES·Explore WIP module →
-
Repetitive intraoperation steps
APPS.WIP_REP_INTRAOP_STEPS_VAL_V·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·↳ WIP_REPETITIVE_SCHEDULES·Explore WIP module →
-
Repetitive intraoperation steps
APPS.WIP_REP_INTRAOP_STEPS_VAL_V·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·↳ WIP_REPETITIVE_SCHEDULES·Explore WIP module →
-
APPS.WIP_JOB_SERIAL_NUMBERS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore WIP module →
-
APPS.WIP_JOB_SERIAL_NUMBERS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore WIP module →
-
APPS.WIPBV_INTRAOP_STEP_STATUSES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·↳ MTL_PARAMETERS·Explore WIP module →
-
APPS.WIPBV_INTRAOP_STEP_STATUSES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·↳ MTL_PARAMETERS·Explore WIP module →
-
APPS.WIPFV_INTRAOP_STEP_STATUSES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·↳ MTL_PARAMETERS·Explore WIP module →
-
Repetitive intraoperation steps for released/complete schedules
APPS.WIP_TX_REP_INTRAOP_STEPS_VAL_V·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·↳ WIP_REPETITIVE_SCHEDULES·Explore WIP module →
-
Statuses assigned to particular jobs and schedules
-
APPS.WIPFV_INTRAOP_STEP_STATUSES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·↳ MTL_PARAMETERS·Explore WIP module →
-
Foreign-key data for WIP_SHOP_FLOOR_STATUSES
APPS.WIP_SHOP_FLOOR_STATUSES_V·↳ BOM_DEPARTMENTS·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·Explore WIP module →
-
10SC ONLY
APPS.MTL_SERIAL_NUMBERS_VAL_V·↳ MTL_SERIAL_NUMBERS·Explore INV module →
-
Statuses assigned to particular jobs and schedules
-
Foreign-key data for WIP_SHOP_FLOOR_STATUSES
APPS.WIP_SHOP_FLOOR_STATUSES_V·↳ BOM_DEPARTMENTS·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·Explore WIP module →
-
10SC ONLY
APPS.MTL_SERIAL_NUMBERS_VAL_V·↳ MTL_SERIAL_NUMBERS·Explore INV module →
-
10SC ONLY
APPS.MTL_SERIAL_NUMBERS_ALL_V·↳ MFG_LOOKUPS·↳ MTL_MATERIAL_STATUSES_TL·↳ MTL_PARAMETERS·Explore INV module →
-
10SC ONLY
APPS.MTL_SERIAL_NUMBERS_ALL_V·↳ MFG_LOOKUPS·↳ MTL_MATERIAL_STATUSES_TL·↳ MTL_PARAMETERS·Explore INV module →
-
Serial number definitions
-
Serial number definitions