Thursday, May 30, 2019

Query to Find On Hand Quantity in Oracle Apps R12

SELECT  segment1,
  it.inventory_item_id,
  it.organization_id,
  transaction_quantity,
  internal_ORDER_FLAG
FROM mtl_system_items_b it,--MATERIAL TABLE
            mtl_onhand_quantities onhand -- ONHAND QTY TABLE
WHERE it.inventory_item_id  = onhand.inventory_item_id
AND it.organization_id      = onhand.organization_id
AND it.organization_id      = 4
AND IT.INVENTORY_ITEM_ID= 28934
;

OUTPUT :
SEGMENT1            ITEM_ID     ORG_ID    TRANSACTION QTY    INTERNAL_ORDER_FLAG
M0800RCSM004 28934            4                     42                                   Y
M0800RCSM004 28934            4                     90                                   Y

No comments:

Post a Comment