APPS.GME_COMMON_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2872: FROM mtl_material_transactions_temp t,

2868:
2869: IF p_invoke_mode = 'O' and l_dummy = 1 then
2870: BEGIN
2871: SELECT SUM(l.primary_quantity) into l_allocated_qty
2872: FROM mtl_material_transactions_temp t,
2873: mtl_txn_request_lines l,
2874: mtl_txn_request_headers h
2875: WHERE t.move_order_line_id = l.line_id
2876: AND t.move_order_header_id = h.header_id

Line 4267: mtl_material_transactions_temp mmtt

4263: CURSOR cur_get_mo_allocations (p_line_id NUMBER)
4264: IS
4265: SELECT mtlt.*
4266: FROM mtl_transaction_lots_temp mtlt,
4267: mtl_material_transactions_temp mmtt
4268: WHERE mmtt.move_order_line_id = p_line_id
4269: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
4270: /*SELECT mtlt.*
4271: FROM mtl_txn_request_lines mtrl

Line 4273: ,mtl_material_transactions_temp mmtt

4269: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
4270: /*SELECT mtlt.*
4271: FROM mtl_txn_request_lines mtrl
4272: ,mtl_transaction_lots_temp mtlt
4273: ,mtl_material_transactions_temp mmtt
4274: WHERE mtrl.line_id = p_line_id
4275: AND mtrl.txn_source_line_id = p_material_detail_id
4276: AND mtrl.line_id = mmtt.move_order_line_id
4277: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id; */