Results for “attribute_category”
50+ 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 →
-
View: WIP_LINES_VAL_V 12.1.1
Enabled production lines
-
Enabled shop floor statuses
APPS.WIP_SHOP_FLOOR_STATUSES_VAL_V·↳ WIP_SHOP_FLOOR_STATUS_CODES·Explore WIP module →
-
View: WIP_LINES_VAL_V 12.2.2
Enabled production lines
-
Foreign-key data for WIP_SHOP_FLOOR_STATUSES
APPS.WIP_SHOP_FLOOR_STATUSES_V·↳ BOM_DEPARTMENTS·↳ MFG_LOOKUPS·↳ WIP_OPERATIONS·Explore WIP module →
-
Types of intraoperation steps possible in an organization
-
Instructions attached to operations
APPS.WIP_OPERATION_INSTRUCTIONS_V·↳ FND_ATTACHED_DOCUMENTS·↳ FND_DOCUMENTS_VL·↳ FND_DOCUMENT_CATEGORIES_VL·Explore WIP module →
-
View: WIP_COMMENT_CODES_V 12.2.2
Types of comments that can be attached to WIP entities
APPS.WIP_COMMENT_CODES_V·↳ FND_DOCUMENTS_SHORT_TEXT·↳ FND_DOCUMENTS_VL·↳ FND_DOCUMENT_CATEGORIES_VL·Explore WIP module →
-
View: WIP_COMMENT_CODES_V 12.1.1
Types of comments that can be attached to WIP entities
APPS.WIP_COMMENT_CODES_V·↳ FND_DOCUMENTS_SHORT_TEXT·↳ FND_DOCUMENTS_VL·↳ FND_DOCUMENT_CATEGORIES_VL·Explore WIP module →
-
View: WIP_REPETITIVE_ITEMS_V 12.2.2
Foreign-key data for WIP_REPETITIVE_ITEMS
APPS.WIP_REPETITIVE_ITEMS_V·↳ MFG_LOOKUPS·↳ MTL_SECONDARY_INVENTORIES·↳ WIP_LINES·Explore WIP module →
-
View: WIP_REPETITIVE_ITEMS_V 12.1.1
Foreign-key data for WIP_REPETITIVE_ITEMS
APPS.WIP_REPETITIVE_ITEMS_V·↳ MFG_LOOKUPS·↳ MTL_SECONDARY_INVENTORIES·↳ WIP_LINES·Explore WIP module →
-
Types of intraoperation steps possible in an organization
-
View: WIP_OPERATIONS_INQ_V 12.1.1
In-queue quantities for operations
APPS.WIP_OPERATIONS_INQ_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore WIP module →
-
View: WIP_OPERATIONS_INQ_V 12.2.2
In-queue quantities for operations
APPS.WIP_OPERATIONS_INQ_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore WIP module →
-
Statuses that a job or schedule may assume
-
View: WIP_ENTITY_COMMENTS_V 12.1.1
Attachments to WIP entities
APPS.WIP_ENTITY_COMMENTS_V·↳ FND_ATTACHED_DOCUMENTS·↳ FND_DOCUMENTS_VL·↳ FND_DOCUMENT_CATEGORIES_VL·Explore WIP module →
-
View: WIP_ENTITY_COMMENTS_V 12.2.2
Attachments to WIP entities
APPS.WIP_ENTITY_COMMENTS_V·↳ FND_ATTACHED_DOCUMENTS·↳ FND_DOCUMENTS_VL·↳ FND_DOCUMENT_CATEGORIES_VL·Explore WIP module →
-
Operation dependency
-
View for Work Request information
APPS.WIP_EAM_WORK_REQUESTS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_ORG_MAINT_DEFAULTS·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 →
-
Operation dependency
-
Instructions attached to operations
APPS.WIP_OPERATION_INSTRUCTIONS_V·↳ FND_ATTACHED_DOCUMENTS·↳ FND_DOCUMENTS_VL·↳ FND_DOCUMENT_CATEGORIES_VL·Explore WIP module →
-
Discrete job schedule groups
-
Table: WIP_EXCEPTIONS 12.1.1
Wip exceptions
-
View: WIP_OPERATIONS_V 12.1.1
Foreign-key data for WIP_OPERATIONS
APPS.WIP_OPERATIONS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore WIP module →
-
Statuses that a job or schedule may assume
-
Default accounting classes
-
Employee hourly labor rates
-
Default accounting classes
-
Statuses assigned to particular jobs and schedules
-
Employee hourly labor rates
-
View for Work Request information
APPS.WIP_EAM_WORK_REQUESTS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_ORG_MAINT_DEFAULTS·Explore WIP module →
-
Statuses assigned to particular jobs and schedules
-
Production lines
-
Discrete job schedule groups
-
Foreign-key data for WIP_OPERATION_RESOURCES
APPS.WIP_SUB_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →
-
Table for storing description based direct items.
-
Foreign-key data WIP_MOVE_TXN_INTERFACE
APPS.WIP_MOVE_TXN_INTERFACE_V·↳ MFG_LOOKUPS·↳ WIP_MOVE_TXN_INTERFACE·Explore WIP module →
-
Foreign-key data WIP_MOVE_TXN_INTERFACE
APPS.WIP_MOVE_TXN_INTERFACE_V·↳ MFG_LOOKUPS·↳ WIP_MOVE_TXN_INTERFACE·Explore WIP module →
-
Line/assembly associations
-
Table: WIP_EXCEPTIONS 12.2.2
Wip exceptions
-
Foreign-key data for WIP_MOVE_TRANSACTIONS
APPS.WIP_MOVE_TRANSACTIONS_V·↳ BOM_DEPARTMENTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·Explore WIP module →
-
View: WIP_FLOW_SCHEDULES_V 12.1.1
Foreign-key data for WIP_FLOW_SCHEDULES
APPS.WIP_FLOW_SCHEDULES_V·↳ MTL_SECONDARY_INVENTORIES·↳ MTL_SYSTEM_ITEMS_KFV·↳ OE_ORDER_LINES_ALL·Explore WIP module →
-
View: WIP_OPERATIONS_V 12.2.2
Foreign-key data for WIP_OPERATIONS
APPS.WIP_OPERATIONS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore WIP module →
-
View: WIP_TRANSACTIONS_V 12.1.1
Foreign-key data for WIP_TRANSACTIONS
APPS.WIP_TRANSACTIONS_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →
-
View: WIP_FLOW_SCHEDULES_V 12.2.2
Foreign-key data for WIP_FLOW_SCHEDULES
APPS.WIP_FLOW_SCHEDULES_V·↳ MTL_SECONDARY_INVENTORIES·↳ MTL_SYSTEM_ITEMS_KFV·↳ OE_ORDER_LINES_ALL·Explore WIP module →
-
Foreign-key data for WIP_MOVE_TRANSACTIONS
APPS.WIP_MOVE_TRANSACTIONS_V·↳ BOM_DEPARTMENTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·Explore WIP module →
-
View: WIP_DISCRETE_JOBS_V 12.1.1
Foreign-key data for WIP_DISCRETE_JOBS
APPS.WIP_DISCRETE_JOBS_V·↳ MFG_LOOKUPS·↳ MTL_KANBAN_CARDS·↳ MTL_SECONDARY_INVENTORIES·Explore WIP module →
-
Foreign-key data for WIP_OPERATION_RESOURCES
APPS.WIP_SUB_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →
-
Foreign-key data for WIP_OPERATION_RESOURCES
APPS.WIP_OPERATION_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore WIP module →