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_UNIT_TRANSACTIONS

Line 189: mtl_unit_transactions mut1 ,

185: NULL parent_serial_number ,
186: 0 parent_inventory_item_id
187: FROM mtl_material_transactions mmt1 ,
188: mtl_transaction_lot_numbers mtln1 ,
189: mtl_unit_transactions mut1 ,
190: mtl_material_transactions mmt ,
191: mtl_transaction_lot_numbers mtln ,
192: mtl_unit_transactions mut ,
193: wip_entities we ,

Line 192: mtl_unit_transactions mut ,

188: mtl_transaction_lot_numbers mtln1 ,
189: mtl_unit_transactions mut1 ,
190: mtl_material_transactions mmt ,
191: mtl_transaction_lot_numbers mtln ,
192: mtl_unit_transactions mut ,
193: wip_entities we ,
194: mtl_system_items_vl msi ,
195: org_organization_definitions ood ,
196: mtl_lot_numbers mln

Line 233: mtl_unit_transactions mut ,

229: mut.serial_number ,
230: we.wip_entity_name job_name
231: FROM mtl_object_genealogy mog ,
232: mtl_transaction_lot_numbers mtln ,
233: mtl_unit_transactions mut ,
234: mtl_serial_numbers msn ,
235: mtl_material_transactions mmt ,
236: wip_entities we
237: WHERE msn.serial_number = r_serial_number

Line 328: mtl_unit_transactions mut ,

324: wip_entities we ,
325: mtl_system_items_vl msi ,
326: wsh_opsm_asn_item_details_v waid ,
327: mtl_transaction_lot_numbers mtln ,
328: mtl_unit_transactions mut ,
329: mtl_lot_numbers mln ,
330: org_organization_definitions ood
331: WHERE mog.parent_object_id = waid.genealogy_object_id + 0
332: AND mmt.transaction_id = mog.origin_txn_id + 0

Line 2523: mtl_unit_transactions mut1 ,

2519: NULL parent_serial_number ,
2520: 0 parent_inventory_item_id
2521: FROM mtl_material_transactions mmt1 ,
2522: mtl_transaction_lot_numbers mtln1 ,
2523: mtl_unit_transactions mut1 ,
2524: mtl_material_transactions mmt ,
2525: mtl_transaction_lot_numbers mtln ,
2526: mtl_unit_transactions mut ,
2527: wip_entities we ,

Line 2526: mtl_unit_transactions mut ,

2522: mtl_transaction_lot_numbers mtln1 ,
2523: mtl_unit_transactions mut1 ,
2524: mtl_material_transactions mmt ,
2525: mtl_transaction_lot_numbers mtln ,
2526: mtl_unit_transactions mut ,
2527: wip_entities we ,
2528: mtl_system_items_vl msi ,
2529: org_organization_definitions ood ,
2530: mtl_lot_numbers mln

Line 2567: mtl_unit_transactions mut ,

2563: mut.serial_number ,
2564: we.wip_entity_name job_name
2565: FROM mtl_object_genealogy mog ,
2566: mtl_transaction_lot_numbers mtln ,
2567: mtl_unit_transactions mut ,
2568: mtl_serial_numbers msn ,
2569: mtl_material_transactions mmt ,
2570: wip_entities we
2571: WHERE msn.serial_number = r_serial_number

Line 2662: mtl_unit_transactions mut ,

2658: wip_entities we ,
2659: mtl_system_items_vl msi ,
2660: wsh_opsm_asn_item_details_v waid ,
2661: mtl_transaction_lot_numbers mtln ,
2662: mtl_unit_transactions mut ,
2663: mtl_lot_numbers mln ,
2664: org_organization_definitions ood
2665: WHERE mog.parent_object_id = waid.genealogy_object_id + 0
2666: AND mmt.transaction_id = mog.origin_txn_id + 0