Search Results date_closed

Overview

The MTL_MFG_GENEALOGY_LOTATTR_V view is a manufacturing genealogy reporting object owned by the APPS schema within the Oracle Inventory (INV) product family. It is a valid, compiled database view in Oracle EBS 12.1.1 and 12.2.2 environments and exposes a unified, read-only recordset describing Process Manufacturing batch activity at the material-detail level. The view is designed primarily to satisfy genealogy and lot-attribute reporting requirements — for example, tracing a batch's input and output materials, quantities planned versus produced, and associated item descriptions — without requiring direct joins across the underlying process manufacturing base tables.

Because it presents a curated set of columns spanning work-in-process entities, batch headers, material details, and item key flexfields, the view is frequently used as a foundation for downstream reports, Oracle Discoverer worksheets, XML Publisher data templates, and custom integration extracts. Its presence in the INV module reflects the overlap between discrete WIP and process manufacturing data models, since it joins WIP_ENTITIES (the discrete work order table) with the GME process batch tables.

Underlying Base Objects

Per the documented ETRM metadata, MTL_MFG_GENEALOGY_LOTATTR_V is defined over four referenced base objects, all exposed as synonyms in the APPS schema:

• WIP_ENTITIES — supplies the work order header information, including the WIP_ENTITY_ID, WIP_ENTITY_NAME, and ORGANIZATION_ID.
• GME_BATCH_HEADER — provides batch scheduling, release, and completion dates used as the planned start, actual start, planned completion, actual completion, and batch close dates.
• GME_MATERIAL_DETAILS — contributes the batch line details, including PLAN_QTY, ACTUAL_QTY, LINE_TYPE, and the inventory item identification.
• MTL_SYSTEM_ITEMS_KFV — the key flexfield view over MTL_SYSTEM_ITEMS, supplying the concatenated item number, item description, and primary unit of measure.

The join conditions tie WIP_ENTITY_ID to the GME material details BATCH_ID and constrain ENTITY_TYPE to 10 (the process manufacturing entity type). An outer join to MTL_SYSTEM_ITEMS_KFV ensures material rows are still returned when no matching item master record exists. Only material lines with LINE_TYPE in (1, 2) are included.

Key Columns

• WIP_ENTITY_ID / WIP_ENTITY_NAME — the unique identifier and displayed name of the work order or batch.
• ORGANIZATION_ID — the inventory organization owning the batch.
• ITEM_NUMBER / ITEM_DESCRIPTION / INVENTORY_ITEM_ID — the concatenated flexfield item identifier, description, and internal ID.
• UOM — the primary unit of measure for the item.
• SCHEDULED_START_DATE / RELEASE_DATE / SCHEDULED_COMPLETION_DATE / DATE_COMPLETED / DATE_CLOSED — the batch lifecycle date stamps.
• START_QUANTITY / QUANTITY_COMPLETED — planned quantity and actual completed quantity.
• QUANTITY_SCRAPPED — this column is present in the view definition but is hard-coded as NULL, meaning scrap quantity is not populated by this view. Users searching for "quantity_scrapped" should note that the value will always be NULL here and must be sourced from an alternative object.
• WORK_ORDER_TYPE — always returns the literal 'PROCESS MANUFACTURING'.

Common Use Cases and Queries

Typical scenarios include batch genealogy tracing, item-level batch reconciliation, and reporting planned-versus-actual batch output. A representative query:

• SELECT wip_entity_name, item_number, start_quantity, quantity_completed FROM mtl_mfg_genealogy_lotattr_v WHERE organization_id = :org_id;

Because QUANTITY_SCRAPPED is hard-coded NULL, scrap reporting must be sourced from an alternative GME or WIP object rather than this view.