1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

table containing "item_category"

Discussion in 'Oracle SCM & Manufacturing' started by Bijendra, Aug 11, 2010.

  1. Bijendra

    Bijendra Guest

    Hi
    I am tying to fetch the categories of the items in the order tables.
    Please give me the table name or some other related help.
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Can't remember out of the top of my head. I think it's MTL_ITEM_CATEGORIES. But you should check from this

    Code (SQL):
    SELECT * FROM tab WHERE tname LIKE '%MTL%ITEM%CAT%'
     
  3. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    I would like also to share this code: i believe it works in all schema.

    SELECT *
    FROM all_tables
    WHERE table_name LIKE '%MTL%ITEM%CAT%'
     
  4. kumar2020

    kumar2020 Active Member

    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    65
    Item_category col is available in MTL_ITEM_CATEGORIES table

    following code is useful for you

    select * from all_tables
    where tname like '%MTL%ITEM%CAT%'
     
    Sadik likes this.
  5. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Lolz kumar... that's exactly what I had posted! :p