Search Results parent_status_code

Overview

ENG_CHANGE_ACTIONS_VL is a multilingual (VL) view owned by the APPS schema in Oracle E-Business Suite, defined within the Engineering (ENG) product module. It presents change action records associated with engineering change management workflows, exposing both transactional attributes held in the base change actions table and the corresponding translated description text. As a VL view, it derives its "_TL" suffix convention from the Oracle multi-language support architecture, returning only the row translation that matches the session's language setting. In releases 12.1.1 and 12.2.2 the object is documented as VALID.

The view serves as a reporting and integration surface for change action data. Application code, concurrent programs, and external interfaces that need a single-row-per-action result set join to ENG_CHANGE_ACTIONS_VL rather than querying the base tables directly, because the view encapsulates the language-join logic and provides a human-readable DESCRIPTION column. The ROW_ID pseudo-column exposes the underlying ROWID of the base change action row, which supports update-through-view and row identification scenarios.

Underlying Base Objects

ETRM metadata documents two referenced base objects, both exposed to APPS as synonyms:

• ENG_CHANGE_ACTIONS — the transactional table holding change action records (aliased ECA in the view definition).
• ENG_CHANGE_ACTIONS_TL — the translation table holding the language-specific description (aliased ECAT).

The view joins the two on ACTION_ID and filters the translation with the condition ECAT.LANGUAGE = USERENV('LANG'), so each ACTION_ID yields exactly one row per session language. All business columns are sourced from ECA; only DESCRIPTION is sourced from ECAT.

Key Columns

The view exposes thirty-two columns. The most significant include:

• ROW_ID / ACTION_ID — the base table ROWID and the primary identifier of the change action.
• ACTION_TYPE, OBJECT_NAME — classify the action and name the object it affects.
• OBJECT_ID1 through OBJECT_ID5 — five generic identifier slots. OBJECT_ID1 is the first of these and, depending on ACTION_TYPE, carries a reference to an affected entity such as an item, change order, or document. Because the columns are generic, interpretation requires context from ACTION_TYPE.
• PARENT_ACTION_ID, PARENT_STATUS_CODE — link an action to its parent within an action hierarchy and expose the parent's status.
• STATUS_CODE, PRIORITY_CODE, ASSIGNEE_ID, RESPONSE_BY_DATE — workflow status, priority, assigned resource, and required response date.
• WORKFLOW_ITEM_TYPE, WORKFLOW_ITEM_KEY — the Oracle Workflow item that drives the action.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — concurrent request context that created or last processed the record.
• DESCRIPTION — the translated description text from ENG_CHANGE_ACTIONS_TL.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical scenarios include reporting open change actions, locating the entity referenced by a generic ID slot, and tracing workflow routing. A basic query listing current-language actions is:

SELECT action_id, action_type, object_name, object_id1, status_code, description FROM apps.eng_change_actions_vl WHERE status_code = 'OPEN';

To resolve an action by its first object identifier — the term the user searched for — filter on OBJECT_ID1:

SELECT action_id, action_type, object_name, object_id1, object_id2 FROM apps.eng_change_actions_vl WHERE object_id1 = :p_object_id;

Because OBJECT_ID1 is generic, the query is most reliable when constrained together with OBJECT_NAME or ACTION_TYPE:

SELECT action_id, object_id1, status_code, assignee_id FROM apps.eng_change_actions_vl WHERE object_id1 = :p_id AND action_type = :p_action_type;

For workflow tracking, join WORKFLOW_ITEM_KEY to the workflow tables, or filter actions by assignee and response date to produce workload reports.