eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on WSH_DELIVERY_DETAILS

Line 280: wsh_delivery_details wdd ,

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 ,
282: mtl_object_genealogy mog2 ,
283: mtl_lot_numbers mln ,
284: mtl_material_transactions mmt

Line 353: wsh_delivery_details wdd ,

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
357: AND mtln.inventory_item_id = mut.inventory_item_id

Line 427: wsh_delivery_details wdd ,

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
430: AND wdd.delivery_detail_id = wsn.delivery_detail_id+0
431: AND mut.serial_number BETWEEN wsn.fm_serial_number

Line 445: FROM wsh_delivery_details

441: AND wdd.inventory_item_id = mut.inventory_item_id+0
442: AND msi.organization_id = mut.organization_id +0
443: AND ood.organization_id = mtln.organization_id
444: AND NOT EXISTS (SELECT 0
445: FROM wsh_delivery_details
446: WHERE delivery_detail_id <> r_delivery_detail_id
447: AND inventory_item_id = msi.inventory_item_id+0
448: AND organization_id = msi.organization_id+0
449: AND serial_number = mut.serial_number)