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 MTL_LOT_NUMBERS

Line 283: mtl_lot_numbers mln ,

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
285: WHERE wdd.delivery_detail_id = r_delivery_detail_id
286: AND wdd.organization_id = r_organization_id
287: AND msn.serial_number = NVL(wdd.serial_number,NULL)

Line 354: mtl_lot_numbers mln ,

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
358: AND mtln.organization_id = r_organization_id

Line 426: mtl_lot_numbers mln ,

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
430: AND wdd.delivery_detail_id = wsn.delivery_detail_id+0