Search Results default_shipping_org

Overview

XNC_PRODUCTS_V is a database view defined in the Oracle E-Business Suite module XNC — Sales for Communications, which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The view exists to display products, specifically presenting a flattened, presentation-ready list of inventory items enriched with descriptive lookup meanings and service coverage information. It is intended to be consumed by reporting and integration logic within the Sales for Communications product family, where product catalogs must be rendered for quoting, ordering, and subscription capture scenarios.

The ETRM metadata records that this view is not implemented in this database, meaning the object is documented for reference but is not deployed or validated in the assessed environment. Because the underlying columns derive from inventory item master data, implementations should always confirm the presence of the view before referencing it in custom code or reports.

Underlying Base Objects

The view text is defined over four objects joined in its first query block and reselected in a UNION ALL branch:

• MTL_SYSTEM_ITEMS_KFV — the key flexfield (concatenated segments) view of the item master, supplying organization, item identifiers, descriptions, units of measure, and the many item-attribute flags including CUSTOMER_ORDER_FLAG.
• MFG_LOOKUPS — filtered to LOOKUP_TYPE = 'BOM_ITEM_TYPE', providing BOM item type code and meaning.
• FND_COMMON_LOOKUPS — filtered to LOOKUP_TYPE = 'ITEM_TYPE', providing item type code and meaning.
• OKS_COVERAGE_TEMPLTS_V — the service coverage template view, outer-joined on COVERAGE_SCHEDULE_ID, supplying the coverage template NAME.

Although the ETRM "referenced base objects" section lists none documented, the view text explicitly establishes these dependencies. The second UNION ALL branch repeats the MTL_SYSTEM_ITEMS_KFV and MFG_LOOKUPS joins while hard-coding empty strings for item type meaning and code.

Key Columns

• ORGANIZATION_ID / INVENTORY_ITEM_ID — the composite key identifying each item within an inventory organization.
• ITEM_NAME — the concatenated flexfield segments, left/right trimmed for presentation.
• ITEM_DESCRIPTION, PRIMARY_UNIT_OF_MEASURE, PRIMARY_UOM_CODE — descriptive and UOM attributes.
• ITEM_TYPE, ITEM_TYPE_MEANING, ITEM_TYPE_CODE — decoded item type from FND_COMMON_LOOKUPS.
• BOM_ITEM_TYPE_CODE, BOM_ITEM_TYPE_MEANING — decoded BOM item type from MFG_LOOKUPS.
• CUSTOMER_ORDER_FLAG and CUSTOMER_ORDER_ENABLED_FLAG — the columns most directly relevant to the user's search term. CUSTOMER_ORDER_FLAG indicates whether the item may be placed on a customer order; CUSTOMER_ORDER_ENABLED_FLAG reflects whether that attribute is enabled for the item.
• COMMS_ACTIVATION_REQD_FLAG, COMMS_NL_TRACKABLE_FLAG, COVERAGE_SCHEDULE_ID, NAME — communications-specific and service coverage attributes.
• Additional order-management flags: INVENTORY_ITEM_FLAG, PURCHASING_ITEM_FLAG, SHIPPABLE_ITEM_FLAG, INVOICEABLE_ITEM_FLAG, SERVICEABLE_PRODUCT_FLAG, RETURNABLE_FLAG, SO_TRANSACTIONS_FLAG, PICK_COMPONENTS_FLAG, ORDERABLE_ON_WEB_FLAG, WEB_STATUS, and others.

Common Use Cases and Queries

Typical consumption centers on identifying orderable products. A query filtering on the searched attribute might read:

• SELECT organization_id, inventory_item_id, item_name, item_description, customer_order_flag FROM xnc_products_v WHERE customer_order_flag = 'Y';
• SELECT item_name, bom_item_type_meaning, coverage_schedule_id FROM xnc_products_v WHERE comms_activation_reqd_flag = 'Y';
• SELECT organization_id, COUNT(*) FROM xnc_products_v GROUP BY organization_id;

Because the view is obsolete and flagged as not implemented, developers should validate its existence against the target database and consider MTL_SYSTEM_ITEMS_B or MTL_SYSTEM_ITEMS_KFV directly for supported item-attribute reporting.