Search Results entry_status_code

Overview

MTL_CYCLE_COUNT_ENTRIES_ALL_V is an Oracle EBS Inventory (INV) view owned by the APPS schema. Its ETRM description is listed simply as "10SC ONLY," indicating it is a specialized object associated with the 10SC (Warehouse Management) solution rather than a general-purpose Inventory reporting view. The view exposes the full column set of the cycle count entry entity, including the fields that drive cycle count scheduling, quantity capture, adjustment, and approval. Because it presents a flattened, read-only projection of the underlying cycle count entry data, it is typically used by concurrent programs, Oracle Warehouse Management (WMS) transactions, and custom extensions that need to reference cycle count entries without writing directly to the base table.

The view is most notable for exposing ENTRY_STATUS_CODE, the column most frequently referenced when developers and analysts search for cycle count entry state. That column reflects the lifecycle state of an individual entry (for example, pending count, counted, approved, or rejected), and is central to any query that filters entries by their processing status.

Underlying Base Objects

Per the documented ETRM 12.2.2 view metadata, the view is defined over the following base object:

• MTL_CYCLE_COUNT_ENTRIES (accessed through its APPS synonym)

MTL_CYCLE_COUNT_ENTRIES is the transactional table that stores one row per cycle count entry, keyed by CYCLE_COUNT_ENTRY_ID and linked to MTL_CYCLE_COUNT_HEADERS through CYCLE_COUNT_HEADER_ID. The "_ALL_V" naming convention in EBS normally signals a view that is not restricted to a single organization, so consumers should apply an ORGANIZATION_ID filter explicitly when they intend to work within one inventory organization. The view does not add joins or derivations beyond the projection of the base table columns, so its behavior mirrors the base table for the fields it exposes.

Key Columns

• ENTRY_STATUS_CODE — Status of the cycle count entry; the primary filter column for identifying entries awaiting count, adjustment, or approval.
• CYCLE_COUNT_ENTRY_ID — Surrogate primary key of the entry; used in joins back to the base table or to downstream adjustment records.
• CYCLE_COUNT_HEADER_ID — Foreign key to MTL_CYCLE_COUNT_HEADERS, linking entries to their parent cycle count.
• ORGANIZATION_ID — Inventory organization that owns the entry; essential for multi-org filtering.
• INVENTORY_ITEM_ID, SUBINVENTORY, LOCATOR_ID — Identify the item and physical location being counted.
• REVISION, LOT_NUMBER, SERIAL_NUMBER, LOT_CONTROL, SERIAL_DETAIL — Support lot- and serial-controlled items, including parent and outermost LPN identifiers (PARENT_LPN_ID, OUTERMOST_LPN_ID).
• COUNT_QUANTITY_FIRST / _CURRENT / _PRIOR and SYSTEM_QUANTITY_FIRST / _CURRENT / _PRIOR — Historical and current captured quantities versus system on-hand quantities.
• COUNT_DATE_* and COUNTED_BY_EMPLOYEE_ID_* — Count dates and counters, tracked across the same first/current/prior pattern.
• COUNT_DUE_DATE, NUMBER_OF_COUNTS, COUNT_TYPE_CODE — Scheduling and cycle count class attributes.
• ADJUSTMENT_QUANTITY, ADJUSTMENT_DATE, ADJUSTMENT_AMOUNT, NEG_ADJUSTMENT_QUANTITY, NEG_ADJUSTMENT_AMOUNT, ITEM_UNIT_COST, INVENTORY_ADJUSTMENT_ACCOUNT — Adjustment and valuation data applied after approval.
• APPROVAL_DATE, APPROVER_EMPLOYEE_ID, APPROVAL_CONDITION, APPROVAL_TYPE, TRANSACTION_REASON_ID — Approval workflow attributes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns for customer-specific extensions.
• Standard who columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on status-driven reporting. Because ENTRY_STATUS_CODE is exposed directly, the view is well suited to pending-count dashboards and approval queues.

SELECT cce.cycle_count_entry_id,
       cce.organization_id,
       cce.inventory_item_id,
       cce.subinventory,
       cce.entry_status_code,
       cce.count_due_date,
       cce.count_quantity_current,
       cce.system_quantity_current
FROM   apps.mtl_cycle_count_entries_all_v cce
WHERE  cce.organization_id = :org_id
AND    cce.entry_status_code = :status
ORDER BY cce.count_due_date;

Adjustment reconciliation queries join the view to MTL_CYCLE_COUNT_HEADERS and use ADJUSTMENT_QUANTITY and ADJUSTMENT_AMOUNT to compare approved adjustments against system quantities. Extensions that must resolve the state of a specific entry typically join on CYCLE_COUNT_ENTRY_ID and CYCLE_COUNT_HEADER_ID. In all cases, the view should be treated as read-only, and organization-level filtering should be applied explicitly since the "_ALL_V" view is not inherently scoped to a single organization. Because the object is documented as "10SC ONLY," implementers should confirm availability in their specific EBS 12.1.1 or 12.2.2 instance before relying on it.