351: SUM(NVL(mtln.secondary_transaction_quantity,0)) sec_qty
352: FROM
353: mtl_transaction_lot_numbers mtln,
354: mtl_material_transactions mmt,
355: MTL_SECONDARY_INVENTORIES sinv /*B8404849*/
356: WHERE
357: mmt.transaction_id = mtln.transaction_id AND
358: mmt.organization_id = p_organization_id AND
359: mmt.transaction_date > p_rollback_to_date AND
387: SUM(NVL(mmt.secondary_transaction_quantity,0)) sec_qty
388: FROM
389: mtl_system_items_b msi,
390: mtl_material_transactions mmt,
391: MTL_SECONDARY_INVENTORIES sinv /*B8404849*/
392: WHERE
393: mmt.inventory_item_id = msi.inventory_item_id AND
394: mmt.organization_id = msi.organization_id AND
395: msi.lot_control_code = 1 AND /* no lot control */