DBA Data[Home] [Help]

APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on MTL_MATERIAL_TRANSACTIONS

Line 284: mtl_material_transactions mmt

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)
288: AND msn.inventory_item_id = wdd.inventory_item_id+0

Line 355: mtl_material_transactions mmt

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
359: AND mtln.organization_id = mut.organization_id

Line 428: mtl_material_transactions mmt

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
432: AND wsn.to_serial_number