Search Results implmentation_date

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EGO_MFG_PART_NUM_CHGS is a table in the EGO schema belonging to the Advanced Product Catalog (APC) module of Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. Its stated purpose is to store pending and history data for Approved Manufacturers, meaning it records the change-oriented state of manufacturer part numbers as they are submitted, reviewed, approved, or superseded against inventory items within an organization. In practice, this table functions as the transactional audit trail that sits behind the Approved Manufacturer List (AML) and manufacturer part number maintenance flows surfaced in APC.

Based on the heuristic Data Vault classification mined from its foreign key structure, the table is described as standalone. As a modeling suggestion, this implies the object does not participate as a clean hub, link, or satellite in a normalized vault pattern; rather, it behaves as a self-contained change/audit record keyed by a composite business key plus lifecycle metadata. Analysts should treat it as a history-bearing satellite-like structure rather than a source of master identity.

Key Information Stored

The documented physical schema contains 39 columns. Among the most significant are the following.

• MANUFACTURER_ID — identifies the manufacturer; this is the sole documented foreign key, referencing MTL_MANUFACTURERS.
• MFG_PART_NUM — the manufacturer part number being tracked or changed.
• INVENTORY_ITEM_ID — the inventory item to which the manufacturer part number is associated.
• ORGANIZATION_ID — the inventory organization context for the change.
• CHANGE_ID and CHANGE_LINE_ID — the change order header and line driving the modification, providing the audit linkage.
• ACD_TYPE — the approved change disposition type distinguishing the nature of the change record.
• APPROVAL_STATUS and FIRST_ARTICLE_STATUS — lifecycle state indicators for the approval and first-article workflow.
• IMPLMENTATION_DATE — effective implementation date of the change (note the documented spelling).
• START_DATE and END_DATE — date-range validity for the manufacturer part number.
• MRP_PLANNING_CODE and DESCRIPTION — planning behavior and descriptive text.

The unique index EGO_MFG_PART_NUM_CHGS_U1 (ORGANIZATION_ID, MANUFACTURER_ID, MFG_PART_NUM, INVENTORY_ITEM_ID, CHANGE_LINE_ID, ACD_TYPE) is the documented business-key candidate. No separate single-column surrogate primary key is documented; the composite unique index effectively serves that role. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the REQUEST_ID / PROGRAM_APPLICATION_ID / PROGRAM_ID / PROGRAM_UPDATE_DATE set support concurrent-program traceability.

Common Use Cases and Queries

Typical scenarios include tracing which change order modified an approved manufacturer part number, reporting pending versus approved AML changes, and reconciling first-article statuses. A representative query joins the table to MTL_MANUFACTURERS and filters by organization and approval state:

• SELECT c.MFG_PART_NUM, m.MANUFACTURER_NAME, c.APPROVAL_STATUS, c.IMPLMENTATION_DATE FROM EGO_MFG_PART_NUM_CHGS c, MTL_MANUFACTURERS m WHERE c.MANUFACTURER_ID = m.MANUFACTURER_ID AND c.ORGANIZATION_ID = :org_id
• Audit reporting: filter on CHANGE_ID or CHANGE_LINE_ID to reconstruct the full history of a change order line.
• Validity reporting: compare START_DATE and END_DATE against the current date to isolate active versus expired manufacturer part numbers.

Related Objects

• MTL_MANUFACTURERS — referenced via MANUFACTURER_ID; the primary join for manufacturer identity.
• EGO_ITEM_REVISIONS and other EGO item-definition tables — provide the item context for INVENTORY_ITEM_ID.
• MTL_SYSTEM_ITEMS_B — resolves INVENTORY_ITEM_ID to item attributes and description.
• Change order tables in the EGO/ENG schema — resolve CHANGE_ID and CHANGE_LINE_ID.
• APC AML/AMR views — surface the approved manufacturer relationships derived from these change records.