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!

item_type_code

Discussion in 'Oracle Apps Technical' started by sambhaji, Oct 29, 2013.

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi All,
    In oe_order_lines_all 'line_type_id ' is there,
    so from where it is getting populate???

    Regards
    Sambhaji
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Try with the below query.

    Code (SQL):
    SELECT name order_line_type
    FROM   oe_transaction_types
    WHERE TRANSACTION_TYPE_CODE = 'LINE'
    AND    transaction_type_id = 1427---<line_type_id>


    Regards,
    Sambasiva Reddy.K
     
    Ecor likes this.
  3. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Thanks,

    Sambhaji