DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 4081: --bug 3324825 change to mtl_onhand_quantities_detail

4077: --select sum(transaction_quantity)
4078: -- Fix bug 1495104
4079: select nvl(sum(transaction_quantity),0)
4080: into l_onhand_qty
4081: --bug 3324825 change to mtl_onhand_quantities_detail
4082: -- from mtl_onhand_quantities
4083: from mtl_onhand_quantities_detail
4084: where organization_id = p_org_id
4085: and inventory_item_id = l_cmp_primary_item_id

Line 4083: from mtl_onhand_quantities_detail

4079: select nvl(sum(transaction_quantity),0)
4080: into l_onhand_qty
4081: --bug 3324825 change to mtl_onhand_quantities_detail
4082: -- from mtl_onhand_quantities
4083: from mtl_onhand_quantities_detail
4084: where organization_id = p_org_id
4085: and inventory_item_id = l_cmp_primary_item_id
4086: and subinventory_code = l_cmp_subinv
4087: and nvl(locator_id, -1) = nvl(l_cmp_loc_id, nvl(locator_id, -1)) --Fix for bug 1495104