APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 156: FROM mtl_material_transactions_temp

152: END IF;
153: BEGIN
154: SELECT reason_id
155: INTO l_reason_id
156: FROM mtl_material_transactions_temp
157: WHERE transaction_temp_id = l_mmtt_temp_id;
158: EXCEPTION
159: WHEN OTHERS THEN
160: IF (l_debug = 1) THEN

Line 272: from mtl_txn_request_lines mtrl , mtl_material_transactions_temp mmtt

268: --bug 6412992
269: IF( inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j AND l_wip_entity_id is NULL) then
270: BEGIN
271: select backorder_delivery_detail_id into l_wip_entity_id
272: from mtl_txn_request_lines mtrl , mtl_material_transactions_temp mmtt
273: where mmtt.transaction_temp_id = l_mmtt_temp_id
274: and mtrl.line_id = mmtt.move_order_line_id
275: and mtrl.CROSSDOCK_TYPE = 2;
276: EXCEPTION

Line 920: FROM mtl_material_transactions_temp

916: , l_content_lpn_id
917: , p_rcv_transaction_rec.cost_group_id
918: , p_rcv_transaction_rec.put_away_rule_id
919: , p_rcv_transaction_rec.put_away_strategy_id
920: FROM mtl_material_transactions_temp
921: WHERE transaction_temp_id = p_original_txn_temp_id;
922: EXCEPTION
923: WHEN OTHERS THEN
924: IF (l_debug = 1) THEN

Line 2499: FROM mtl_material_transactions_temp

2495: IF (l_orig_mol_id IS NULL) THEN
2496: BEGIN
2497: SELECT move_order_line_id
2498: INTO l_orig_mol_id
2499: FROM mtl_material_transactions_temp
2500: WHERE transaction_temp_id = p_original_txn_temp_id;
2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: IF (l_debug = 1) THEN

Line 2539: FROM mtl_material_transactions_temp

2535:
2536: BEGIN
2537: SELECT transaction_temp_id
2538: INTO l_new_txn_temp_id
2539: FROM mtl_material_transactions_temp
2540: WHERE move_order_line_id = l_mo_splt_tb(1).line_id;
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: IF (l_debug = 1) THEN

Line 3193: FROM mtl_material_transactions_temp

3189: IF (l_orig_mol_id IS NULL) THEN
3190: BEGIN
3191: SELECT move_order_line_id
3192: INTO l_orig_mol_id
3193: FROM mtl_material_transactions_temp
3194: WHERE transaction_temp_id = p_original_txn_temp_id;
3195: EXCEPTION
3196: WHEN OTHERS THEN
3197: IF (l_debug = 1) THEN

Line 3232: FROM mtl_material_transactions_temp

3228:
3229: BEGIN
3230: SELECT transaction_temp_id
3231: INTO l_new_txn_temp_id
3232: FROM mtl_material_transactions_temp
3233: WHERE move_order_line_id = l_mo_splt_tb(1).line_id;
3234: EXCEPTION
3235: WHEN OTHERS THEN
3236: IF (l_debug = 1) THEN

Line 3834: FROM mtl_material_transactions_temp

3830: IF (l_orig_mol_id IS NULL) THEN
3831: BEGIN
3832: SELECT move_order_line_id
3833: INTO l_orig_mol_id
3834: FROM mtl_material_transactions_temp
3835: WHERE transaction_temp_id = p_original_txn_temp_id;
3836: EXCEPTION
3837: WHEN OTHERS THEN
3838: IF (l_debug = 1) THEN

Line 3873: FROM mtl_material_transactions_temp

3869:
3870: BEGIN
3871: SELECT transaction_temp_id
3872: INTO l_new_txn_temp_id
3873: FROM mtl_material_transactions_temp
3874: WHERE move_order_line_id = l_mo_splt_tb(1).line_id;
3875: EXCEPTION
3876: WHEN OTHERS THEN
3877: IF (l_debug = 1) THEN