You can find and view all quality results associated with a collection plan. You can also find and view specific quality results associated with a collection plan using Query Find and Query-by-Example. You can also view detailed information - the target value and specification limits, if any - for specific quality results values.

You can view collection plan attachments, which are illustrative or explanatory files, as you view quality results.

You can optionally export results after viewing them.

   To select all quality results for a collection plan:

1. Navigate to the View Quality Results folder window. See: Customizing the Presentation of Data.

2. Select a Collection Plan.

   If a default collection plan has been specified, it is automatically selected. See: QA:Default Collection Plan.

   You can choose the Find Plan button or the standard list of values to find and select a collection plan. After selecting a collection plan, you can use the previous plan/next plan arrow buttons, located to the right of the collection plan name, to scroll to another valid collection plan.

   Once a collection plan is selected, the results associated with that collection plan are automatically displayed in date order. The Prompts entered when defining the collection elements are displayed as the column headings.

   You can view the following three common collection plan elements here (See: Collection Elements in Collection Plans):

   • Created By

   • Collection (Collection Number)

   • Entry Date

     To view the remaining common collection plan elements, select Help, then Record History from the menu.

   To find specific quality results:

Position the cursor in any field in the Results region and choose Find from the Query menu. The Find Results window appears. See: Finding Quality Results.

   To find specific quality results using query-by-example:

Position the cursor in any field in the Results region and choose Enter from the Query menu. See: Searching for Data.

   To view quality result details:

See: Viewing Quality Results Details.

   To enter, update, or view related child plan results:

See: Entering, Updating, or Viewing Related Child Quality Results.

   To export quality results:

See: Exporting Quality Results.

   To view collection plan attachments while viewing quality results:

See: Viewing Attachments Associated with Quality Results.

   To view item descriptions along with items while viewing quality results:

1. Create a collection element for the item description. See: Defining Collection Elements.

   Caution: You cannot name this collection element Item Description. The name Item Description is used for a pseudo common collection plan element (See: Collection Elements in Collection Plans.). You can use this pseudo element in charts and graphs, but you cannot include it in a collection plan. You can use similar names, such as Description or Item Desc when creating an actual collection element for item description.

2. Create a collection plan that includes at least your item description collection element and the Item collection element. See: Creating Collection Plans.

3. Define an Assign a Value action for the Item collection plan element that assigns a value to the item description collection plan element once the item is entered. See: Defining Assign A Value Actions: User-Defined Formulas. Use the following SQL script:

   select description

   from mtl_system_items_kfv

   where concatenated_segments = &ITEM and organization_id = :parameter.org_id

4. Choose the Variables button to associate the token &ITEM with the Item collection plan element.