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!

mtl_secondary_inventories

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

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi All,

    I want to know the use of mtl_secondary_inventories table,
    as sub inventories are repeating again and agin there.



    Regards
    Sambhaji
     
  2. sambuduk

    sambuduk Forum Advisor

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

    Organization_id (Inventory Organization ) will be different for those sub inventories.


    Regards,
    Sambasiva Reddy.K
     
  3. Bharat

    Bharat Community Moderator Forum Guru

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

    Yes, records will duplicated if you have the same secondary inventory in different organizations. If you want to query only 1 record for each secondary inventory, then you can query with Organization id specific.
     
  4. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    HI ,
    Thanks, actully i want some query in which reservable type in mtl_secondary_inventories comes so what is this column?

    Thanks & regards
    Sambhaji
     
  5. Bharat

    Bharat Community Moderator Forum Guru

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

    We can use RESERVABLE_TYPE field in mtl_secondary_inventories table for reservable type.
     
  6. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi Bharat,

    There are two reservable types 1 and 2.

    So, What is this '1' and '2' represents ??


    Regards
    Sambhaji
     
  7. Bharat

    Bharat Community Moderator Forum Guru

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

    1 --> It Allow's Reservation (If it's 1 then Allow Reservation field is checked)
    2 --> It won't Allow Reservation (If it's 2 then Allow Reservation field is un-checked)
     
    sambuduk likes this.
  8. sambhaji

    sambhaji Active Member

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

    Regards
    Sambhaji
     
  9. sambuduk

    sambuduk Forum Advisor

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

    If you observe in the subinventory window Allow Reservations check box will be there.

    1 means Allow reservations check box checked. 2 means unchecked. ( check the attached image)


    Regards
    Sambasiva Reddy.K
     

    Attached Files:

    Bharat likes this.
  10. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi Sambasiva,

    Thanks.

    Regards
    Sambhaji