APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 275: FROM mtl_transaction_lot_numbers mtln ,

271: --bug 10357152 - opsmperf - added DELIVERY_DETAIL_ID, DELIVERY_ID, GENEALOGY_OBJECT_ID
272: to_number(null) DELIVERY_DETAIL_ID,
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 ,

Line 347: FROM mtl_transaction_lot_numbers mtln ,

343: --bug 10357152 - opsmperf - added DELIVERY_DETAIL_ID, DELIVERY_ID, GENEALOGY_OBJECT_ID
344: to_number(null) DELIVERY_DETAIL_ID,
345: to_number(null) DELIVERY_ID,
346: to_number(null) GENEALOGY_OBJECT_ID
347: FROM mtl_transaction_lot_numbers mtln ,
348: mtl_unit_transactions mut ,
349: mtl_serial_numbers_temp msnt ,
350: wip_entities we ,
351: org_organization_definitions ood ,

Line 422: mtl_transaction_lot_numbers mtln ,

418: to_number(null) DELIVERY_ID,
419: to_number(null) GENEALOGY_OBJECT_ID
420: FROM wsh_serial_numbers wsn ,
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 ,