APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3754: FROM mtl_material_transactions_temp

3750: ,transaction_batch_seq
3751: ,operation_plan_id
3752: ,move_order_header_id
3753: ,serial_allocated_flag
3754: FROM mtl_material_transactions_temp
3755: WHERE
3756: -- For call from putaway: p_operation_type will be null
3757: -- For call from item load putaway, type will be 'LOAD' or 'DROP'
3758: (((p_operation_type IS NULL OR p_operation_type IN ('LOAD','DROP'))

Line 3978: INSERT INTO mtl_material_transactions_temp

3974:
3975: l_new_mmtt_rec.transaction_quantity := l_temp;
3976:
3977: BEGIN
3978: INSERT INTO mtl_material_transactions_temp
3979: ( transaction_header_id
3980: ,transaction_temp_id
3981: ,source_code
3982: ,source_line_id

Line 4462: mtl_material_transactions_temp

4458: l_orig_mmtt_rec.secondary_transaction_quantity := l_orig_mmtt_rec.secondary_transaction_quantity - l_sec_qty_to_splt;
4459:
4460: BEGIN
4461: UPDATE
4462: mtl_material_transactions_temp
4463: SET
4464: primary_quantity = l_orig_mmtt_rec.primary_quantity
4465: ,transaction_quantity = l_orig_mmtt_rec.transaction_quantity
4466: , secondary_transaction_quantity = decode (l_orig_mmtt_rec.secondary_uom_code, NULL, NULL, l_orig_mmtt_rec.secondary_transaction_quantity)

Line 4617: UPDATE mtl_material_transactions_temp

4613: END IF;
4614:
4615: l_progress := '170';
4616: BEGIN
4617: UPDATE mtl_material_transactions_temp
4618: SET move_order_line_id = x_new_mol_rec.line_id
4619: WHERE transaction_temp_id = l_orig_mmtt_rec.transaction_temp_id;
4620: EXCEPTION
4621: WHEN OTHERS THEN

Line 4715: UPDATE mtl_material_transactions_temp

4711:
4712: l_progress := '220';
4713:
4714: BEGIN
4715: UPDATE mtl_material_transactions_temp
4716: SET move_order_line_id = x_new_mol_rec.line_id
4717: WHERE transaction_temp_id =
4718: l_orig_mmtt_rec.transaction_temp_id;
4719: EXCEPTION

Line 5957: FROM mtl_material_transactions_temp

5953: ,transaction_batch_seq
5954: ,operation_plan_id
5955: ,move_order_header_id
5956: ,serial_allocated_flag
5957: FROM mtl_material_transactions_temp
5958: WHERE transaction_temp_id = p_orig_mmtt_id;
5959:
5960: l_mmtt_rec mmtt_cur%ROWTYPE;
5961: l_new_mmtt_id NUMBER;

Line 6003: INSERT INTO mtl_material_transactions_temp

5999: l_mmtt_rec.transaction_quantity := p_prim_qty_to_splt;
6000: END IF;
6001:
6002: BEGIN
6003: INSERT INTO mtl_material_transactions_temp
6004: ( transaction_header_id
6005: ,transaction_temp_id
6006: ,source_code
6007: ,source_line_id

Line 6478: UPDATE mtl_material_transactions_temp

6474:
6475: x_new_mmtt_id := l_new_mmtt_id;
6476:
6477: BEGIN
6478: UPDATE mtl_material_transactions_temp
6479: SET transaction_quantity = transaction_quantity - l_mmtt_rec.transaction_quantity
6480: , primary_quantity = primary_quantity - l_mmtt_rec.primary_quantity
6481: WHERE transaction_temp_id = p_orig_mmtt_id;
6482: EXCEPTION