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!

Oracle Apps Query to get actual item cost, unit selling price and shipping charges

Discussion in 'General' started by Redro, Sep 19, 2011.

  1. Redro

    Redro Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    75
    Hi All,

    Can any one drop a query to get actual item cost, unit selling price and shipping charges. Assuming that the item cost is item_cost_per_unit from mtl_system_itesm table but when we booked an order the cost is differ. What is this difference?
    Thanks
    JP
     
  2. saurovroy

    saurovroy Active Member

    Messages:
    8
    Likes Received:
    2
    Trophy Points:
    85
    Re: Oracle Apps Query to get actual item cost, unit selling price and shipping charge

    While a sales order is booked, the price that comes is from the price list which is mentioned while creating the so .This price may be different from the standard cost of the item.

    Regards,
    SR