APPS.INV_WIP_PICKING_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 814: FROM mtl_txn_request_headers

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

Line 1605: FROM mtl_txn_request_headers moh

1601: UPDATE mtl_txn_request_lines mol
1602: SET mol.txn_source_line_id = p_op_seq_num
1603: WHERE mol.line_id = p_move_order_line_id
1604: AND EXISTS( SELECT ''
1605: FROM mtl_txn_request_headers moh
1606: WHERE moh.header_id = mol.header_id
1607: AND move_order_type = 5);
1608:
1609: IF SQL%NOTFOUND THEN

Line 1621: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol

1617: UPDATE mtl_material_transactions_temp mmtt
1618: SET mmtt.trx_source_line_id = p_op_seq_num
1619: WHERE mmtt.move_order_line_id = p_move_order_line_id
1620: AND EXISTS( SELECT ''
1621: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol
1622: WHERE mol.line_id = mmtt.move_order_line_id
1623: AND mol.header_id = moh.header_id
1624: AND move_order_type = 5);
1625: EXCEPTION