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!

Script for Inventory Balance

Discussion in 'Oracle SCM & Manufacturing' started by excalibur_one, Aug 11, 2011.

  1. Hi all,

    I'm new in Oracle and mi company has implemented Oracle ebs V.12. two months ago.

    Pls, somebody can help me with a query to report for a specific month:

    Code Item, Qty, Average Cost, Total Value (Qty * Average Cost) for all items.

    Thx.
     
  2. saurovroy

    saurovroy Active Member

    Messages:
    8
    Likes Received:
    2
    Trophy Points:
    85
    Hi,
    What kind of costing is your organization using? Is it standard cost or roll up costs?

    item name can be had from mtl_system_items_b (segment1),
    onhand quantity can be fetched from mtl_onhand_quantities (sum of transaction_quantity).
    Depending on the cost that is being used, we can frame a query with the above mentioned data and cst_item_cost_type_v field.

    Regards,
    SR