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 1838: UPDATE mtl_txn_request_lines

1834:
1835: --Update the MOL with unused qty to 1, because the TM will only
1836: --update wms_process_flag for the marked lines and not all
1837: --lines in a LPN as done in 11.5.10
1838: UPDATE mtl_txn_request_lines
1839: SET wms_process_flag = 1
1840: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
1841: END IF;
1842:

Line 2003: UPDATE mtl_txn_request_lines

1999:
2000: --Update the MOL with unused qty to 1, because the TM will only
2001: --update wms_process_flag for the marked lines and not all
2002: --lines in a LPN as done in 11.5.10
2003: UPDATE mtl_txn_request_lines
2004: SET wms_process_flag = 1
2005: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
2006: END IF;
2007:

Line 2186: UPDATE mtl_txn_request_lines

2182:
2183: --Update the MOL with unused qty to 1, because the TM will only
2184: --update wms_process_flag for the marked lines and not all
2185: --lines in a LPN as done in 11.5.10
2186: UPDATE mtl_txn_request_lines
2187: SET wms_process_flag = 1
2188: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
2189: END IF;
2190:

Line 2614: UPDATE mtl_txn_request_lines

2610:
2611: --Update the MOL with unused qty to 1, because the TM will only
2612: --update wms_process_flag for the marked lines and not all
2613: --lines in a LPN as done in 11.5.10
2614: UPDATE mtl_txn_request_lines
2615: SET wms_process_flag = 1
2616: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
2617: END IF;
2618:

Line 2776: UPDATE mtl_txn_request_lines

2772:
2773: --Update the MOL with unused qty to 1, because the TM will only
2774: --update wms_process_flag for the marked lines and not all
2775: --lines in a LPN as done in 11.5.10
2776: UPDATE mtl_txn_request_lines
2777: SET wms_process_flag = 1
2778: WHERE line_id = l_tmp_mmtt_rec.move_order_line_id;
2779: END IF;
2780: