Oracle R12 – How to query or view Item

Posted on by

Viewing Item Attributes

Overview

In this practice, you will learn how to view item attributes.

Viewing Item Attributes

1.    Find item # AS20000 and answer the following questions:

  • Is a BOM allowed for this item? _____ What is the control level? ______
  • Is this item Recipe Enabled? _____ What is the control level? ____

2.    Find item # AS54888 and answer the following questions about the item’s attributes.

  • What is the Item Status? _______________ What is the control level? ______
  • Is a Bill of Material allowed for this item? ______ What is the control level? ______
  • Are customer orders enabled for this item? _________What is the control level? _____
  • Is Invoicing Enabled for this item? ______________ What is the control level? _____
  • Is this item transactable in Inventory? ____________ What is the control level? ______
  • Is this item stockable in Inventory? _______________ What is the control level? _____

Solution – Viewing Item Attributes

Viewing Item Attributes

Responsibility = Inventory, Vision Operations USA

1.    Navigate to the Master Item window.

  • (N) Items > Master Items

2.    Query Item # AS20000.

  • (M) View > Query by Example > Enter
    • Enter AS20000% in the Item field.
  • (M) View > Query by Example > Run


3.    (T) Bills of Material

A BOM is allowed for item AS20000. This attribute is controlled at the master level.


4.    (T) Process Manufacturing

Item AS20000 is recipe enabled. This attribute is controlled at the organization level.


5.    Find Item AS54888.

  • (M) View > Find


  • Click Find.

6.    (T) Main

The item status for item AS5488 is active and master controlled.


7.    (T) Bills of Material

A Bill of Material is allowed for this item and the attribute is master controlled.

8.    (T) Order Management

Customer orders are enabled for this item and the attribute is master controlled.


9.    (T) Invoicing

Invoicing is enabled for this item and the attribute is master controlled.


10.    (T) Inventory

This item is transactable and stockable. These attributes are master controlled.


11.    In how many Organizations can this part be used?