What are the database tables for Purchasing Categories ?

Hello,

We are setting up purchasing categories on Oracle R12.1.3

As you know there are 3 stages in setting up purchasing categories.

I am looking for SQL queries for each stage.

Please suggest database table for each stage.

1^st Step – setting up the Segment 1  and Segment 2>>> Setup> Flex fields> Key> Value.   ---- What is the database table to verify and reconcile from backend ?

Step 2-  Setting up Segment 1.segment 2(joining both segments together)

• Under the Purchasing Super User responsibility.

• Then select SETUP> ITEMS > CATEGORIES > CATEGORY CODES      -------------  What is the database table to verify and reconcile from backend ?

Step 3- Setting up Category sets so that they appear in iProcurement