3871: );
3872: CURSOR c_mo_type
3873: IS
3874: SELECT mtrh.move_order_type
3875: FROM mtl_txn_request_headers mtrh,
3876: mtl_txn_request_lines mtrl
3877: WHERE mtrl.line_id = l_mo_line_rec.line_id
3878: AND mtrh.header_id = mtrl.header_id;
3879: CURSOR c_mmtt_info
4129: );
4130: CURSOR c_mo_type
4131: IS
4132: SELECT mtrh.move_order_type
4133: FROM mtl_txn_request_headers mtrh,
4134: mtl_txn_request_lines mtrl
4135: WHERE mtrl.line_id = l_transaction_record.move_order_line_id
4136: AND mtrh.header_id = mtrl.header_id;
4137: BEGIN