Search Results system_defined_flag

Overview

XNC_QUOTE_PARAMS_V is a database view belonging to the XNC - Sales for Communications product family within Oracle E-Business Suite. As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, this view retrieves parameter definition information for an item on a quote line. It is part of the quoting infrastructure that supported telecommunications and communications-oriented selling processes in EBS.

The product designation is significant: XNC - Sales for Communications carries the descriptor "Obsolete." The metadata further states under Implementation/DBA Data that the view is "Not implemented in this database." Consequently, XNC_QUOTE_PARAMS_V should be treated as a legacy or reference-only object. It is not a supported integration surface in current 12.1.1 or 12.2.2 installations, and any report or extension depending on it will fail unless the object was manually created in the environment. The "system_defined_flag" search term that drew attention to this view maps directly to the SYSTEM_DEFINED_FLAG column exposed in the SELECT list, which distinguishes parameters seeded by Oracle from those defined by users.

Underlying Base Objects

The ETRM view metadata lists no documented base objects, but the embedded view text reveals the actual join structure. The view is built over five principal sources:

• ASO_QUOTE_LINES_ALL (aliased AQL) — the quote line header-level table, supplying QUOTE_HEADER_ID and QUOTE_LINE_ID.
• ASO_QUOTE_LINE_ATTRIBS_EXT (aliased AQLAE) — the descriptive flexfield-style attribute extension table holding the actual parameter value, line attribute identifier, value type, attribute type code, status, application, and quote shipment.
• XNC_ITEM_ACTION_PARS_V (aliased XIAP) — the parameter definition view supplying parameter name, meaning, description, source attributes, item/action context, and flags including SYSTEM_DEFINED_FLAG.
• FND_LOOKUP_VALUES_VL (aliased LKPE, LKPC, LKPD) — three lookup joins resolving source type meanings for enumerated, customer, and API sources.

The join between ASO_QUOTE_LINES_ALL and XNC_ITEM_ACTION_PARS_V is driven by matching INVENTORY_ITEM_ID and ORGANIZATION_ID, restricted to synchronous actions with a display flag of 'B' or 'C' and an effective date window. The attribute extension joins on QUOTE_LINE_ID and matches parameter name against the attribute name.

Key Columns

• ROW_ID — the row identifier of the attribute extension record, nulled when no attribute row exists.
• LINE_ATTRIBUTE_ID, VALUE, VALUE_TYPE — the stored parameter value and its data typing on the quote line.
• PARAMETER_NAME, PARAMETER_MEANING, PARAMETER_DESCRIPTION — the parameter definition metadata.
• SOURCE, SOURCE_TYPE_CODE, SOURCE_NAME — where the parameter value originates, decoded through the FND lookup values.
• SYSTEM_DEFINED_FLAG — the flag of primary interest to the searcher; identifies Oracle-seeded parameters versus customer-defined ones.
• MANDATORY_FLAG, SUBSCRIPTION_FLAG, DISPLAY_FLAG, SYNCHRONOUS_ACTION_FLAG — behavioral controls governing whether and how the parameter is presented or required.
• DEFAULT_VALUE, SEQUENCE, DISPLAY_MEANING — defaulting and ordering information for presentation.
• QUOTE_HEADER_ID, QUOTE_LINE_ID — the quote context linking the parameter to its parent line and header.

Common Use Cases and Queries

Where the view exists (typically in legacy or test environments), it supports reporting on parameter configuration for configurable communications items on quotes. A typical query filters system-defined parameters:

SELECT quote_line_id, parameter_name, value, system_defined_flag
FROM xnc_quote_params_v
WHERE system_defined_flag = 'Y';

Consultants also use it to validate that mandatory or displayed parameters are correctly surfaced for given items and organizations, and to audit the source of parameter values via the SOURCE column. Given the object's obsolete status, any such query should be treated as diagnostic rather than production-grade.