APPS.WMS_PARAMETER_EXT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 94: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

90: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
91:
92: cursor get_mo_line_info is
93: select mtrl.reference, mtrl.reference_id, mtrl.line_id, mmtt.transaction_source_type_id
94: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
95: where mtrl.line_id = mmtt.move_order_line_id
96: and mmtt.transaction_temp_id = p_transaction_id;
97:
98: begin

Line 240: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

236: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
237:
238: cursor get_mo_line_info is
239: select mtrl.reference, mtrl.reference_id, mtrl.line_id, mmtt.transaction_source_type_id
240: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
241: where mtrl.line_id = mmtt.move_order_line_id
242: and mmtt.transaction_temp_id = p_transaction_id;
243:
244: begin

Line 490: from mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

486: select mmtt.organization_id, mmtt.inventory_item_id,
487: nvl(mmtt.transfer_subinventory, mmtt.subinventory_code),
488: nvl(mmtt.transfer_to_location, mmtt.locator_id),
489: mtlt.lot_number
490: from mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
491: where mmtt.transaction_temp_id = mtlt.transaction_temp_id
492: and mmtt.transaction_temp_id = p_transaction_id;
493:
494: begin