APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 154: FROM mtl_material_transactions_temp

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

Line 896: FROM mtl_material_transactions_temp

892: , l_content_lpn_id
893: , p_rcv_transaction_rec.cost_group_id
894: , p_rcv_transaction_rec.put_away_rule_id
895: , p_rcv_transaction_rec.put_away_strategy_id
896: FROM mtl_material_transactions_temp
897: WHERE transaction_temp_id = p_original_txn_temp_id;
898: EXCEPTION
899: WHEN OTHERS THEN
900: IF (l_debug = 1) THEN

Line 2465: FROM mtl_material_transactions_temp

2461: IF (l_orig_mol_id IS NULL) THEN
2462: BEGIN
2463: SELECT move_order_line_id
2464: INTO l_orig_mol_id
2465: FROM mtl_material_transactions_temp
2466: WHERE transaction_temp_id = p_original_txn_temp_id;
2467: EXCEPTION
2468: WHEN OTHERS THEN
2469: IF (l_debug = 1) THEN

Line 2505: FROM mtl_material_transactions_temp

2501:
2502: BEGIN
2503: SELECT transaction_temp_id
2504: INTO l_new_txn_temp_id
2505: FROM mtl_material_transactions_temp
2506: WHERE move_order_line_id = l_mo_splt_tb(1).line_id;
2507: EXCEPTION
2508: WHEN OTHERS THEN
2509: IF (l_debug = 1) THEN

Line 3097: FROM mtl_material_transactions_temp

3093: IF (l_orig_mol_id IS NULL) THEN
3094: BEGIN
3095: SELECT move_order_line_id
3096: INTO l_orig_mol_id
3097: FROM mtl_material_transactions_temp
3098: WHERE transaction_temp_id = p_original_txn_temp_id;
3099: EXCEPTION
3100: WHEN OTHERS THEN
3101: IF (l_debug = 1) THEN

Line 3136: FROM mtl_material_transactions_temp

3132:
3133: BEGIN
3134: SELECT transaction_temp_id
3135: INTO l_new_txn_temp_id
3136: FROM mtl_material_transactions_temp
3137: WHERE move_order_line_id = l_mo_splt_tb(1).line_id;
3138: EXCEPTION
3139: WHEN OTHERS THEN
3140: IF (l_debug = 1) THEN

Line 3720: FROM mtl_material_transactions_temp

3716: IF (l_orig_mol_id IS NULL) THEN
3717: BEGIN
3718: SELECT move_order_line_id
3719: INTO l_orig_mol_id
3720: FROM mtl_material_transactions_temp
3721: WHERE transaction_temp_id = p_original_txn_temp_id;
3722: EXCEPTION
3723: WHEN OTHERS THEN
3724: IF (l_debug = 1) THEN

Line 3759: FROM mtl_material_transactions_temp

3755:
3756: BEGIN
3757: SELECT transaction_temp_id
3758: INTO l_new_txn_temp_id
3759: FROM mtl_material_transactions_temp
3760: WHERE move_order_line_id = l_mo_splt_tb(1).line_id;
3761: EXCEPTION
3762: WHEN OTHERS THEN
3763: IF (l_debug = 1) THEN