APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3685: FROM mtl_material_transactions_temp

3681: ,transaction_batch_seq
3682: ,operation_plan_id
3683: ,move_order_header_id
3684: ,serial_allocated_flag
3685: FROM mtl_material_transactions_temp
3686: WHERE
3687: -- For call from putaway: p_operation_type will be null
3688: -- For call from item load putaway, type will be 'LOAD' or 'DROP'
3689: (((p_operation_type IS NULL OR p_operation_type IN ('LOAD','DROP'))

Line 3909: INSERT INTO mtl_material_transactions_temp

3905:
3906: l_new_mmtt_rec.transaction_quantity := l_temp;
3907:
3908: BEGIN
3909: INSERT INTO mtl_material_transactions_temp
3910: ( transaction_header_id
3911: ,transaction_temp_id
3912: ,source_code
3913: ,source_line_id

Line 4393: mtl_material_transactions_temp

4389: l_orig_mmtt_rec.secondary_transaction_quantity := l_orig_mmtt_rec.secondary_transaction_quantity - l_sec_qty_to_splt;
4390:
4391: BEGIN
4392: UPDATE
4393: mtl_material_transactions_temp
4394: SET
4395: primary_quantity = l_orig_mmtt_rec.primary_quantity
4396: ,transaction_quantity = l_orig_mmtt_rec.transaction_quantity
4397: , secondary_transaction_quantity = decode (l_orig_mmtt_rec.secondary_uom_code, NULL, NULL, l_orig_mmtt_rec.secondary_transaction_quantity)

Line 4548: UPDATE mtl_material_transactions_temp

4544: END IF;
4545:
4546: l_progress := '170';
4547: BEGIN
4548: UPDATE mtl_material_transactions_temp
4549: SET move_order_line_id = x_new_mol_rec.line_id
4550: WHERE transaction_temp_id = l_orig_mmtt_rec.transaction_temp_id;
4551: EXCEPTION
4552: WHEN OTHERS THEN

Line 4646: UPDATE mtl_material_transactions_temp

4642:
4643: l_progress := '220';
4644:
4645: BEGIN
4646: UPDATE mtl_material_transactions_temp
4647: SET move_order_line_id = x_new_mol_rec.line_id
4648: WHERE transaction_temp_id =
4649: l_orig_mmtt_rec.transaction_temp_id;
4650: EXCEPTION

Line 5888: FROM mtl_material_transactions_temp

5884: ,transaction_batch_seq
5885: ,operation_plan_id
5886: ,move_order_header_id
5887: ,serial_allocated_flag
5888: FROM mtl_material_transactions_temp
5889: WHERE transaction_temp_id = p_orig_mmtt_id;
5890:
5891: l_mmtt_rec mmtt_cur%ROWTYPE;
5892: l_new_mmtt_id NUMBER;

Line 5934: INSERT INTO mtl_material_transactions_temp

5930: l_mmtt_rec.transaction_quantity := p_prim_qty_to_splt;
5931: END IF;
5932:
5933: BEGIN
5934: INSERT INTO mtl_material_transactions_temp
5935: ( transaction_header_id
5936: ,transaction_temp_id
5937: ,source_code
5938: ,source_line_id

Line 6409: UPDATE mtl_material_transactions_temp

6405:
6406: x_new_mmtt_id := l_new_mmtt_id;
6407:
6408: BEGIN
6409: UPDATE mtl_material_transactions_temp
6410: SET transaction_quantity = transaction_quantity - l_mmtt_rec.transaction_quantity
6411: , primary_quantity = primary_quantity - l_mmtt_rec.primary_quantity
6412: WHERE transaction_temp_id = p_orig_mmtt_id;
6413: EXCEPTION