Results for “attr_def_condition_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OE_DEF_ATTR_CONDNS_V view is an APPS-owned database object within the Oracle E-Business Suite Order Management (ONT) module. It stores and presents the attribute-level defaulting conditions used by the Order Management defaulting engine to determine when and how default values are applied to order attributes. Attribute-level defaulting conditions govern the sequence and rules under which attribute values are derived automatically during order entry, order import, or programmatic order creation.
Because the view resolves internal codes into user-facing labels—specifically exposing the ATTRIBUTE_DISPLAY_NAME (sourced from AK_OBJECT_ATTRIBUTES_VL.ATTRIBUTE_LABEL_LONG), the DATABASE_OBJECT_DISPLAY_NAME, the condition DESCRIPTION and DISPLAY_NAME, and the APPLICATION_DISPLAY_NAME—it is well suited for reporting, diagnostics, and integration scenarios. The user search term "attribute_display_name" maps directly to the ATTRIBUTE_DISPLAY_NAME column, which is the human-readable label for the attribute targeted by each defaulting condition.
Underlying Base Objects
Per the documented ETRM 12.2.2 metadata, the view is defined over three referenced base objects:
- OE_DEF_ATTR_CONDNS (SYNONYM) — the primary source table holding the attribute-level defaulting conditions and their precedence, system flag, enabled flag, and descriptive flexfield (DFF) context columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15).
- OE_DEF_CONDITIONS_VL (VIEW) — supplies the condition
DESCRIPTIONandDISPLAY_NAME. It is joined on bothCONDITION_IDandDATABASE_OBJECT_NAMEto keep conditions aligned with the correct database object. - AK_OBJECT_ATTRIBUTES_VL (VIEW) — the Oracle Application Object Library attribute metadata view, supplying
OBJECT_NAME(asDATABASE_OBJECT_DISPLAY_NAME),ATTRIBUTE_LABEL_LONG(asATTRIBUTE_DISPLAY_NAME), andAPPLICATION_NAME(asAPPLICATION_DISPLAY_NAME).
The joins require that DATABASE_OBJECT_NAME matches across all three sources and that ATTRIBUTE_CODE matches in AK_OBJECT_ATTRIBUTES_VL. The view also returns the base table ROWID, enabling row-based operations against the underlying synonym.
Key Columns
- ATTR_DEF_CONDITION_ID — primary identifier for the defaulting condition record.
- DATABASE_OBJECT_NAME / DATABASE_OBJECT_DISPLAY_NAME — the internal object name and its friendly display name.
- ATTRIBUTE_CODE / ATTRIBUTE_DISPLAY_NAME — the attribute being defaulted and its user-facing label.
- CONDITION_ID, DESCRIPTION, DISPLAY_NAME — the condition identifier and its descriptive text.
- PRECEDENCE — ordering used by the defaulting engine to resolve competing conditions.
- SYSTEM_FLAG and ENABLED_FLAG — indicate seeded/system-defined conditions and whether a condition is active.
- APPLICATION_DISPLAY_NAME — owning application of the attribute metadata.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield context and segments.
- Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Typical uses include auditing which defaulting conditions are enabled, resolving attribute codes to labels for reports, and troubleshooting defaulting precedence during order entry.
- Listing enabled attribute-level defaulting conditions with readable attribute labels.
- Reviewing precedence order for a given database object or attribute.
- Identifying system-seeded versus user-defined conditions.
Sample query:
SELECT attribute_display_name,
condition_id,
description,
precedence,
enabled_flag
FROM oe_def_attr_condns_v
WHERE database_object_name = 'OE_ORDER_LINES_ALL'
AND enabled_flag = 'Y'
ORDER BY precedence;
This returns each active defaulting condition targeting the order lines object, ordered by the precedence the defaulting engine applies.
-
View: OE_DEF_ATTR_CONDNS_V 12.2.2
This view stores the attribute level defaulting conditions.
APPS.OE_DEF_ATTR_CONDNS_V·↳ AK_OBJECT_ATTRIBUTES_VL·↳ OE_DEF_ATTR_CONDNS·↳ OE_DEF_CONDITIONS_VL·Explore ONT module →
-
Associates the defaulting condtion, defined at the entity level , to a specific attribute.
-
Associates the defaulting condtion, defined at the entity level , to a specific attribute.
-
View: OE_DEF_ATTR_RULES_V 12.2.2
APPS.OE_DEF_ATTR_RULES_V·↳ AK_OBJECT_ATTRIBUTES_VL·↳ OE_DEF_ATTR_CONDNS·↳ OE_DEF_ATTR_DEF_RULES·Explore ONT module →
-
View: OE_DEF_ATTR_CONDNS_V 12.1.1
This view stores the attribute level defaulting conditions.
APPS.OE_DEF_ATTR_CONDNS_V·↳ AK_OBJECT_ATTRIBUTES_VL·↳ OE_DEF_ATTR_CONDNS·↳ OE_DEF_CONDITIONS_VL·Explore ONT module →
-
Defaulting rules for an attribute for a defaulting condition.
-
Defaulting rules for an attribute for a defaulting condition.
-
View: OE_DEF_ATTR_RULES_V 12.1.1
APPS.OE_DEF_ATTR_RULES_V·↳ AK_OBJECT_ATTRIBUTES_VL·↳ OE_DEF_ATTR_CONDNS·↳ OE_DEF_ATTR_DEF_RULES·Explore ONT module →
-
This view stores the defaulting rules.
APPS.OE_DEF_ATTR_DEF_RULES_V·↳ AK_OBJECT_ATTRIBUTES_VL·↳ OE_DEF_ATTR_CONDNS·↳ OE_DEF_ATTR_DEF_RULES·Explore ONT module →
-
This view stores the defaulting rules.
APPS.OE_DEF_ATTR_DEF_RULES_V·↳ AK_OBJECT_ATTRIBUTES_VL·↳ OE_DEF_ATTR_CONDNS·↳ OE_DEF_ATTR_DEF_RULES·Explore ONT module →
-
PACKAGE: APPS.DEFRULE_PKG 12.1.1
-
PACKAGE: APPS.DEFRULE_PKG 12.2.2
-
PACKAGE: APPS.DEFCONDN_PKG 12.1.1
-
PACKAGE: APPS.DEFCONDN_PKG 12.2.2