Results for “mtl_cc_entries_interface_v”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_CC_ENTRIES_INTERFACE_V is an APPS-owned database view in the Oracle E-Business Suite Inventory (INV) module, defined as the "Cycle Count Entries Interface View." It presents a denormalized, reporting-friendly projection of cycle count interface records that are staged for validation and upload into the cycle counting process. The view sits over the MTL_CC_ENTRIES_INTERFACE table and enriches each staging row with descriptive attributes drawn from organizational, item, and cycle count header sources. In Oracle EBS 12.1.1 and 12.2.2, the view is marked VALID and is commonly used for diagnostic, reconciliation, and extraction purposes rather than for transactional processing.
For users searching on item_segment1, the view is significant because it exposes the full range of item key flexfield segments (ITEM_SEGMENT1 through ITEM_SEGMENT20) directly on the interface record. This allows interface rows to be identified by concatenated item flexfield values without an additional join to MTL_SYSTEM_ITEMS, which is particularly useful when troubleshooting staged cycle count entries.
Underlying Base Objects
The documented base objects underlying this view are:
- MTL_CC_ENTRIES_INTERFACE (SYNONYM) — the primary driving table containing the staged cycle count entry records.
- MTL_CYCLE_COUNT_HEADERS (SYNONYM) — source of the CYCLE_COUNT_HEADER_NAME.
- MTL_PARAMETERS (SYNONYM) — source of the ORGANIZATION_CODE.
- MTL_SYSTEM_ITEMS (SYNONYM) — source of ITEM_DESCRIPTION and PRIMARY_UOM_CODE.
- HR_ORGANIZATION_UNITS (VIEW) — source of ORGANIZATION_NAME.
- HR_SECURITY (PACKAGE) and HR_GENERAL (PACKAGE) — referenced for organization security and validation logic.
- WMS_LICENSE_PLATE_NUMBERS (SYNONYM) — referenced for license plate (LPN) context where Warehouse Management is installed.
The view is built by selecting from MTL_CC_ENTRIES_INTERFACE (aliased CCEOI) and joining outward to the organization, item, and header objects to supply descriptive columns alongside the raw interface data.
Key Columns
- CC_ENTRY_INTERFACE_ID — unique identifier for the staged interface row; the primary handle for the record.
- ORGANIZATION_ID / ORGANIZATION_CODE / ORGANIZATION_NAME — warehouse identification, combining the numeric ID with the code from MTL_PARAMETERS and the name from HR_ORGANIZATION_UNITS.
- CYCLE_COUNT_HEADER_ID / CYCLE_COUNT_HEADER_NAME — the cycle count definition to which the entry belongs.
- INVENTORY_ITEM_ID / ITEM_SEGMENT1–ITEM_SEGMENT20 — the item identifier and its flexfield segments; ITEM_SEGMENT1 typically carries the primary item number.
- ITEM_DESCRIPTION — description sourced from MTL_SYSTEM_ITEMS.
- REVISION, SUBINVENTORY, LOT_NUMBER, SERIAL_NUMBER — inventory attributes of the counted item.
- LOCATOR_SEGMENT1–20 — locator flexfield segments identifying storage position.
- COUNT_QUANTITY / COUNT_UOM / SYSTEM_QUANTITY / PRIMARY_UOM_QUANTITY — the counted and system quantities used in variance evaluation.
- ACTION_CODE — indicates the operation to be applied to the entry.
- ACCOUNT_SEGMENT1–… — adjustment account flexfield segments.
Common Use Cases and Queries
Typical scenarios include reconciling staged cycle count entries, verifying that correct items and quantities are pending upload, and investigating interface failures prior to running the Cycle Count Interface program.
A common query locating entries by item number uses ITEM_SEGMENT1 directly:
SELECT cc.cc_entry_interface_id,
cc.organization_code,
cc.item_segment1,
cc.item_description,
cc.subinventory,
cc.count_quantity,
cc.system_quantity,
cc.action_code
FROM apps.mtl_cc_entries_interface_v cc
WHERE cc.item_segment1 = :item_number
AND cc.organization_id = :org_id;
To review all pending entries for a specific cycle count, the header name and organization columns provide the grouping context. Because the view surfaces organization security through HR_SECURITY and HR_GENERAL, results naturally respect the operating unit and organization access defined for the querying responsibility.
-
Cycle Count Entries Interface View
APPS.MTL_CC_ENTRIES_INTERFACE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →
-
Cycle Count Entries Interface View
APPS.MTL_CC_ENTRIES_INTERFACE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
SYNONYM: APPS.MTL_PARAMETERS 12.1.1
-
SYNONYM: APPS.MTL_PARAMETERS 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person