DBA Data[Home] [Help]

APPS.INV_TABLE_LOCK_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 30: FROM mtl_onhand_quantities_detail

26: p_locator;
27: if (p_issue_receipt = 0) then
28: -- Receipt 0 Issue 1
29: SELECT count(1) into l_neg_exists
30: FROM mtl_onhand_quantities_detail
31: WHERE organization_id = p_organization_id
32: AND inventory_item_id = p_inventory_item_id
33: AND subinventory_code like p_subinventory
34: AND nvl(lot_number,'@@@') like nvl(p_lot,'@@@')