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!

Inventory item (Contract Item Type field) identification

Discussion in 'Oracle SCM & Manufacturing' started by Bharat, Aug 11, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    Can anyone tell me in which table Contract Item Type field data resides. Just like if we are having service items then we can see Service in that field. So in which table we can identify this field data. Please find the attached file to know what the field exactly Iam pointing out.
     

    Attached Files:

  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Setup:Service Contracts:Lookup: The values are defined here. Where this value is stored for each Line Item can be found by querying all fields for a single item.(Its like an attribute and I believe it is cross referenced).

    Pls find the attached...
    cheers
    Ramji
     

    Attached Files:

  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Thanks alot bhayya. That solves my problem.
     
  4. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Please share your findings too.
    cheers
    Ramji
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    The below document contains Inventory form query for few important fields. In this I have used fnd_lookups for getting contract item type which is in service tab. For this lookup_type used is OKB_CONTRACT_ITEM_TYPE. By this I got that field exactly.

    Inventory Form Query
     
    Ramji likes this.