Results for “cancelled_flag”

50+ results




Overview
Explore in AI Chat

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

Overview

The QA_SALES_ORDERS_LOV_V view is an APPS-owned database object within the Oracle E-Business Suite Quality (QA) module. Its designated purpose is to serve as the "Sales Order LOV record group" — that is, the underlying query used to populate a List of Values (LOV) that allows QA users to select a sales order. In Oracle EBS, LOV record groups feed descriptive flexfields, concurrent program parameters, and custom forms, so this view functions as a controlled, pre-filtered projection of sales order data rather than a transactional entity in its own right.

The view addresses a practical integration concern: the Quality module frequently needs to reference sales orders (for example, when linking quality results, collection plans, or specifications to a customer order), but the authoritative order data resides in the Order Management (ONT) schema. The view therefore mediates between QA and ONT by exposing a simplified, LOV-friendly result set drawn from order tables. It is classified as VALID in the ETRM reference metadata for 12.1.1 and 12.2.2.

Underlying Base Objects

The view text joins several documented objects:

The defining query is a UNION ALL. The first branch joins MTL_SALES_ORDERS, OE_ORDER_HEADERS_ALL, QA_CUSTOMERS_LOV_V, OE_TRANSACTION_TYPES_TL, and FND_LANGUAGES, and restricts orders to those with SEGMENT3 equal to the ONT_SOURCE_CODE profile value and ORDER_CATEGORY_CODE in ('MIXED','ORDER'). The second branch returns only MTL_SALES_ORDERS rows where SEGMENT3 differs from the profile value, projecting NULLs for customer name, status flags, and category. This two-branch design ensures that orders without a matching Order Management header are still presented, while populated attributes are supplied where available.

Key Columns

  • ORDER_NUMBER — the order number (MTL_SALES_ORDERS.SEGMENT1); the primary display value in the LOV.
  • SALES_ORDER_ID — the unique identifier from MTL_SALES_ORDERS, used as the LOV return value.
  • ORDER_TYPE — the order type (SEGMENT2), matched against the transaction type name.
  • ORDER_SOURCE — the order source (SEGMENT3); equals ONT_SOURCE_CODE for the populated branch.
  • CUSTOMER_NAME — sold-to customer name, via QA_CUSTOMERS_LOV_V outer join; NULL in the second branch.
  • CANCELLED_FLAG, OPEN_FLAG, BOOKED_FLAG — order header status indicators; useful for excluding cancelled or unbooked orders.
  • ORDER_CATEGORY_CODE — limited to 'MIXED' or 'ORDER' in the primary branch.

Common Use Cases and Queries

Typical usage includes binding the view to a QA form LOV, filtering out cancelled orders, and resolving an order number to its SALES_ORDER_ID. For example:

SELECT order_number, customer_name, order_type, order_source FROM apps.qa_sales_orders_lov_v WHERE NVL(cancelled_flag,'N') = 'N' ORDER BY order_number;

Because the second UNION ALL branch emits NULLs for status and customer, queries relying on those columns should account for such rows. Accessing the view directly requires APPS-level or synonym-granted privileges.