4940: AND msi.last_update_date >= l_from_date
4941: AND msi.last_update_date <= l_to_date
4942: UNION
4943: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
4944: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik
4945: WHERE mcr.inventory_item_id = cic.inventory_item_id
4946: AND mcr.organization_id = cic.organization_id
4947: AND mcr.organization_id = mp.organization_id
4948: AND msik.organization_id = cic.organization_id
4974: AND msi.last_update_date <> msi.creation_date
4975: AND msi.last_update_date >= l_from_date AND msi.last_update_date <= l_to_date
4976: UNION
4977: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
4978: FROM cst_item_costs cic, mtl_parameters mp, mtl_system_items_kfv msik
4979: WHERE cic.organization_id = mp.organization_id
4980: AND msik.organization_id = cic.organization_id
4981: AND msik.inventory_item_id = cic.inventory_item_id
4982: AND cic.last_update_date <> cic.creation_date