959: THEN
960:
961: SELECT SUM(moqd.transaction_quantity)
962: INTO l_moq_qty1
963: FROM mtl_onhand_quantities_detail moqd
964: WHERE moqd.organization_id = p_org_id
965: AND moqd.inventory_item_id = p_item_id
966: AND EXISTS (select 'x' from mtl_secondary_inventories msi
967: WHERE msi.organization_id = moqd.organization_id and
1013: THEN
1014:
1015: SELECT SUM(moqd.transaction_quantity)
1016: INTO l_moq_qty1
1017: FROM mtl_onhand_quantities_detail moqd
1018: WHERE moqd.organization_id = p_org_id
1019: AND moqd.inventory_item_id = p_item_id
1020: --AND moqd.planning_tp_type = 2
1021: AND moqd.subinventory_code = p_subinv;