APPS.INV_WIP_PICKING_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 819: FROM mtl_txn_request_headers

815: -- Verify that the move order type is of type Manufacturing Component Pick (5)
816: BEGIN
817: SELECT header_id, move_order_type, request_number
818: INTO l_mo_header_id, l_mo_type, l_mo_number
819: FROM mtl_txn_request_headers
820: WHERE header_id = p_mo_line_tbl(l_line_index).header_id;
821: EXCEPTION
822: WHEN NO_DATA_FOUND THEN
823: IF (l_debug = 1) THEN

Line 1653: FROM mtl_txn_request_headers moh

1649: UPDATE mtl_txn_request_lines mol
1650: SET mol.txn_source_line_id = p_op_seq_num
1651: WHERE mol.line_id = p_move_order_line_id
1652: AND EXISTS( SELECT ''
1653: FROM mtl_txn_request_headers moh
1654: WHERE moh.header_id = mol.header_id
1655: AND move_order_type = 5);
1656:
1657: IF SQL%NOTFOUND THEN

Line 1669: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol

1665: UPDATE mtl_material_transactions_temp mmtt
1666: SET mmtt.trx_source_line_id = p_op_seq_num
1667: WHERE mmtt.move_order_line_id = p_move_order_line_id
1668: AND EXISTS( SELECT ''
1669: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol
1670: WHERE mol.line_id = mmtt.move_order_line_id
1671: AND mol.header_id = moh.header_id
1672: AND move_order_type = 5);
1673: EXCEPTION