Results for “move_allowed”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WIP_SHOP_FLOOR_STATUSES_VAL_V is a validation view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Work in Process (WIP) product family and presents the set of shop floor statuses that are currently enabled for use within an organization. In shop floor execution, a status code is assigned to discrete jobs, repetitive schedules, and their associated operations or assemblies to control the physical movement of material through the manufacturing floor. The view serves as a filtered, read-only presentation layer that restricts the visible statuses to those that remain active, and it exposes a derived flag indicating whether a given status permits material movement.
Because it is registered as a validated view in the ETRM metadata, it is treated as a supported reference object for reporting and integration. It is commonly consumed by forms, list-of-values logic, and custom reports that must only offer statuses valid for the current point in time, rather than the complete maintenance set of status codes.
Underlying Base Objects
The view is defined over a single referenced base object, WIP_SHOP_FLOOR_STATUS_CODES, accessed through a synonym in the APPS schema. WIP_SHOP_FLOOR_STATUS_CODES is the maintenance table holding all shop floor status codes, their descriptions, movement attributes, organization ownership, and descriptive flexfield attribute columns. The view does not join additional tables; its transformation is limited to a row-level filter and one derived column.
The enabling filter is expressed as NVL(DISABLE_DATE, SYSDATE + 1) > SYSDATE. Rows whose DISABLE_DATE is null are treated as open-ended and therefore retained; rows with a disable date in the past are excluded. This means the view always reflects statuses that are effective as of the query execution time, so a status disabled yesterday no longer appears, while one scheduled for future disable remains visible until that date passes.
Key Columns
- SHOP_FLOOR_STATUS_CODE — the unique status code identifier used in job and schedule transactions.
- DESCRIPTION — the user-facing description of the status.
- MOVE_ALLOWED — a derived display column produced by DECODE(STATUS_MOVE_FLAG, 1, '*', ''). It returns an asterisk when movement is permitted and a blank otherwise, providing a compact visual indicator for LOVs and reports. This is the column most closely associated with the "move_allowed" search term.
- STATUS_MOVE_FLAG — the underlying numeric flag (1 or 0) that governs whether material movement is allowed under the status.
- ORGANIZATION_ID — the inventory organization to which the status belongs, enabling organization-specific filtering.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield segments carried through from the base table.
Common Use Cases and Queries
The view is typically used to populate selection lists and validation logic so that only enabled statuses are presented to users and interfaces. A representative query listing movement-capable statuses for a specific organization follows:
SELECT shop_floor_status_code,
description,
move_allowed,
status_move_flag
FROM apps.wip_shop_floor_statuses_val_v
WHERE organization_id = :org_id
AND status_move_flag = 1
ORDER BY shop_floor_status_code;
A second common pattern filters purely on the derived indicator for display purposes:
SELECT shop_floor_status_code, description, move_allowed FROM apps.wip_shop_floor_statuses_val_v WHERE organization_id = :org_id AND move_allowed = '*';
Typical applications include custom shop floor status LOVs, movement audit reports, and integration extracts loading WIP transactions into external MES or reporting systems. Because the view enforces the disable-date filter implicitly, consumers inherit current-effective statuses without repeating that logic, which reduces the risk of stale or retired codes appearing in downstream selections.
-
Enabled shop floor statuses
APPS.WIP_SHOP_FLOOR_STATUSES_VAL_V·↳ WIP_SHOP_FLOOR_STATUS_CODES·Explore WIP module →
-
Enabled shop floor statuses
APPS.WIP_SHOP_FLOOR_STATUSES_VAL_V·↳ WIP_SHOP_FLOOR_STATUS_CODES·Explore WIP module →
-
eTRM - WIP Tables and Views 12.1.1
-
eTRM - WIP Tables and Views 12.2.2