Key Tables in Inventory

a) Items
Select * from mtl_system_items_b;

b) Categories
Select * from mtl_categories_b;

c)Template
select * from mtl_item_templates;

d)Onhand
Select * from mtl_onhand_quantities;

e) Transactions
select * from mtl_material_transactions;

f) Material transaction interface
select * from mtl_transactions_interface;

g)Pending transactions
select * from mtl_material_transactions_temp;

h) Item Costs
select * from cst_item_costs;

Key tables in Order Management and Shipping Execution

a) Header
select * from oe_order_headers_all;

b) Lines
select * from oe_order_lines_all;

c) Delivery Details
select * from wsh_delivery_details;

d) Deliveries
select * from wsh_delivery_assignments

Key tables in Purchasing

a) Header
select * from po_headers_all

b) Lines
select * from po_lines_all;

c) Shipment
select * from po_line_locations_all;

d) Distributions
select * from po_distributions_all;

e)Account Expense Rules
select * from PO_RULE_EXPENSE_ACCOUNTS;

select * from PO_RULE_EXPENSE_ACCOUNTS_V;

12.2.4 Subscription contract

Subscription contract been created from OM with mapping it's new attributes in R12.2 

iProcurement Categories in Catalog Schema.

The types of categories in the catalog that define the catalog's hierarchy are:

• Purchasing Item categories: Every item in the catalog must belong to a Purchasing Item category. Purchasing Item categories are recognized by many integrating Oracle Applications in addition to Oracle iProcurement. The association of Purchasing Item categories with catalog items enables a wide range of functionality in Oracle Applications.

• Shopping categories: Used to group similar items for presentation to the iProcurement user. Shopping categories generally have names that are more shopper friendly than Purchasing Item categories, and are displayed prominently in many iProcurement pages to help requesters find what

they are shopping for.

Shopping categories are not mandatory for all items in the catalog, but they are highly recommended for items that are intended for iProcurement requesters. Shopping categories are found at the lowest level of the category hierarchy; therefore a shopping category can never be a parent category to a child category.

• Browsing categories, also known as navigation categories (or master or intermediate level categories), define the category hierarchy. The category hierarchy helps requesters browse for catalog items Browsing categories can be either a parent or child to another category, but cannot contain any items.

Ex: 

Uninstalling Demantra

The Demantra software is not listed in the Control Panel > Add/Remove Programs utility. If you plan to reinstall Demantra, you can overwrite your current install.
You can either use a freeware application that can detect and uninstall the Demantra program, or you can do the following to manually remove Demantra from your system:

1. Make sure that none of the Oracle Demantra software is running, including all background items such as the Analytical Engine.
   
2. Remove Oracle software from the system Path variable so shown below.
   
   • On the Windows Start menu, click Settings > Control Panel > System.
     
   • Click System.
     
   • Select the Advanced tab.
     
   • Click Environment Variables.
     
   • In the System Variables section, click Path and then click Edit.
     
   • Carefully remove any Oracle Demantra additions to this variable, leaving other parts unchanged.
3. Manually delete the Oracle Demantra files from the machine.
   
4. In the registry(regedit.exe), search for the HKEY_CURRENT_USER\Software key for Demantra and delete it.
   
5. Log in to the database as the database administrator and delete the Oracle Demantra database user.
   
6. Delete any Demantra shortcuts from the desktop or program groups.