273: to_number(null) DELIVERY_ID,
274: to_number(null) GENEALOGY_OBJECT_ID
275: FROM mtl_transaction_lot_numbers mtln ,
276: mtl_serial_numbers msn ,
277: mtl_system_items_vl msi ,
278: wip_entities we ,
279: org_organization_definitions ood ,
280: wsh_delivery_details wdd ,
281: mtl_object_genealogy mog1 ,
348: mtl_unit_transactions mut ,
349: mtl_serial_numbers_temp msnt ,
350: wip_entities we ,
351: org_organization_definitions ood ,
352: mtl_system_items_vl msi ,
353: wsh_delivery_details wdd ,
354: mtl_lot_numbers mln ,
355: mtl_material_transactions mmt
356: WHERE wdd.delivery_detail_id = r_delivery_detail_id
421: mtl_unit_transactions mut ,
422: mtl_transaction_lot_numbers mtln ,
423: org_organization_definitions ood ,
424: wip_entities we ,
425: mtl_system_items_vl msi ,
426: mtl_lot_numbers mln ,
427: wsh_delivery_details wdd ,
428: mtl_material_transactions mmt
429: WHERE wsn.delivery_detail_id = r_delivery_detail_id