APPS.WMS_RCV_PUP_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 800: mtl_txn_request_lines mtrl

796: BULK COLLECT INTO
797: l_txn_tmp_id_tb
798: FROM
799: mtl_material_transactions_temp mmtt,
800: mtl_txn_request_lines mtrl
801: WHERE
802: ( ( mmtt.transaction_source_type_id = 1 AND
803: mmtt.transaction_action_id = 27) OR
804: ( mmtt.transaction_source_type_id = 7 AND

Line 921: FROM mtl_txn_request_lines

917: ,reference_type_code
918: ,revision
919: ,lot_number
920: ,inspection_status
921: FROM mtl_txn_request_lines
922: WHERE line_id = l_line_id;
923:
924: --BUG 3634192: Break up the tmp_mmtt_cur cursor into 2. This
925: --is made for performance reasons

Line 1798: UPDATE mtl_txn_request_lines

1794:
1795: --Update the MOL with unused qty to 1, because the TM will only
1796: --update wms_process_flag for the marked lines and not all
1797: --lines in a LPN as done in 11.5.10
1798: UPDATE mtl_txn_request_lines
1799: SET wms_process_flag = 1
1800: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
1801: END IF;
1802:

Line 1962: UPDATE mtl_txn_request_lines

1958:
1959: --Update the MOL with unused qty to 1, because the TM will only
1960: --update wms_process_flag for the marked lines and not all
1961: --lines in a LPN as done in 11.5.10
1962: UPDATE mtl_txn_request_lines
1963: SET wms_process_flag = 1
1964: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
1965: END IF;
1966:

Line 2144: UPDATE mtl_txn_request_lines

2140:
2141: --Update the MOL with unused qty to 1, because the TM will only
2142: --update wms_process_flag for the marked lines and not all
2143: --lines in a LPN as done in 11.5.10
2144: UPDATE mtl_txn_request_lines
2145: SET wms_process_flag = 1
2146: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
2147: END IF;
2148:

Line 2570: UPDATE mtl_txn_request_lines

2566:
2567: --Update the MOL with unused qty to 1, because the TM will only
2568: --update wms_process_flag for the marked lines and not all
2569: --lines in a LPN as done in 11.5.10
2570: UPDATE mtl_txn_request_lines
2571: SET wms_process_flag = 1
2572: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
2573: END IF;
2574:

Line 2731: UPDATE mtl_txn_request_lines

2727:
2728: --Update the MOL with unused qty to 1, because the TM will only
2729: --update wms_process_flag for the marked lines and not all
2730: --lines in a LPN as done in 11.5.10
2731: UPDATE mtl_txn_request_lines
2732: SET wms_process_flag = 1
2733: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
2734: END IF;
2735: