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_MATERIAL_TRANSACTIONS

Line 136: mtl_material_transactions mmt ,

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 ,
137: mtl_object_genealogy mog ,
138: mtl_lot_numbers mln
139: WHERE mmt.transaction_source_id+0 = we.wip_entity_id
140: AND msi.inventory_item_id = mmt.inventory_item_id+0

Line 187: FROM mtl_material_transactions mmt1 ,

183: AND mcr.cross_reference = ''YES'') serial_type,
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 ,

Line 190: mtl_material_transactions mmt ,

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

Line 235: mtl_material_transactions mmt ,

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
238: AND msn.inventory_item_id = r_item_id
239: AND mut.serial_number = r_serial_number

Line 323: mtl_material_transactions mmt ,

319: r_organization_id IN NUMBER)
320: IS
321: SELECT waid.genealogy_object_id
322: FROM mtl_object_genealogy mog ,
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 ,

Line 2142: mtl_material_transactions mmt ,

2138: BEGIN
2139: SELECT wnd.delivery_id
2140: INTO v_delivery_id
2141: FROM mtl_transaction_details_v mtd ,
2142: mtl_material_transactions mmt ,
2143: wsh_new_deliveries wnd
2144: WHERE mtd.object_id = v_top(i).object_id
2145: AND mmt.transaction_id = mtd.transaction_id + 0
2146: AND wnd.delivery_id = mmt.trx_source_delivery_id + 0;

Line 2165: mtl_material_transactions mmt ,

2161: BEGIN
2162: SELECT wnd.delivery_id
2163: INTO v_delivery_id1
2164: FROM mtl_transaction_details_v mtd ,
2165: mtl_material_transactions mmt ,
2166: wsh_new_deliveries wnd
2167: WHERE mtd.object_id = v_top(i).object_id
2168: AND mmt.transaction_id = mtd.transaction_id + 0
2169: AND wnd.delivery_id = mmt.trx_source_delivery_id + 0;

Line 2470: mtl_material_transactions mmt ,

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 ,
2471: mtl_object_genealogy mog ,
2472: mtl_lot_numbers mln
2473: WHERE mmt.transaction_source_id+0 = we.wip_entity_id
2474: AND msi.inventory_item_id = mmt.inventory_item_id+0

Line 2521: FROM mtl_material_transactions mmt1 ,

2517: AND mcr.cross_reference = ''YES'') serial_type,
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 ,

Line 2524: mtl_material_transactions mmt ,

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

Line 2569: mtl_material_transactions mmt ,

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
2572: AND msn.inventory_item_id = r_item_id
2573: AND mut.serial_number = r_serial_number

Line 2657: mtl_material_transactions mmt ,

2653: r_organization_id IN NUMBER)
2654: IS
2655: SELECT waid.genealogy_object_id
2656: FROM mtl_object_genealogy mog ,
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 ,

Line 4368: mtl_material_transactions mmt ,

4364: BEGIN
4365: SELECT wnd.delivery_id
4366: INTO v_delivery_id
4367: FROM mtl_transaction_details_v mtd ,
4368: mtl_material_transactions mmt ,
4369: wsh_new_deliveries wnd
4370: WHERE mtd.object_id = v_top(i).object_id
4371: AND mmt.transaction_id = mtd.transaction_id + 0
4372: AND wnd.delivery_id = mmt.trx_source_delivery_id + 0;

Line 4391: mtl_material_transactions mmt ,

4387: BEGIN
4388: SELECT wnd.delivery_id
4389: INTO v_delivery_id1
4390: FROM mtl_transaction_details_v mtd ,
4391: mtl_material_transactions mmt ,
4392: wsh_new_deliveries wnd
4393: WHERE mtd.object_id = v_top(i).object_id
4394: AND mmt.transaction_id = mtd.transaction_id + 0
4395: AND wnd.delivery_id = mmt.trx_source_delivery_id + 0;