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_TRANSACTION_LOT_NUMBERS

Line 132: FROM mtl_transaction_lot_numbers mtln ,

128: ,
129: to_number(null) DELIVERY_DETAIL_ID,
130: to_number(null) DELIVERY_ID,
131: to_number(null) GENEALOGY_OBJECT_ID
132: FROM mtl_transaction_lot_numbers mtln ,
133: wip_entities we ,
134: mtl_system_items_vl msi ,
135: org_organization_definitions ood ,
136: mtl_material_transactions mmt ,

Line 188: mtl_transaction_lot_numbers mtln1 ,

184: NULL parent_lot_number ,
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 ,

Line 191: mtl_transaction_lot_numbers mtln ,

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 ,
194: mtl_system_items_vl msi ,
195: org_organization_definitions ood ,

Line 232: mtl_transaction_lot_numbers mtln ,

228: msn.inventory_item_id ,
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

Line 327: mtl_transaction_lot_numbers mtln ,

323: mtl_material_transactions mmt ,
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

Line 2466: FROM mtl_transaction_lot_numbers mtln ,

2462: AND mcr.cross_reference = ''YES'') serial_type,
2463: NULL parent_lot_number ,
2464: NULL parent_serial_number ,
2465: 0 parent_inventory_item_id
2466: FROM mtl_transaction_lot_numbers mtln ,
2467: wip_entities we ,
2468: mtl_system_items_vl msi ,
2469: org_organization_definitions ood ,
2470: mtl_material_transactions mmt ,

Line 2522: mtl_transaction_lot_numbers mtln1 ,

2518: NULL parent_lot_number ,
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 ,

Line 2525: mtl_transaction_lot_numbers mtln ,

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 ,
2528: mtl_system_items_vl msi ,
2529: org_organization_definitions ood ,

Line 2566: mtl_transaction_lot_numbers mtln ,

2562: msn.inventory_item_id ,
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

Line 2661: mtl_transaction_lot_numbers mtln ,

2657: mtl_material_transactions mmt ,
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